One Record at A Time
This example (by Jeff) shows you “one record at a time”; for example if you use a SELECT statement in SQL.
It helps to have the error cluster displayed, in order to catch errors in your SQL statements.
Let’s discuss how to implement this code with standard ADO functions.
1: Connection: You create a Connection Object with Connection Create. Then connect to with the DSN name and Connection Open.
2: Create a Command: You create a command object with Command Create, set the text with Command Set Command Text), select the active connection with Command Set Active Connection fest. Then Command Execute, which returns a Recordset. Destroy your Command object, you won’t need it no longer.
3: Loop through Recordset: If you haven’t reached Recordset EOF yet, get a line with Recordset Get String.
4: End: Connection Close+ Connection Destroy.
Same thing, from the examples. More efficient with the SQL Exectue, different UI. He should have destroyed the Connection Object, though.