 |
|
 |
Hi,
do you now db4o ?? That sql stuff is a pain. If you use db40 you save yourself 90 % of the work and users only need to copy one dll, thats all !
Check it out at www.db4o.com.
I have LOTS of trouble with that database, but only because I tried to use it in client/server mode for a professional application. They are not ready for this yet, but for embedded applications its a dream !
Let me know if such a move is feasable. I dont want to install and mess anymore with sql !
Thanks !
Joe Robe
|
|
|
|
 |
|
 |
I install the Code Mange from the setup and created the database as instructed. Setup the user RADDev and added the registry entry. I am able to open the Code Manager's FormAddin Tools window in the IDE. When I try to test the connection, it say user "bugspray" is not connected to the db. So I added the user account "bugspray" and password "bugspray" in the the RADDev database. I am able to add category to the code lib and add code. I was able to edit the snippet and it shows the saved code. But when I try to add a save code into my project I get blank under the "Code" table and my "Description" tab shows the text I entered when I saved the snippet. Nothing was inserted when "insert" button was click.
How can I get the add-in to work???
Thanks
Haichih (CAI)
|
|
|
|
 |
|
 |
Hi, the view "proc_SelectCodeEntry" retuns a null value for the field "CodeEntryDescription"(the table tblCodeEntryType has no values), this causes an exception in the form "frmViewCode.vb" (row 221) that causes the function "InitialiseCodeDetails" to exit without warnings. A fast (and dirty) solution is to update the view this way:
ALTER PROCEDURE dbo.proc_SelectCodeEntry
@CodeEntryID int AS
Select
longdesc, dateadded, shortdesc, firstname, lastname, '' as CodeEntryDescription, CodeText
from
tblCodeEntry
left join tbluser on tbluser.user_id = tblCodeEntry.userid
where entryid = @CodeEntryID
hope it helps
kScope
|
|
|
|
 |
|
 |
Hi Paul,
I came across this tool of yours today and it seems to be very helpful. While trying to run it I am facing this problem while making Database settings through Raddev option. when i set server and database, I get this error "Connection Failed : Login failed for user 'Bugspray'".
Please help!
Ashu Sharma
Web Analyst
|
|
|
|
 |
|
 |
Hi,
You need to follow these steps to get it working:
- Run the setup
- Create a database RadDev
- Create an SQL login raddev with a password of raddev (this is hardcoded)
- Make the raddev login a user in the RadDev DB and make it the dbowner. I think that there's a problem with the SQL script as the permissions were insufficient.
- Run the SQL script in the RadDev db
- Add the following settings to the registry
[HKEY_CURRENT_USER\Software\VB and VBA Program Settings\RadDev\General]
"DBServer"="yourservernamehere"
"Database"="RadDev"
If these values are not here then the toolbar won't appear, so you can't change the options to add the values...catch-22...
When you run VS, and start the addin, create a new user. It should pop a box to say that it has done this.
Then restart Visual Studio.
That's as far as I've got so far but it looks to be OK now.
Best regards
Steve
http://stevehurcombe.blogspot.com
|
|
|
|
 |
|
 |
Thanks for providing the instructions steve, the script i had was injecting into another database hence the wrong username. Sorry im flat out i would create the right script but i dont have time right now. If someone would like to send it me i will update the downloadable.
This is my rifle
There are many like it, but
This rifle is mine
|
|
|
|
 |
|
 |
DRY (Don't repeat yourself) code means that when things change or you have a defect to fix you only have to make a change in one place. Tools like this fly in the face of writing DRY code because they enable the coping of code. Whenever you are coping code you are probably doing something wrong. A better alternative is to create a core object library to include in all your projects. My problem isn't with the add in itself (I'm sure it's a nice add in) just the concept. I also thought it would make for an interesting discussion.
|
|
|
|
 |
|
 |
I hear you and i agree with the principle (read that acronym in a book, programmer as craftsman, 'the pragmatic programmer'?). We did have a core library, which got used a lot more. In reality its more useful for javascript/html/TSQL; the code that cant naturally go in your object library. But it was used a lot. There is a review and edit mechanism in there too so you can improve code. Code tends to move out of the plug-in and into the object library over time. There are many ways to reuse code;
-The shared code library (look at codeproject/internet resources itself, think of it as a smaller/local (but faster) version of that)
-Object libraries
-3rd party component libraries
-Code from older projects that achieves a given techniques
-Code generation (ie CodeSmith)
This is written in the past tense as actually the company in question have no idea whatsoever about software development, so i left very recently. Its a dilberts history of mismanagement which i may relate one day.
This is my rifle
There are many like it, but
This rifle is mine
|
|
|
|
 |
|
 |
I agree with your comment entirely. However, I wrote myself a tool much like this, myself. Not because I like the idea of having code snippets I can copy and paste, but to have purely as an algorithm reference. I would have a category for "Sorting Algorithms" for example, in which I would have some implementation of a Bubble Sort, a Merge Sort, etc... It would just be a reference, and more like a Knowledge Base than a whole lot of code I could re-use in production. Maybe it's different in that respect, because the code in there was always written to be "illustrative and educational" rather than "off the shelf reusable."
|
|
|
|
 |
|
 |
Hi Paul,
I'm really keen on getting this plugin to work, because I was searching for something like this a long time. But it doesn't seem to work - probably only the way I install it ?
Here the steps I did:
1.) Made a new SQL-DB called "RADDev"
2.) set up new user "raddev" pw "raddev" with admin-rights (for testing)
3.) run the sql-db-script you provided - successfully.
4.) installed your application
5.) registered the vsusercontrol.dll via regsvr32
6.) started Visual Studio .NET 2003
a.) a Dialog appeared, asking me to add myself as a user. So I did, completed the registration Form, pressed ok. This operation seemed to take a few seconds to complete, but the initial dialog doesn't disappear. I pressed ok. Nothing happened. I pressed ok the second time, then the dialog disappeared, VS started normally.
As I then used VS and loaded a project, everything was the way it was before - no trace from the addin. But in Addin-Manager, it appeared and was checked to be loaded. How do I "activate" it? Even as I checked the contents of the tblUsers in SQL, there was no entry.
Could you give me a hint how I could get it to work? Would be GREAT!
Thx in Advance,
Eddy
|
|
|
|
 |
|
 |
it must be working, as it prompted you to add the user, so the plug-in is installed and running. Have a look in the db, see if you can find your useraccount in there, and it has the correct windows username and domain. Make sure your user has access to all the tables.
Have you looked on your menu? If the add-in is installed, it should show in the menu.
Another suggestion is download the source, and run it from there.
|
|
|
|
 |
|
 |
Not to belittle the time you spent on this (especially vacation time--been there, done that too), I would personally have simply set up a web site with a wiki on it. It's easy to categorize, create cross referencing, a wiki will automatically generate an index for you, and others can easily make additions and updates. And even better, the changes are logged, can be reverted, and you can use an RSS feed! And finally, it's tool independent.
Marc
MyXaml
Advanced Unit Testing
YAPO
|
|
|
|
 |
|
 |
We already had a web based shared code library - but it didnt work, too slow to use, thats why i wanted something within the IDE.
This is my rifle
There are many like it, but
This rifle is mine
|
|
|
|
 |
|
 |
I Created a user "raddev" to the database. Does this user requires a password? or Is the security integrated?
Thanks,
Ermias
|
|
|
|
 |
|
 |
you should create a sql server login called raddev that has permissions to use the db and execute all the stored proces, and which has a password set. The app.config files contain the connection strings.
This is my rifle
There are many like it, but
This rifle is mine
|
|
|
|
 |
|
|
 |
|
 |
App.config is only available if you are building the codeset. Make sure sql user/pass are raddev/raddev.
This is my rifle
There are many like it, but
This rifle is mine
|
|
|
|
 |
|
 |
Sorry but how do I set the data source name if no app.config is available?
|
|
|
|
 |
|
 |
In the options dialog after its installed you can set the datasource name. It might be easier to stick with the default of raddev...
This is my rifle
There are many like it, but
This rifle is mine
|
|
|
|
 |
|
 |
Thank you, it works now but I had to manually editing the registry.
The problem now is that when i double click on an entry previusly created the code is not displayed (it is displayed correctly when I edit the entry)... any idea?
Thank you
|
|
|
|
 |
|
 |
You said you had to remove a few dll's from the zip, but you never said you had to remove the zip file completely. I do not see a download. I would love to be able to see you code for this project.
John Hidey
John@Hidey.com
|
|
|
|
 |
|
 |
Yes! They disappeared during the edit process, i will correct it now.
This is my rifle
There are many like it, but
This rifle is mine
|
|
|
|
 |
|
 |
Corrected - The downloads should be available now.
This is my rifle
There are many like it, but
This rifle is mine
|
|
|
|
 |
|
 |
I had to remove a lot of dlls and the Host project due to the size of the uploads exceeding the allowed 2mb limit. I will update the articles text over the coming days.
This is my rifle
There are many like it, but
This rifle is mine
|
|
|
|
 |
|
|
 |