lnHandle=SQLStringConnect("Driver={Microsoft Visual FoxPro Driver};SourceType=DBF;SourceDB=d:\data;Exclusive=No;NULL=NO; Collate=Machine;BACKGROUNDFETCH=NO;DELETED=NO")lnHandle contains a valid ID. If I do the command again, lnHandle increments by one. So, this shows that the connection is valid.
? SQLEXEC(lnHandle,"SELECT * FROM Customer")It always return -1. What am I missing?