Re: Output lists

2016-09-16 Thread Guy Algot
Monaco? ;-) I like Lucida Grande. > On Sep 16, 2016, at 11:49 AM, Lee Hinde wrote: > > What fonts do you like for output forms, on a Mac? > > Helvetica is looking real stale. > ** > 4D Internet Users Group (4D iNUG) > FAQ: ht

Re: v13 on Sierra?

2016-09-21 Thread Guy Algot
r not working. > > So I think it is cool. Parallels is allowing it. If there was a problem I’m > sure Parallels would have put in a software block to not allow it like they > did with 10.6. Later, Guy -- Guy Algot, Solutions Specialist Edmonton, Alberta (780) 974-8538 hard

Re: Document List

2016-10-02 Thread Guy Algot
rray;0) >>> DOCUMENT LIST(DocToShow;DocPathArray;Absolute path) >>> DOCUMENT LIST(DocToShow;DocArray) >>> >>> For ($i;Size of array(DocArray);1;-1) >>> If (Is picture file(docpathArray{$i};*)=False) >>> DELETE FROM ARRAY(docArray;$i;1) &g

4D 6.8 certification matrix

2016-11-08 Thread Guy Algot
. Later, Guy -- Guy Algot, Solutions Specialist Edmonton, Alberta (780) 974-8538 hardware, installation, training, support, programming, internet specializing in 4th Dimension =-= =-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-= "Microsoft is a cross between the Borg and the Fe

Re: connecting to SQL server from a Mac

2016-11-09 Thread Guy Algot
Chuck, I’ve used their drivers and they have done the job for me. > On Nov 9, 2016, at 10:47 AM, Chuck Miller > wrote: > > Hi All, > > it’s been a while since I had to do this. What drivers are people out there > using. I was using actual technology ODBC driver. Is this still recommended > a

Re: Query editor in v15

2016-12-09 Thread Guy Algot
; On Fri, Dec 9, 2016 at 10:50 AM, Lee Hinde <mailto:leehi...@gmail.com>> wrote: >> >> I.e., I'm not clear what itch got scratched with that change. Later, Guy -- Guy Algot, Solutions Specialist Edmonton, Alberta (780) 974-8538 hardware, installation, training, supp

Re: Query editor in v15

2016-12-09 Thread Guy Algot
I’ve > found some instances where queries stored in v12 are not opened correctly in > v15. > > > Thanks for any thoughts or suggestions. > > > Paul > Later, Guy -- Guy Algot, Solutions Specialist Edmonton, Alberta (780) 974-8538 hardwar

Re: Query editor in v15

2016-12-09 Thread Guy Algot
n" relations too, >> since QUERY is optimised for n fields since v11. >> >> it could be optimised by some caching mechanism I guess... >> I could work on it if you really need it. (I was told that there is little >> need for it outside of Japan) > Later, Guy -

Re: sage 50 importing

2016-12-12 Thread Guy Algot
conflicting information out there on the internet, so things are > going a lot slower than I’d like. > > Anxious to see if anyone has reliable links or information on how to set up > the file(s). > Later, Guy -- Guy Algot, Solutions Specialist Edmonton, Alberta (780) 974

Re: Upgrading 2004 to v15

2016-08-30 Thread Guy Algot
> I am glad to hear that it's actually possible to go straight to v15. I'm > going to have lots of questions along the way. I hope you guys don't get > tired of me. > > Guy Algot, I appreciate the offer of help, but we're pretty low budget in > this st

Sending data between 4D servers

2016-09-07 Thread Guy Algot
Given v15s current tickle trunk of features, what would be a good way to send data between servers across the WAN? In the past, I’ve done it by bundling up the data in a BLOB and dropping it on a secure FTP site. Any better, faster, stronger methods one prefers? Thanks. Later, Guy -- Guy

Re: Sending data between 4D servers

2016-09-08 Thread Guy Algot
ote: > > >> Le 8 sept. 2016 à 08:29, Guy Algot a écrit : >> >> Given v15s current tickle trunk of features, what would be a good way to >> send data between servers across the WAN? >> >> In the past, I’ve done it by bundling up the data in a BLOB and dro

Re: Sending data between 4D servers

2016-09-08 Thread Guy Algot
Thanks Tom. Are you using the SQL LOGIN command to do your compares? > On Sep 8, 2016, at 9:23 AM, Benedict, Tom wrote: > > Arnaud de Montard writes: > >>> Le 8 sept. 2016 à 08:29, Guy Algot >>> mailto:g...@macjedi.ca>> a écrit : >>> >>

Re: Sending data between 4D servers

2016-09-08 Thread Guy Algot
use send/receive packet. > Or use http calls between the two. This would give you a real-time > connection. If you don't need that I'd go with setting up the 'watched > folder' idea and some sort of disk file. > > On Wed, Sep 7, 2016 at 11:29 PM, Guy Algot wrote

Re: Sending data between 4D servers

2016-09-08 Thread Guy Algot
ving DB needs to be open to Web services. > > Pack the field into a BLOB or JSON object and send 'em! > Unpack on the other side. > > Randy Engle > XC2 Software LLC > > -Original Message- > From: 4D_Tech [mailto:4d_tech-boun...@lists.4d.com] On Behalf O

Re: Hosting Service for Small System

2017-10-13 Thread Guy Algot via 4D_Tech
ices. We would like to use the current Mac mini and, for a variety of > reasons, the hosting service should be located in the continental US. > > Checking in on the Mac mini colo reveals that they've been absorbed by > macstadium.com. Any comments on that service in particular?

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

2017-12-28 Thread Guy Algot via 4D_Tech
>> I am executing a report with… >>>> >>>> QR REPORT([Timesheets];Get 4D folder(Database folder)+"Resources"+Folder >>>> separator+"TimeSheetEmployeeExport.4qr”) >>>> >>>> This works fine, but I want to dictate

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

2018-03-22 Thread Guy Algot via 4D_Tech
t router has the most street-cred? :) Just, kidding, > so, what router should I consider that you’ve been happy with where you’ve > had a WAN capable of Gigabit speeds? > > Thanks, > > Robert Later, Guy -- Guy Algot, Solutions Specialist Edmonton, Alberta (780) 974-8538 h

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

2018-07-15 Thread Guy Algot via 4D_Tech
at $200/year but now it's going up to $350/year and it's time to loo for > something else. > > Suggestions? > > -- > Kirk Brooks > San Francisco, CA > === > Later, Guy -- Guy Algot, Solutions Specialist Edmonton, Alberta (780) 9

Re: Export/ImportSQL

2018-08-20 Thread Guy Algot via 4D_Tech
ithin the records. > > Anybody have any ideas about this? > Later, Guy -- Guy Algot, Solutions Specialist Edmonton, Alberta (780) 974-8538 hardware, installation, training, support, programming, internet specializing in 4th Dimension =-= =-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=

Re: Colocation - Recommendations Survey

2018-08-29 Thread Guy Algot via 4D_Tech
plex app with 200+tables. > This will be 4D Server v17+ > > It looks like there's a zillion options out there. > I'm looking for recommendations from anyone successfully using these types of > services. > > Gracious thanks > > > Randy Engle, Director > XC

Re: UI Form Updates

2018-12-18 Thread Guy Algot via 4D_Tech
red or deleted. If I switch to one of the other > tabs in form and then switch back, the ListBox reflects the addition or > deletion of the data. Thanks for any help you can give. > > Sandor Szatmari Later, Guy -- Guy Algot, Solutions Specialist Edmonton, Alberta (780) 974-85

Re: Virtualization - Yea or Nay

2017-02-27 Thread Guy Algot via 4D_Tech
Chills indeed… hope that’s a typo… ;-) > On Feb 27, 2017, at 1:41 PM, Tim Nevels via 4D_Tech <4d_tech@lists.4d.com> > wrote: > > I have death with 3 virtual environments that are running 4D Server > applications Later, Guy -- Guy Algot, Solutions Specialist Edmonton, A

Re: Tags in record on 4d.

2017-05-19 Thread Guy Algot via 4D_Tech
nking I should use objects to > handle this. Any suggestions? > > I am running under 4D v15.4 on mac OSX. > > ------- > Later, Guy -- Guy Algot, Solutions Specialist Edmonton, Alberta (780) 974-8538 hardwar

Re: Tags in record on 4d.

2017-05-19 Thread Guy Algot via 4D_Tech
y benefit is you can mix in things like the soundex or metaphone codes. > JPR also mentioned this technique in a 4DWT session. > > On Fri, May 19, 2017 at 8:04 AM, Guy Algot via 4D_Tech <4d_tech@lists.4d.com >> wrote: > >> Eric, >> >> I’ve used this for yea

Re: 4D and Sage

2017-06-13 Thread Guy Algot via 4D_Tech
omated process where once a day our database queries the > Sage db to get info on new/modified/deleted products, and updates the 4D > database. > > Importing and exporting text is OK and that's what they currently do. But > they want something more automated. > > Pat Later, Gu

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

2017-06-27 Thread Guy Algot via 4D_Tech
e remembering this wrong, but I thought that 4D had a built-in way > of letting you type ahead to a row in a listbox. I have a one-column > listbox based on an array and want to select items by type. Like, typing > 'ca' selects the first item starting with 'ca'. Later, G

Re: Optimizing and improving 4D queries.

2017-06-28 Thread Guy Algot via 4D_Tech
fe > 4405 Talmadge St. > Toledo, OH 43623 > Eric Naujock - ACSA 10.2, 10.3, 10.4 Apple - ACTC 10.5, 10.6, 10.7, 10.8, > 10.9, 10.10 > http://www.mac-cafe.com > email: e <mailto:e...@mac-cafe.com>r...@mac-cafe.com > <mailto:e...@mac-cafe.com> > AOL IM

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, Albe

Re: Pasting Spreadsheet Data into 4D Records

2018-12-25 Thread Guy Algot via 4D_Tech
hought about saving the data into a text file and then importing the > text file, but there seem to be unnecessary steps in there! > > Thanks, did some searches but didn't find anything, > Alan Later, Guy -- Guy Algot, Solutions Specialist Edmonton, Alberta (780) 974-8538 ha

Re: 4D Write Pro license question

2019-01-14 Thread Guy Algot via 4D_Tech
lt;4d_tech@lists.4d.com> het volgende geschreven: >> >> You. An create a group called 4d write group. It iS the first people who use >> 4d write code not just logging in Later, Guy -- Guy Algot, Solutions Specialist Edmonton, Alberta (780) 974-8538 hardware, installation

Re: Error -1 using SQL.

2019-07-25 Thread Guy Algot via 4D_Tech
wever, the error call routine does NOT get either error 43 > nor 44, it gets error -1!. > > If I remove the ON ERR CALL and generate the error, I get a 4D runtime > error dialog with error 43 or 44, install ON ERR CALL and get error -1. > > Any insights? Later, Guy -- Guy

Re: 4D v17 Property List Issues - is this only me?

2019-10-02 Thread Guy Algot via 4D_Tech
d nothing happens. It > takes 3 seconds and a „slow double click“ to highlight the cell content. > > Is it only me, or does anyone else have this problem? Anything that can be > done about it? > > Using macOS 10.13.6. > > Thanks, Later, Guy -- Guy Algot, Solutio

Re: Capturing barcodes without a 'text' field

2019-10-16 Thread Guy Algot via 4D_Tech
ected to the USB port, not the RS232 serial port). > > Best Regards > > Peter 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
er adding a framework which adds the OAuth around those commands > or replacing them entirely. An approach which handles to Google situation as > well as other email systems would be useful to everyone going forward. > > > Randy Kaempen > Intellex Corporation > Late

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

2020-04-17 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: HTTP Request when POSTing does not have a response if the HTTP status code # 200

2020-04-18 Thread Guy Algot via 4D_Tech
rted and fixed during R6 beta (no problems in > versions before or after) > > it happened, not always, but often with Google API. > > restricted URL: > > https://forums.4d.com/Post/FR/31950984/1/31950985#319509852361 > > so I think it could be specific to the endpoints

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

2020-04-30 Thread Guy Algot via 4D_Tech
G) > Archive: http://lists.4d.com/archives.html > Options: https://lists.4d.com/mailman/options/4d_tech > Unsub: mailto:4d_tech-unsubscr...@lists.4d.com > ** Later, Guy -- Guy Algot, Solutions Specialist Edmo

Re: Foundation Status?

2020-11-07 Thread Guy Algot via 4D_Tech
ia 4D_Tech <4d_tech@lists.4d.com> >> wrote: >> >> Hi Guys & Walt, >> >> I couldn't ask this question via Walt's web site, but couldn't because the >> Captcha wouldn't display. >> >> Has Foundation been updated to sup

Re: Lost autocomplete for constants

2021-01-21 Thread Guy Algot via 4D_Tech
legacy installers and docs. > > If so, I would also appreciate it if someone could please post a link here. > I seem to have misplaced it. > > Thanks in advance. > > Steven Prins > Santa Fe, NM > >> >> Thanks - are the v13 docs still available? The 4