Re: USE DATABASE from 4D client

2017-05-31 Thread Alan Chan via 4D_Tech
I might be missing something obvious. Why not simply using SQL login to access external database and the data could be accessed by multiple 4D clients. SQL LOGIN($externaAddress;$user;$pswd;*) If (OK=1) Begin SQL //do whatever SQL query End SQL SQL LOGOUT End if Alan Chan 4D iNug Technical

Re: USE DATABASE from 4D client

2017-05-30 Thread David Samson via 4D_Tech
Keisuke Miyako wrote: >rather activating the "execute on server" method property, >I would recommend using the REMOTE keyword: Does that allow multiple users to access it simultanously? Thanks for the reply, David ** 4D

Re: USE DATABASE from 4D client

2017-05-30 Thread David Samson via 4D_Tech
David Adams wrote: >On another note, is there some reason that you can't or don't want to >download the file to the clients? It is a 28 million record postal address file so segmenting won't work. I have thought of copying it over to the clients but then the issue of keeping it updated raises

Re: USE DATABASE from 4D client

2017-05-30 Thread bob.miller--- via 4D_Tech
RE> rather activating the "execute on server" method property, I would recommend using the REMOTE keyword: http://doc.4d.com/4Dv15/4D/15/USE-DATABASE.300-2288124.en.html I don't understand how this would make any difference; the REMOTE database would still be held open until AUTO_CLOSE was

Re: USE DATABASE from 4D client

2017-05-30 Thread Keisuke Miyako via 4D_Tech
rather activating the "execute on server" method property, I would recommend using the REMOTE keyword: http://doc.4d.com/4Dv15/4D/15/USE-DATABASE.300-2288124.en.html 2017/05/30 23:25、David Samson via 4D_Tech <4d_tech@lists.4d.com> のメール： One suggestion I saw on the

Re: USE DATABASE from 4D client

2017-05-30 Thread David Adams via 4D_Tech
David, Interesting question about Execute on server, I hope we get a good answer. I suspect that you might be right. If everything is going through Execute on server, it's all running on one machine. At that point, I guess you would not use AUTO_CLOSE and would allow 4D to manage the access. Hmm.

USE DATABASE from 4D client

2017-05-30 Thread David Samson via 4D_Tech
I asked this question some time ago but with the current flurry of interest in external databases I will have another go. NB no components involved here. If I have an external datafile held on the server how do I access it (purely for lookup) from a 4D client? What I tried was to use SQL as