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.

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.