Subject Re: Command Window Commands From Gaetano D. <gaetanoddRemoveThis@andThatHotmail.com> Date Thu, 20 May 2021 16:19:57 +1000 Newsgroups dbase.getting-started On 20/05/2021 15:55, Gaetano D. wrote: > On 20/05/2021 15:25, Rouke wrote: >> When I double click a program in the Navigator, a 'do' command shows >> in the Command Window. >> When I select 'Open in Source Editor' (a program) in the Navigator, a >> 'modify command' command shows in the Command Window. >> >> When I double click a table in the Navigator, there's no command in >> the Command Window >> When I select 'Design Table' in the Navigator, there's no command in >> the Command Window >> >> When I select 'Design SQL' in the Navigator, a 'modify query' command >> shows in the Command Window >> When I select 'Open in Source Editor' (an SQL) in the Navigator, a >> 'modify command' command shows in the Command Window. >> When I double click or select 'Run SQL' in the Navigator, there's no >> command in the Command Window >> What is the command to run an SQL from the Command Window? >> >> Thanks, >> >> Rouke > > I have never tried that but I think that if you put the commands in a > PRG file a DO mySQLcommands.PRG, it should work > > Mind that in dBase you can only use local SQL and the commands are > very limited. They are listed in OLH - type "statements" in the Index > tab of OLH and you will find them. > > 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 > If you were after the command to execute the SQL file: sqlexec('<inputFile>.sql','<outputFile>.dbf') -- Gaetano.