Viewing 15 posts - 1,711 through 1,725 (of 6,216 total)
I agree less is better, but I'd bet that since you still have to send it a packet at a time, you can probably get the param name in the...
August 26, 2003 at 5:23 am
Possibly you can just update the system tables, havent tried to know if there gotchas looming. Just about as easy to just use a cursor to loop through - remember...
August 25, 2003 at 4:10 am
A variation of this is to open and hold an ADO connection. If you use the events associated with the connection, one event will fire as soon as the connection...
August 25, 2003 at 4:08 am
August 25, 2003 at 4:07 am
No pressure to change. Though if we meet at a conf or whatever, I'll just call you 54 for short.
Andy
August 25, 2003 at 4:05 am
SP_executesql probably the easiest way. I almost always typed my params before, only time I didnt was the occasional "cn.execute procname" with no params, other than that it was always...
August 25, 2003 at 4:03 am
Break it up into two steps. One step being some code that will run the proc, the other a macro to call the code. Not certain, but I think in...
August 25, 2003 at 4:00 am
I dont think you can modify it. Im surprised CDATA didnt handle it. What char? How about fixing it with a replace in the proc?
Andy
August 25, 2003 at 3:59 am
I think seniors have less reluctance to ask for help if they need it. Jrs think it shows weakness!
Andy
August 25, 2003 at 3:46 am
Including your URL in email is a good step. We've relied mainly on word of mouth - it's slower than some methods, but solid. In the last few months we've...
August 25, 2003 at 3:44 am
Should be doable. Access supports both autoexec and named macros as I remember, you just pass a command line switch. I'd suggest using a batch file to get it to...
August 25, 2003 at 3:42 am
I think so, thought I have not tested. In ActiveX steps any error will fail the step, as will returning any non zero value from a OS task.
Yes, a table...
August 25, 2003 at 3:40 am
August 21, 2003 at 5:34 pm
SP_executesql isnt that bad, it does try to re-use the query plan, but not as good as a stored proc - both because the proc is already compiled and because...
August 21, 2003 at 5:32 pm
Hey look, it changed! For those following the thread, Frank used to be: a5xo3z1
Andy
August 21, 2003 at 5:29 pm
Viewing 15 posts - 1,711 through 1,725 (of 6,216 total)