RE: OPEN DATA FILE gets endless loop

2019-10-30 Thread David Ringsmuth via 4D_Tech
-matched datafile is open (after the last folder separator, the datafile name matches the structure file name). Then use OPEN DATA FILE to open the desired one. Hth! David Ringsmuth From: wangel--- via 4D_Tech Sent: Wednesday, October 30, 2019 4:24 AM To: 4d_tech@lists.4d.com Cc: wan...@online.no

SV: OPEN DATA FILE gets endless loop

2019-10-30 Thread wangel--- via 4D_Tech
Hallo Chip, Yes I am aware of that. I was experimenting with OPEN DATA FILE to avoid 4D asking for a datafile. My idea was to distribute at standalone program with the structure in one folder and the datafile in another folder. That way the datafile would not be deleted when updating the

OPEN DATA FILE

2019-10-29 Thread wangel--- via 4D_Tech
I may be the only one who have tried using OPEN DATA FILE without knowing how it works. But all the same I like to point out the following: OPEN DATA FILE (MyDataFile) informs 4D to use MyDataFile. It then closes 4D and start it up again. Simple enough. To avoid a loop (like in the On Startup

Re: SV: OPEN DATA FILE gets endless loop

2019-10-28 Thread Chip Scheide via 4D_Tech
hip On Mon, 28 Oct 2019 21:29:17 +0100, wangel--- via 4D_Tech wrote: > Thanks for your response Jeremy. You have made it clear to me that > OPEN DATA FILE first closes the database and then reopen it with the > wanted datafile and then repeat that unless something stops it. I > tried w

SV: OPEN DATA FILE gets endless loop

2019-10-28 Thread wangel--- via 4D_Tech
Thanks for your response Jeremy. You have made it clear to me that OPEN DATA FILE first closes the database and then reopen it with the wanted datafile and then repeat that unless something stops it. I tried with $dataPath:="" which obviously was not a particularly brilliant idea.

Re: OPEN DATA FILE gets endless loop

2019-10-27 Thread Jeremy Roussak via 4D_Tech
when the new data file opens 6. Go to step 1; hence your loop From the OPEN DATA FILE documentation: If the access path sets a valid data file, 4D quits the database in progress and re-opens it with the specified data file. In single-user mode, the Semaphore and the On Startup database method

OPEN DATA FILE gets endless loop

2019-10-27 Thread wangel--- via 4D_Tech
I am trying to use in "On Startup" but I get an endless loop. The code is: C_TEXT($dataPath) $dataPath:="C:\\MyFolder\\MyData.4dd" If ($dataPath#"") OPEN DATA FILE($dataPath) //open it $dataPath:="" End if What am I

Re: OPEN DATA FILE

2016-12-21 Thread Nigel Greenlee
Sujit. What about storing the data in another data file altogether that you can access from either. So…something like this… CREATE DATABASE IF NOT EXISTS DATAFILE <<$VerifyDataPath>> auto_close; USE LOCAL DATABASE datafile <<$VerifyStructurePath>> auto_close; CREATE TABLE IF NOT EXISTS VERIFY

Re: OPEN DATA FILE

2016-12-19 Thread Sujit Shah
Thanks Nigel for your code. In my situation I have a dialog which gives the user an option to choose which data file they want to open: www.fortuna.com.au/4D_issues/startup-dialog.png So the user can either open/setup his/her file or explore a demo data file. This was all cool till I put the ob

Re: OPEN DATA FILE

2016-12-19 Thread Nigel Greenlee
Sujit. You can control where the default datafile is using build with xml keys…i hope the following does not stray far from what you are trying to do…. I know that at one point I wanted to a make a downloadable single user demo version of a product AND i wanted new client server builds t

OPEN DATA FILE

2016-12-15 Thread Sujit Shah
Does anyone know where 4D Stores the default Data file an application opens with? I know it opens the last Data file opened but where is this information stored? -- xxx "There must be ingenuity as well as intention, strategy as well as strength. " ***