Re: Lost autocomplete for constants

2021-01-21 Thread Guy Algot via 4D_Tech
No idea. I access the Archives via the Support link on their website. https://us.4d.com/product-download/Archives > On Jan 21, 2021, at 11:12 AM, SPC via 4D_Tech <4d_tech@lists.4d.com> wrote: > > Is 4D still maintaining their FTP site? That is where I have always gone for > legacy installers

Re: Foundation Status?

2020-11-07 Thread Guy Algot via 4D_Tech
The images in the component were done a long time ago, before v14 came out. > On Nov 6, 2020, at 9:52 AM, Ken Geiger Gmail via 4D_Tech > <4d_tech@lists.4d.com> wrote: > > Hi Ed, > > There’s a version 5.7 of foundation shell available that is supposed to be > compatible with 4D v16 and above.

Re: Users and group not converting when moving from v17r5 to v18

2020-04-30 Thread Guy Algot via 4D_Tech
Eric, U were changed with v18 project mode. Check out the blog, I believe there was a posting there about it. > On Apr 30, 2020, at 2:29 PM, Eric Naujock via 4D_Tech <4d_tech@lists.4d.com> > wrote: > > I have found that if you take a 4D v17r5 program and convert it to v18. Then > change the

Re: HTTP Request when POSTing does not have a response if the HTTP status code # 200

2020-04-18 Thread Guy Algot via 4D_Tech
you are using. > >> On Apr 18, 2020, at 15:01, Guy Algot via 4D_Tech <4d_tech@lists.4d.com> >> wrote: >> Can anyone confirm this to be true? I’m using 17.3. Thanks. ** 4D Internet Users Group (4D i

HTTP Request when POSTing does not have a response if the HTTP status code # 200

2020-04-18 Thread Guy Algot via 4D_Tech
Can anyone confirm this to be true? I’m using 17.3. Thanks. Later, Guy -- Guy Algot, Solutions Specialist Edmonton, Alberta (780) 974-8538 hardware, installation, training, support, programming, internet specializing in 4th Dimension =-=

Re: Gmail, LSA, and OAuth

2020-03-18 Thread Guy Algot via 4D_Tech
100% agree. > On Mar 18, 2020, at 3:59 PM, Randy Kaempen via 4D_Tech <4d_tech@lists.4d.com> > wrote: > Since the 4D Internet Commands are something that many companies use, it > seems like it would be a good idea for us as a group to work on a way to move > forward, either adding a framework

Re: Capturing barcodes without a 'text' field

2019-10-16 Thread Guy Algot via 4D_Tech
Peter, you could also put a hidden button on your form. The scanner could be programmed to trigger the button which would then grab the data being scanned and allow your code to process it. > On Oct 15, 2019, at 4:22 PM, Peter Jakobsson via 4D_Tech > <4d_tech@lists.4d.com> wrote: > > Hi > >

Re: Error -1 using SQL.

2019-07-25 Thread Guy Algot via 4D_Tech
Chip, I just noticed recently that when the SQL option is off on the server and I try to connect with SQL LOGIN that I get an error -1 vs a 9918. If you call the following in the IN ERR CALL method ; GET LAST ERROR STACK(codesArray;intCompArray;textArray) you will see the error you are

Re: 4D Write Pro license question

2019-01-14 Thread Guy Algot via 4D_Tech
Koen, This problem also exists in v15 (and v13). I was using groups and BLOB TO USERS and although groups would be restored, any changes to groups would not. So perhaps a bug in USERS TO BLOB? > On Jan 14, 2019, at 4:01 AM, Koen Van Hooreweghe via 4D_Tech > <4d_tech@lists.4d.com> wrote: > >

Re: Pasting Spreadsheet Data into 4D Records

2018-12-25 Thread Guy Algot via 4D_Tech
Alan, John Baughman has a wonderful collection of tip & tricks and one of the methods is called ‘Array_ArraysToClipBoard’. I don’t have the code with me but perhaps he has one that does the reverse and that may help you with your spreadsheet import? > On Dec 23, 2018, at 5:47 PM, Alan

Re: UI Form Updates

2018-12-18 Thread Guy Algot via 4D_Tech
Sandor, Check out this KB article ; http://kb.4d.com/assetid=77873 > On Dec 17, 2018, at 2:00 PM, Sandor Szatmari via 4D_Tech > <4d_tech@lists.4d.com> wrote: > > I added a page to an existing form. I can add and delete rows. I have + > button to show the

Re: Colocation - Recommendations Survey

2018-08-29 Thread Guy Algot via 4D_Tech
Randy, If you are looking for a place to park your own hardware, I have had a server with these folks for several years. Zero complaints. Excellent service. I use them with my hardware but they could offer other options that would suit your needs. https://www.macminivault.com > On Aug 29,

Re: Export/ImportSQL

2018-08-20 Thread Guy Algot via 4D_Tech
Pat, There is a bug with dates when importing using SQL in v12. I don’t know if it has been addressed in v16 but check that you don’t have years that have 5 digits. > On Aug 20, 2018, at 5:22 PM, Pat Bensky via 4D_Tech <4d_tech@lists.4d.com> > wrote: > > I'm exporting data from a v12

Re: What do you use to monitor your offsite servers?

2018-07-15 Thread Guy Algot via 4D_Tech
+1 for Splashtop. Much more economical than either LogMeIn or TeamViewer. Works better too IMO. > On Jul 15, 2018, at 2:27 PM, Kirk Brooks via 4D_Tech <4d_tech@lists.4d.com> > wrote: > > I've been using LogMeIn for a few years. It was great at $100/year. It was > OK at $200/year but now it's

Re: When your Extreme router is too slow... (5N)

2018-03-22 Thread Guy Algot via 4D_Tech
Robert, Check out the Cisco RV routers. The RV042 has both OoS and VPN. https://www.cisco.com/c/en/us/products/routers/small-business-rv-series-routers/models-comparison.html > On Mar 22, 2018, at 6:03 PM, Robert ListMail via 4D_Tech > <4d_tech@lists.4d.com> wrote: > > Sam, > > I upgraded my

Re: How to set the file name of a QR Report to disk file.

2017-12-28 Thread Guy Algot via 4D_Tech
I use an offscreen area. For example ; myQR:=QR New offscreen area QR SET REPORT TABLE(myQR;Table(->[InvoiceItems])) QR INSERT COLUMN(myQR;1;->[InvoiceItems]InvoiceDate) QR INSERT COLUMN(myQR;2;->[InvoiceItems]InvoiceNo) QR INSERT COLUMN(myQR;3;->[InvoiceItems]Customer) QR INSERT

Re: Hosting Service for Small System

2017-10-13 Thread Guy Algot via 4D_Tech
These guys are awesome. Been using them for about 4 years. If you use their Enterprise plan, your hardware is covered by their Perpetual hardware warranty. https://www.macminivault.com > On Oct 13, 2017, at 9:25 AM, Douglas von Roeder via 4D_Tech > <4d_tech@lists.4d.com> wrote: > > I'm

Re: Method Header Strategies

2017-08-09 Thread Guy Algot via 4D_Tech
My guess… So you can click the triangle and hide everything in the header? > On Aug 9, 2017, at 4:11 PM, Lee Hinde via 4D_Tech <4d_tech@lists.4d.com> > wrote: > > But, why wrap the whole thing in if (True)? Later, Guy -- Guy Algot, Solutions Specialist Edmonton, Alberta (780) 974-8538

Re: Optimizing and improving 4D queries.

2017-06-28 Thread Guy Algot via 4D_Tech
Eric, How long does a query on the related field take? Any picture or blob fields in the related table? Those could slow down the loading of the related records. > On Jun 28, 2017, at 5:59 PM, Eric Naujock via 4D_Tech <4d_tech@lists.4d.com> > wrote: > > I have been trying to do some

Re: Automatic type-ahead on single-column listbox?

2017-06-27 Thread Guy Algot via 4D_Tech
It does if it’s only a single column. You don’t use a listbox, you use a hierarchical list. If it’s more than one column then ditch the listbox and use DisplayList or ALP. > On Jun 27, 2017, at 3:14 AM, David Adams via 4D_Tech <4d_tech@lists.4d.com> > wrote: > > I might be remembering this

Re: 4D and Sage

2017-06-13 Thread Guy Algot via 4D_Tech
I recently went through the process of trying to determine how to integrate with Sage since a client was looking to use them. Very difficult and expensive was the answer regarding automated integration. I have looked at Xero previously because of their REST API but in accounting terms I don’t

Re: Tags in record on 4d.

2017-05-19 Thread Guy Algot via 4D_Tech
Eric, I’ve used this for years and called it Keywords. A separate related table stores the Contact Key and the Keyword. You can search on the Keywords and then relate that selection to Contacts. This was before objects. But like Koen said, objects would work as well. Depends on how flexible