The SQLFirst function is a SQL function that moves the data position to the first field of the selected data with SQLSelect.
void @SQLFirst(int id);
Parameters
int id : Access number connected by SQLConnect
Return Value
None
Example1
@SQLFirst($AddrID);
Description : Move the data location to the first field in the linked database.
Example2
id = @SQLConnect("ODBCDNSName","","");
@SQLSelect(id,"Table1","BindList","","");
@SQLFirst(id);
Description : If you set it up like above, ODBC will load all the records in Table1 from the database with the DNS name you set up, and the first record of these records will be loaded.
Related Helps