Rob Porter 22.Jan.10 11:39 AM a Web browser LC LSX LEI - 6.5 All Platforms
An agent which has been running fine for months has started misbehaving. The Lcfieldlist object contains only one record instead of the slightly more than 20,000 it should. I have not changed the LotusScript code, so the only thing I can think is that something on the SQL Server side has changed.
The SQL database was modified recently (a few extra columns were added to a table) but I can't see that should cause problems.
If I execute the SQL statement "SELECT * FROM MYTABLE" in the SQL Server Management Studio it returns all 20,000 records, but if I execute the same select statement from LotusScript I only get back the first record in the table.
I'm probably missing something obvious, but if any of you can think of a reason why my agent is experiencing this problem I would be very grateful.