Subject Re: Command Window Commands From Gaetano D. <gaetanoddRemoveThis@andThatHotmail.com> Date Thu, 20 May 2021 15:55:58 +1000 Newsgroups dbase.getting-started 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 -- Gaetano.