DatabaseRetreive should be used with SELECT statements only (see documentation for details). DatabaseExecute can be used to execute stored procedures. : The DatabaseRetreive command is executing a stored procedure on a SQL Server : 7 database twice. : The stored procedure returns the next valid record from a table and marks : that record as being checked out. The procedure returns the data from the : record to the scheduler. What we are seeing is that the data returned by : the DatabaseRetreive command is always the second valid record.
|