Subject Re: Command Window Commands From Mervyn Bick <invalid@invalid.invalid> Date Thu, 20 May 2021 09:15:49 +0200 Newsgroups dbase.getting-started On 2021/05/20 07:55, Gaetano D. wrote: > > I put the following in a PRG file and ran the file. It did what was > expected. It worked equally fine from the command window: > > SELECT * FROM sample WHERE amount=10 ORDER BY trandate SAVE TO > sampleSQL.dbf > This is because the instruction was in one line and there was no need to display the result of the SELECT. Without the SAVE TO the rowset would have been created in an XDML workarea.  You would need to BROWSE to view the data. The SAVE TO option of the SELECT command does not work in a .sql file. Mervyn.