Recent content by jtseltmann

g, one question..from what I am reading...sqlcmd utility runs a file..and I have a stored procedure in my target database that I want to execute.

Thanks gmmastros. I am familiar with that and do use it in another area. I'm not familiar with how to use it and pass input parameters to the proc. I'll have to review the doc for that utility. Thanks. J

I have a bunch of stored procedures that I call from my vb6 app and they work great. The problem is that some new ones may be very long. Is there a way to open the connection, call the proc using ado and then finish and let the proc run in the background? I'm not finding much at all when I...

Thank you..i figured. The problem I found was that it seems SQL requires that you reset the output parameter to '' before each call to the proc that you want it returned from. e.g. in the proc below if you don't reset @output1 = '' before each call the param is not set. It is the same value...

I have one main stored proc that sets a table variable and then loops through the records. After setting the vars I call my other proc that has an output param I need. As I perform the loop...the input to the 2nd proc changes and I expect the output param to change was well. I can verify...

I didn't need to being that I knew how to get around it. As I said, I was just looking for confirmation that I was truly executing the code incorrectly. I got that confirmation and have the code I need working just fine. Thanks

I guess a better way would be that I thought this code was working in other places and I have seen examples before where there was a complete path to a sub dir and I guess I mistook that for the above. I can write a routine that loops through and does each but I thought that I had run this...

Can anyone help me understand why the following is failing? '--- Dim fso as object Set fso = CreateObject("Scripting.FileSystemObject") fso.CreateFolder "H:\data\temp" '--- I get a 76 - path not found error every time If I change the above code to run this it works... fso.CreateFolder...

Sabrina, I'm not sure what you are asking for...you can concatenate the old table name with the current date to get the "new" table name. strNewtablename = "OLDTABLENAME" & Replace(Date(),"/","") If the table name was "MYTABLE" you would get: strNewtablename = "MYTABLE10102008

ok I should have been more clear..i've never used object browser to see that information. I guess I don't know how to do what you are saying. I always use the IDE to control properties to attach code to events or through the drop downs in the code window. I didn't mean I had no idea what it...

Honestly I haven't but how would that help me? Any tricks that I don't know about?

Inky, Thanks for the reply and yes I have worked in both and seen the differences. I guess I was just wondering why the same control would have such limited functionality from one to the other being that it is a Microsoft control. I didn't expect to see 4- 5 events with that control where...

Sorry forgot to add the tablename portion...you could use the following: strNewtablename = Replace(Date(),"/","")

An easy way to copy a table is to use : DoCmd.SetWarnings False DoCmd.RunSQL "SELECT * INTO newtablename FROM oldtablename WHERE 1=2" DoCmd.SetWarnings True This will copy the table dict to a new tablename of your choice without data. REmove out the where 1=2 to copy data too.

or do the same as the above with using "Select MAX Visit from tablename where individual = 'a'" and then increment that by 1.