| Subject | Re: exe problem |
| From | Charlie <tm@tc.com> |
| Date | Thu, 08 Oct 2020 13:43:21 -0400 |
| Newsgroups | dbase.getting-started |
OK I uised the msgbox that was suggested and yes it came up with windows\system32\ I really don't understand as it has always worked fine on my old computer. There is no reference to the system32 directory anywhere. I deleted everything and ran the project again and built a new exe file. Does the same thing. I have another dbase program on the same new computer and it tests in the correct directory. I am baffled!! 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. > > > | |