Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations Mike Lewis on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

SQL SELECT statement in the VdB

Status
Not open for further replies.

IlyaRabyy

Programmer
Nov 9, 2010
568
US
Colleagues,

Judging by the description given in the VdB (ver. 5.7) Help, the following command should work:
Code:
select * from MyTblAlias where FormID="RetForm1" save to table D:\Temp\RetForm1.DBF
but it ain't: it errs with "Database Engine Error: Token not found". The same happens when I try
Code:
select * from "D:\MyTables\MyTbl.DBF" where FormID="RetForm1" save to table "D:\Temp\RetForm1.DBF"
and anything in between these two extremities. The VdB's Help ain't no help at all (calambour's unintentional).
What am I doing wrong?
TIA!

Regards,

Ilya
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top