Btrieve doesn't use SQL statements.
If you want to open files in Btrieve API, you have to specify the file name on the Open call. You can also use the URI to specify the table name or filename.
The samples in the INTF directory for the language (C or Delphi) should give you a basic idea of how to connect, retrieve, and insert data.
If you have specific questions, please feel free to post them.
__________________
Mirtheil Software
Certified Pervasive Developer
Certified Pervasive Technician
Custom Btrieve/VB development
http://www.mirtheil.com
I do not answer questions by email. Please post on the forum.