PDA

View Full Version : ADO Loop error


jkurtis
01-28-2011, 09:49 AM
I'm trying to call a SQL Stored proc from an ADO action, loop over the resulting record set and do something with it and am having some problems.

My ADO call works fine.
My next step is a loop over the %ADO_RS%. This works fine.
The problem is inside of the loop. At this point I'm trying to log the message and am receiving the following error:

Error expanding macros or script in property Message: <Error in System (VBScript) script code at Line 21, Column 2 (Object required: 'vbld_TempMacro(...)')>


I'm attaching my build script for examination. if anyone has any idea whats going on I'd appreciate the help.

Thanks

jkurtis
01-28-2011, 10:08 AM
Odd -- I think I solved this problem. I was selecting everything and choosing "Rebuild Selected". From the menu bar, if i select "Build -> Rebuild" I don't get the error and my loop works correctly.

No idea what the difference is, but its working now.

kinook
01-28-2011, 10:14 AM
http://www.kinook.com/Forum/showthread.php?threadid=927