SQLEXEC( ) example

The following example executes an SQL SELECT statement on the server table Company:

SET DBTYPE TO DBASE
OPEN DATABASE CAClients
SET DATABASE TO CAClients
errorCode = SQLEXEC("SELECT Company, City ;
FROM Company WHERE State_Prov='CA'", "StateCA.DBF")
IF errorCode = 0
 SET DATABASE TO
 USE StateCa
 LIST
ENDIF
RETURN