Re: Google Address Lookup/ Autocomplete

2017-04-04 Thread Sujit Shah via 4D_Tech
OK Got it There are 2 API keys needed one for Google Maps and one for Google Places. Just for the record.. On Wed, Apr 5, 2017 at 3:41 PM, Sujit Shah wrote: > Hmm.. I am able to get the Address Validate to work but not the > Auto-Complete. > > JSON Parse Object is saying: "This API project is

Re: Google Address Lookup/ Autocomplete

2017-04-04 Thread Sujit Shah via 4D_Tech
Hmm.. I am able to get the Address Validate to work but not the Auto-Complete. JSON Parse Object is saying: "This API project is not authorised to use this API..." This is using my own key. I have replaced it in both places ie Demo_Validate and Demo_Predict ?? On Wed, Apr 5, 2017 at 12:32 PM,

Re: Google Address Lookup/ Autocomplete

2017-04-04 Thread Sujit Shah via 4D_Tech
Very good! Thanks. On Wed, Apr 5, 2017 at 11:11 AM, Scott Staley via 4D_Tech < 4d_tech@lists.4d.com> wrote: > > The 4D method user group did a presentation that included an address > validation app using google maps api. The url to the website page that > includes the 4D sample database is shown

Re: Question about passing JSON to 4D

2017-04-04 Thread David Adams via 4D_Tech
On Wed, Apr 5, 2017 at 10:35 AM, Keisuke Miyako via 4D_Tech < 4d_tech@lists.4d.com> wrote: > WEB GET VARIABLES only parses form variables (x-www-form-urlencoded). > > and then, jQuery post() only sends x-www-form-urlencoded. ...snip... Thanks for the fantastic answer. I can easily imagine spendi

Re: Google Address Lookup/ Autocomplete

2017-04-04 Thread Scott Staley via 4D_Tech
The 4D method user group did a presentation that included an address validation app using google maps api. The url to the website page that includes the 4D sample database is shown below. https://4dmethod.com/2015/07/08/next-meeting-july-30-priority-mail/ fyi... The sample database uses

Google Address Lookup/ Autocomplete

2017-04-04 Thread Sujit Shah via 4D_Tech
I am wondering if anyone has developed code to integrate with their API within the context of a 4D Form? -- xxx "There must be ingenuity as well as intention, strategy as well as strength. " ** 4D I

Re: Question about passing JSON to 4D

2017-04-04 Thread Keisuke Miyako via 4D_Tech
WEB GET VARIABLES only parses form variables (x-www-form-urlencoded). and then, jQuery post() only sends x-www-form-urlencoded. http://stackoverflow.com/questions/5529685/post-doesnt-send-data-as-json-but-as-x-www-form-urlencoded-instead so with this setup, you are basically working with a strin

Re: Question about passing JSON to 4D

2017-04-04 Thread Lee Hinde via 4D_Tech
WEB GET HTTP BODY($body) http://doc.4d.com/4Dv15/4D/15.4/WEB-GET-HTTP-BODY.301-3275031.en.html > On Apr 4, 2017, at 5:16 PM, Kirk Brooks via 4D_Tech <4d_tech@lists.4d.com> > wrote: > > Hi folks, > > I need a little guidance here. I have a web form (in a browser) that is > submitting data to 4D.

Question about passing JSON to 4D

2017-04-04 Thread Kirk Brooks via 4D_Tech
Hi folks, I need a little guidance here. I have a web form (in a browser) that is submitting data to 4D. I collect the data on the webform into an object then stringify it for passing to 4D - like so: var postData = JSON.stringify(woData); $.post( "/workorder/data", postData) .done(function(data)

Re: delete or truncate

2017-04-04 Thread Keisuke Miyako via 4D_Tech
ALL RECORDS + DELETE SELECTION, or selecting all records and deleting them in User Mode logs "delete" action for each record in the journal file. TRUNCATE TABLE, on the other hand, has its own single action in the journal file. "Truncate" clears the address table, whereas "Delete" does not. the

Re: 4D Compiler

2017-04-04 Thread David Adams via 4D_Tech
Nigel, The Compiler changed some versions back and no longer detects all error sin one pass...at least in certain situations. A few tips and things to look out for: * If you've got a missing method, the Compiler usually stops reporting errors, even if there are multiple cases of the problem. * S

Re: check for duplicates in v15

2017-04-04 Thread Chuck Miller via 4D_Tech
Thanks that must be it I should remember that Regards Chuck Sent from my iPhone > On Apr 4, 2017, at 5:41 PM, Wayne Stewart via 4D_Tech <4d_tech@lists.4d.com> > wrote: > > Only the first 1024 characters are indexed. ** 4D Int

Re: check for duplicates in v15

2017-04-04 Thread Wayne Stewart via 4D_Tech
Chuck, This may be related: http://doc.4d.com/4Dv16/4D/16/Creating-and-modifying-indexes.300-3048980.en.html Only the first 1024 characters are indexed. Wayne On Wed, 5 Apr 2017 at 06:57, Charles Miller via 4D_Tech < 4d_tech@lists.4d.com> wrote: > Hi All > > I have in pseudo code the followin

RE: Anyone using v16 in WAN

2017-04-04 Thread Timothy Penner via 4D_Tech
Hi Chuck, > OK what about when I connect from a v11 single user via sql row 64 BIT Mac > server. What network layer does it use. Your v11 SingleUser app is definitely using the legacy network, it does not know about the New Network Layer. Your 64 bit Mac Server is definitely using the new netw

check for duplicates in v15

2017-04-04 Thread Charles Miller via 4D_Tech
Hi All I have in pseudo code the following distinct values on a text field, that can be anywhere from 5 or 6 characters to >1000 These text fields are supposed to bed unique in in fact are. However, the resultant array is not the same size as numbers of records. I know it is the same, as I adde

RE: Anyone using v16 in WAN

2017-04-04 Thread Dennis, Neil via 4D_Tech
> OK what about when I connect from a v11 single user via sql row 64 BIT Mac > server. > What network layer does it use. I have been running tests with v15 latest hot > fix. I have many disparate connection types. If I had to take a guess, you are using the new network layer (as that is all th

RE: Anyone using v16 in WAN

2017-04-04 Thread Timothy Penner via 4D_Tech
Apparently my last post still wasn't clear so let me try again - The new network layer is *required* if you are using: * 4D Server 64 bit on Mac * 4D 64 bit on Mac * 4D 64 bit on Win ^ If you use any of these in your deployment you MUST use the new network layer because these products do not "un

Re: Anyone using v16 in WAN

2017-04-04 Thread Charles Miller via 4D_Tech
On Tue, Apr 4, 2017 at 3:38 PM, Charles Miller wrote: > This is true, you need to use the new network layer with a 64 bit MAC >> server... legacy network doesn't exist. >> >> >> Neil >> >> > Ohm thanks to all. This was not how I understood it. OK what about when I connect from a v11 single user

Re: Anyone using v16 in WAN

2017-04-04 Thread Charles Miller via 4D_Tech
On Tue, Apr 4, 2017 at 3:37 PM, Dennis, Neil via 4D_Tech < 4d_tech@lists.4d.com> wrote: > > This is true, you need to use the new network layer with a 64 bit MAC > server... legacy network doesn't exist. > > > Neil > > Ohm thanks to all. This was not how I understood it. Regards Chuck --

RE: Anyone using v16 in WAN

2017-04-04 Thread Dennis, Neil via 4D_Tech
> (Mac and Windows clients) and connect to a MAC server using 64 bit This is true, you need to use the new network layer with a 64 bit MAC server... legacy network doesn't exist. Neil -- Privacy Disclaimer: This message contains confidential information and is intended only for the nam

Re: Anyone using v16 in WAN

2017-04-04 Thread Jeffrey Kain via 4D_Tech
Since you're using a 64-bit Mac server you have to use the new network layer. If you had a 64-bit Windows server with 32-bit clients, you could use the legacy (i.e. reliable) network layer. > On Apr 4, 2017, at 2:13 PM, Charles Miller via 4D_Tech <4d_tech@lists.4d.com> > wrote: > > OK I am a l

RE: Anyone using v16 in WAN

2017-04-04 Thread Dennis, Neil via 4D_Tech
> OK I am a little confused. Ifs I build clients using 32 bit volume (Mac and > Windows clients) and > connect to a MAC server using 64 bit server, the new network layer is always > used? or not? > I thought 32 bit volume desktops did > *NOT* support the new network layer That would be 4D 32 b

Re: Anyone using v16 in WAN

2017-04-04 Thread Charles Miller via 4D_Tech
On Tue, Apr 4, 2017 at 2:31 PM, Timothy Penner via 4D_Tech < 4d_tech@lists.4d.com> wrote: > The new network layer is required (legacy network not supported) if you > are using: > > * 4D Server 64 bit on Mac > * 4D 64 bit on Mac > * 4D 64 bit on Win > > The new network layer is not required (legacy

RE: delete or truncate

2017-04-04 Thread Randy Engle via 4D_Tech
Re: " To me, Truncate table is sort of the "Holy Hand Grenade" I love TRUNCATE TABLE... I think of it as the "Molecular Disruption Device" ( from Ender's Game) When you really want to clean things up, with no witnesses left standing. ;-) Randy Engle XC2 Software LLC *

RE: delete or truncate

2017-04-04 Thread Dennis, Neil via 4D_Tech
> I am using truncate. I just want to make sure that by using this command then > then running MSC repair, > I will get new fast indices for these tables and table space will be correct. > If one uses delete command and deletes > most of the records table space is screwed up. That was my real que

Re: delete or truncate

2017-04-04 Thread Charles Miller via 4D_Tech
On Tue, Apr 4, 2017 at 2:04 PM, Douglas von Roeder via 4D_Tech < 4d_tech@lists.4d.com> wrote: > It's a command whose function is to clear all the tablespace allocated to > records in a given table along with the associated indexes. > > Delete selection is used to delete one or more records, ensuri

RE: delete or truncate

2017-04-04 Thread Stephen J. Orth via 4D_Tech
Doug, Yeah, this command lets you do a LOT of damage, very quickly, with no real recourse... ;-) Steve -Original Message- From: 4D_Tech [mailto:4d_tech-boun...@lists.4d.com] On Behalf Of Douglas von Roeder via 4D_Tech Sent: Tuesday, April 04, 2017 1:35 PM To: 4D iNug Technical <4d_t

Re: delete or truncate

2017-04-04 Thread Douglas von Roeder via 4D_Tech
Steve: Very good point about a transaction. Reading Chuck's posting, I got the impression that this would be done on an "as needed" basis. To me, Truncate table is sort of the "Holy Hand Grenade", sort of like in the 4D Server betas when Array to selection would delete records. -- Douglas von

RE: Anyone using v16 in WAN

2017-04-04 Thread Timothy Penner via 4D_Tech
> Yes. You only need the new network layer to support 64-bit 4D on Mac. The new network layer is required (legacy network not supported) if you are using: * 4D Server 64 bit on Mac * 4D 64 bit on Mac * 4D 64 bit on Win The new network layer is not required (legacy network supported) if you are

Re: Anyone using v16 in WAN

2017-04-04 Thread Jeffrey Kain via 4D_Tech
Yes. You only need the new network layer to support 64-bit 4D on Mac. > On Apr 4, 2017, at 12:54 PM, Timothy Penner via 4D_Tech > <4d_tech@lists.4d.com> wrote: > > Hi Tim, > >>> I think it is important to investigate whether the instability is specific >>> to application code or not. >>> >>>

RE: delete or truncate

2017-04-04 Thread Stephen J. Orth via 4D_Tech
Tim, It appears to be back up again, but it was down for a bit, along with the 4D website. Steve -Original Message- From: 4D_Tech [mailto:4d_tech-boun...@lists.4d.com] On Behalf Of Timothy Penner via 4D_Tech Sent: Tuesday, April 04, 2017 1:16 PM To: 4D iNug Technical <4d_tech@lists.4

RE: delete or truncate

2017-04-04 Thread Timothy Penner via 4D_Tech
> I like the TRUNCATE TABLE command, but I'm thinking this cannot be used > within a transaction. " No transaction must be underway in the process executing TRUNCATE TABLE. If this if the case, the command does nothing and the OK system variable is set to 0" > 4D's documentation website is dow

RE: delete or truncate

2017-04-04 Thread Stephen J. Orth via 4D_Tech
Doug, I like the TRUNCATE TABLE command, but I'm thinking this cannot be used within a transaction. 4D's documentation website is down, otherwise I would have confirmed this first. Steve -Original Message- From: 4D_Tech [mailto:4d_tech-boun...@lists.4d.com] On Behalf Of Douglas von R

Re: delete or truncate

2017-04-04 Thread Douglas von Roeder via 4D_Tech
Chuck: I'd go with truncate. It's a command whose function is to clear all the tablespace allocated to records in a given table along with the associated indexes. Delete selection is used to delete one or more records, ensuring that indexes and relational integrity constraints are enforced for e

Re: Anyone using v16 in WAN

2017-04-04 Thread Tim Nevels via 4D_Tech
On Apr 4, 2017, at 11:02 AM, Neil Dennis wrote: > I found the new net work layer unusable as well. During heavy loads 4D will > quit responding. I use legacy network and things work great. This was all > done on a LAN not a WAN. > > I let the 4D engineers know about this at the last 4D summit.

RE: Anyone using v16 in WAN

2017-04-04 Thread Timothy Penner via 4D_Tech
Hi Tim, > > I think it is important to investigate whether the instability is specific > > to application code or not. > > > > for instance, it is possible to create a bare bone copy of you database > > with the export structure command. you can then open a copy of your > > production data with

Re: Anyone using v16 in WAN

2017-04-04 Thread Tim Nevels via 4D_Tech
On Apr 4, 2017, at 11:02 AM,Keisuke Miyako wrote: > I think it is important to investigate whether the instability is specific to > application code or not. > > for instance, it is possible to create a bare bone copy of you database with > the export structure command. you can then open a copy

delete or truncate

2017-04-04 Thread Charles Miller via 4D_Tech
I seem to remember a tech note or example that would fix index problems that you would have when deleting most of the record in a able or or truncating it. I can not seem to find it. I wanted to make sure that if we run a repair after doing this that all will be as it should. The two tables we are

Re: 4D Compiler

2017-04-04 Thread Nigel Greenlee via 4D_Tech
Tim Oh that this was V15!!!..its not a complaint about the compiler its doing a a damned fine job here its like Mr Trebus living room(https://en.wikipedia.org/wiki/Edmund_Trebus) > On 4 Apr 2017, at 17:31, Charles Miller via 4D_Tech <4d_tech@lists.4d.com> > wrote: > > On Tue, Apr 4, 2017 at 1

RE: 4D Compiler

2017-04-04 Thread Timothy Penner via 4D_Tech
Maybe related to this? ACI0096385 [135142] Check Syntax Error Count Not Consistent. ^ Still in progress. ^ filed for v15.x / 16.x / 16R2 * I thought this was database specific though. The bug description explains that it's just the number that seems wrong, but the actual list seems correct. A wor

RE: Anyone using v16 in WAN

2017-04-04 Thread Stephen J. Orth via 4D_Tech
John, We tried running this in 32 bit mode (Windows) and it was unusable. We contacted 4D and they told us not to use it for 32 bit, but only 64 bit. Have not tried that yet as we have been unable to get the 64 bit version working with our OEM system (web area issues using the integrated brow

Re: 4D Compiler

2017-04-04 Thread Nigel Greenlee via 4D_Tech
Chuck If it was closer to the days when i wrote load of errors i might have worked out(but then i was so daft i could not have worked it out)..now that i am clever enough to work it out i don’t need to work it out because i don't write 100s of errors …end of a long day clearing 100*n errors ge

Re: Anyone using v16 in WAN

2017-04-04 Thread Charles Miller via 4D_Tech
On Tue, Apr 4, 2017 at 12:36 PM, John DeSoi via 4D_Tech < 4d_tech@lists.4d.com> wrote: > Are folks having trouble with the new network layer using it in 32 bit > mode or 64 bit mode? Just wondering if 64 bit mode is also problematic. It is my understanding that 32 mode only runs on old network l

Re: Anyone using v16 in WAN

2017-04-04 Thread John DeSoi via 4D_Tech
Are folks having trouble with the new network layer using it in 32 bit mode or 64 bit mode? Just wondering if 64 bit mode is also problematic. John DeSoi, Ph.D. > On Apr 4, 2017, at 10:56 AM, lists via 4D_Tech <4d_tech@lists.4d.com> wrote: > > Of the sites we are running at, all but the smalle

Re: 4D Compiler

2017-04-04 Thread Charles Miller via 4D_Tech
On Tue, Apr 4, 2017 at 12:23 PM, Nigel Greenlee via 4D_Tech < 4d_tech@lists.4d.com> wrote: > Chuck > > Yep thats pretty much what i am figuring..but I was just curious if anyone > know what the 'trigger points’ that cause it to give up are-if we knew what > they were we could clear up those errors

Re: 4D Compiler

2017-04-04 Thread Nigel Greenlee via 4D_Tech
Chuck Yep thats pretty much what i am figuring..but I was just curious if anyone know what the 'trigger points’ that cause it to give up are-if we knew what they were we could clear up those errors first(I have been at this one all day today and most of yesterday) Nigel Greenlee > On 4 Apr 20

Re: 4D Compiler

2017-04-04 Thread Charles Miller via 4D_Tech
On Tue, Apr 4, 2017 at 12:05 PM, Nigel Greenlee via 4D_Tech < 4d_tech@lists.4d.com> wrote: > Just out of curiosity does anyone know why the compiler does this(its a > long time since i have had more than 2 errors in the compiler because i > compile everytime i change a piece of code to check for s

4D Compiler

2017-04-04 Thread Nigel Greenlee via 4D_Tech
Hi I have always been curious-but really never had to see this in this way. I am currently updating a system which has never been compiled-not with a view to compiling but to clear up syntax errors. So i started with some number of errors(somewhat north of 100)…i cleared some stuff..and then s

RE: Anyone using v16 in WAN

2017-04-04 Thread lists via 4D_Tech
Of the sites we are running at, all but the smallest ones exhibit the same slowness, non-responsiveness after several days (number of days depended on usage load), logged off clients not clearing from the server and occupying licenses. We can actually see the system response time increase as mo

RE: Anyone using v16 in WAN

2017-04-04 Thread lists via 4D_Tech
Of the sites we are running at, all but the smallest ones exhibit the same slowness, non-responsiveness after several days (number of days depended on usage load), logged off clients not clearing from the server and occupying licenses. We can actually see the system response time increase as mo

Re: Anyone using v16 in WAN

2017-04-04 Thread Herr Alexander Heintz via 4D_Tech
Am 04.04.2017 um 14:54 schrieb npdennis via 4D_Tech <4d_tech@lists.4d.com>: > >> if you have no issues using the database in user mode over the same network, >> then perhaps some methods are choking the network in a way that does not >> happen over the legacy layer. > > I found the new net work

Re: Anyone using v16 in WAN

2017-04-04 Thread npdennis via 4D_Tech
> if you have no issues using the database in user mode over the same network, > then perhaps some methods are choking the network in a way that does not > happen over the legacy layer. I found the new net work layer unusable as well. During heavy loads 4D will quit responding. I use legacy net

Re: Anyone using v16 in WAN

2017-04-04 Thread Kirk Brooks via 4D_Tech
Doug, I've been running a db over WAN since v2004. I've found v15 to be more stable than any of the others but I'm also running it on the legacy setting. I've changed to the new one a couple of times and it always gets complaints from users about responsiveness or sluggishness. I don't have any v16

Re: Anyone using v16 in WAN

2017-04-04 Thread Keisuke Miyako via 4D_Tech
Hello, I think it is important to investigate whether the instability is specific to application code or not. for instance, it is possible to create a bare bone copy of you database with the export structure command. you can then open a copy of your production data with that structure file. i

Anyone using v16 in WAN

2017-04-04 Thread Douglas Cryer via 4D_Tech
I would like to hear from anyone using v16 in a WAN environment. Frankly every time I have tried out v16 or for that matter any v15 R release I have been shocked at how poor the network connection stability has been. It seems to stem from the new networking layer and certainly it seems to be mo