Subject Re: exe problem From Andy Taylor <andy.taylor.1959@outlook.com> Date Tue, 06 Oct 2020 05:18:53 -0400 Newsgroups dbase.getting-started Charlie, Akshat and I very much suspect that you are not in the folder that you think you are. Insert the following before the line that gives you errors: msgbox(""+set("directory")) That will tell you the folder where dBASE is executing code "from". The following code will tell you where windows wants you to put temporary files (it will differ for each user). msgbox(""+getenv("temp")) Andy > Hi Mervyn... > > There is one other program that has the orderby clause and has the same or similar error.  This works fine on my other computers.  There is something going on here.  Nothing that I have done as I haven't coded on this computer yet. > > I think the tempworkfile came from something you helped me with.  The code is below.  The last line is the one that triggers the error. > > Is there something in dbase that tells the program where to hold temp files? > > cFileIn ='c:\golfcb\info\users.csv' > cFileOut = 'tempworkfile.txt' > fIn = new file() > fIn.open(cFileIn) > fOut = new file() > fOut.create(cFileOut) > > > Mervyn Bick Wrote: > > > On 2020/10/04 19:01, Charlie wrote: > > > I’m running windows 10 on a new computer.  I installed 1130b2550 and 1130runtime-b2550.  My old computer ran these perfectly. > > > > > > Actually this program runs great in dbase.  However when I run the exe file that was built in project explorer I have run into a couple unexpected errors. > > > > > > I get this one when I run a particular report, other reports run fine… > > > > > > Database Engine Error:  Permission denied:  C:\windows\system32\_QSQL000.DBF > > > > > > The following script is where the error is pointing….. > > > > > >    database = form.form.database1 > > >        sql = "select i.*,c.*from golfers_scores i inner join dbname c on i.dbname = c.dbname order by i.lname,i.fname" > > >        requestLive = false > > >        active = true > > > > > > The other error is… > > > > > > Error:  Access denied:  tempworkfile.txt > > > > > > It seems to be some-sort of a permission problem having to do with a temp dbf file that is deleted at the end of the script. > > > > > > Appreciate any help or suggestions. > > > > > > > Whenever you use an ORDER BY clause in a select statement dBASE creates > > a temporary file named _QSQLnnn.DBF  This file is usually in the same > > folder as the program. > > > > I have no idea why your report is trying place the temporary file in > > C:\windows\system32 but Windows 10 regards this as a definite no-no. > > > > Do any of the other reports that do run include an ORDER BY  clause? > > > > Where do you place tempworkfile.txt? > > > > Mervyn. > > > > > > >