Contributions
- 1.3KViews0likes0Comments
Re: Compare ADOTables
Okay, well I figured out the whole pulling NULL values but I noticed that the message it's supposed to log...doesn't. Is it not possible for this to work? All I get is a line that reads "Result:1". I'd really like to be able to show the result as NULL. Even if I change the message to a straight "The value is NULL" I get the same "Result:1" response. What am I doing wrong? While Not Before.EOF If Before.FieldByName("BatchID").Value= NULLThen Log.Message CStr(Before.FieldByName("BatchID").Value) End If Before.Next WEnd Thanks!!1.3KViews0likes0CommentsRe: Compare ADOTables
Thanks, I'll try that too. Another question about the ADOTable script. How do I write it to pull a value that is NULL? Is it just like SQL, or can I enter Value = NULL? I've tried several different ways but can't tell if it's actually working because the test is still running after 30 minutes. I know that table has over 2.5 million rows so that's probably the cause for the prolonged duration but I would at least like to make sure I'm entering the request correctly. Thanks!!1.3KViews0likes0CommentsCompare ADOTables
I'm in need of assistance. I've written the script to create an ADOTable off of a DB table, call a Stored Proc to make updates to that DB table and then create another ADOTable of the same DB table. But now I'm at a standstill as to figuring out how to compare the two ADOTables to confirm the updates. I know about the DBTables.Compare against a Store but not so sure where to go with comparing the ADOTables. Any help anyone could provide is greatly appreciated. (I'm still very green on Scripting, so please bear with me.)11KViews0likes7CommentsFor Loop exception message
I am trying to run For Loop on a DB Table variable but when I run the test I get the message "variable specified as the Loop Counter is of an invalid type. Expected types: Integer, Double". The only type I inputted was Integer. I've never had this message on other tests. Assistance, please?11KViews0likes3CommentsRe: DBTable loops through Web Services
We have a web service that sends an automated email based mostly on AccountIDs from the database. I want to loop the AccountIDs for certain email types through the web service to send an email to a test account. Then I want to Compare Files from the email received at the test account against a PDF stored in the database of what was actually sent to the customer to ensure identical data. But I can't seem to figure out how to loop data through the web service without writing the test line by line (which would be a few thousand AccountIDs for around 25 different email types). Any help would be lovely :)826Views0likes0Comments