Re: Lost autocomplete for constants

[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 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 4D site only does back to v14
>> 
>> 


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 Ferengi. Unfortunately,
they use Borg to do their marketing and Ferengi to do their programming."
-- Simon Slavin



**
4D Internet Users Group (4D iNUG)
New Forum: https://discuss.4D.com
Archive:  http://lists.4d.com/archives.html
Options: https://lists.4d.com/mailman/options/4d_tech
Unsub:  mailto:4d_tech-unsubscr...@lists.4d.com
**

Re: Foundation Status?

[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. However, it will need to be edited. The BIG 
> issue is that all of the graphics (which are PICTS) will have to be updated 
> or replaced. 
> 
> Regards,
> 
> Ken
> 
> Sent from my iPhone
> 
>> On Nov 6, 2020, at 9:44 AM, Ed Heckman via 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 support v18?
>> 


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 Ferengi. Unfortunately,
they use Borg to do their marketing and Ferengi to do their programming."
-- Simon Slavin



**
4D Internet Users Group (4D iNUG)
New Forum: https://discuss.4D.com
Archive:  http://lists.4d.com/archives.html
Options: https://lists.4d.com/mailman/options/4d_tech
Unsub:  mailto:4d_tech-unsubscr...@lists.4d.com
**

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

[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 database to a project database it will lose the memberships in the 
> users and groups. When exported you will see all your groups and users. But 
> the memberships between the two will disappear. With the exception being 
> “Designer” and “Administrator”.
> 
> Even worse. If you took a User to blob file saved in 4D v17r5 and import it 
> into v18 it will corrupt the minimal users and groups file created when the 
> database was converted. Effectively all the groups will disappear and corrupt 
> groups groups will come into existance.
> 
> A curiosity is that the designer and administrator will keep their 
> memberships, but all the other users will lose the relationships. I have 
> noticed the the new directory.json no longer has user numbers. I suspect this 
> may be part of the problem. This is certainly causing issues with my linking 
> users to their [Employee] table records. The user number used to be a 
> constant and I would use it to tie a user to an employee record with a simple 
> Longint.
> 
> Can anybody verify this is true or not.  Or is there something really simple 
> that I am missing. The good thing is that my users and groups are pretty 
> small so I can manually recreate the directory.json file. Then make a backup 
> of the file in my v18 project. 
> 
> I am using the method of saving the directory.json file in the dat folder to 
> keep my users and groups constant between versions of the database. 
> 
> I remember there was a discussion about users and groups in the past and 
> issues with import-export of the data to a blob.
> **
> 4D Internet Users Group (4D iNUG)
> 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
Edmonton, Alberta
(780) 974-8538

hardware, installation, training, support, programming, internet
specializing in 4th Dimension
=-= =-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=
"Microsoft is a cross between the Borg and the Ferengi. Unfortunately,
they use Borg to do their marketing and Ferengi to do their programming."
-- Simon Slavin



**
4D Internet Users Group (4D iNUG)
Archive:  http://lists.4d.com/archives.html
Options: https://lists.4d.com/mailman/options/4d_tech
Unsub:  mailto:4d_tech-unsubscr...@lists.4d.com
**

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

[Guy Algot via 4D_Tech]

Thanks Keisuke. Somewhat similar but not the same.

My issue only occurs with a POST, I have no issues with a GET.

As well, the example in ACI0100045, the status code was 200. In my case, the 
status is not 200.

I’m trying to connect to the Mailchimp API and the status is documented here… 
https://mailchimp.com/developer/guides/error-glossary/

I have also tested it in v18 and I have the same result. In my case, 4D throws 
and error and the response is empty vs showing the response from the API.

It could be something different with the Mailchimp API. Do you know of any 
other APIs where they return errors in the response where the status is not 
200? If so, I’d love to try and test with them.


> On Apr 18, 2020, at 12:20 AM, Keisuke Miyako via 4D_Tech 
> <4d_tech@lists.4d.com> wrote:
> 
> that sounds similar to ACI0100045
> 
> which was a regression reported 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 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 iNUG)
Archive:  http://lists.4d.com/archives.html
Options: https://lists.4d.com/mailman/options/4d_tech
Unsub:  mailto:4d_tech-unsubscr...@lists.4d.com
**

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

[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
=-= =-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=
"Microsoft is a cross between the Borg and the Ferengi. Unfortunately,
they use Borg to do their marketing and Ferengi to do their programming."
-- Simon Slavin



**
4D Internet Users Group (4D iNUG)
Archive:  http://lists.4d.com/archives.html
Options: https://lists.4d.com/mailman/options/4d_tech
Unsub:  mailto:4d_tech-unsubscr...@lists.4d.com
**

Re: Gmail, LSA, and OAuth

[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 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
> 


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 Ferengi. Unfortunately,
they use Borg to do their marketing and Ferengi to do their programming."
-- Simon Slavin



**
4D Internet Users Group (4D iNUG)
Archive:  http://lists.4d.com/archives.html
Options: https://lists.4d.com/mailman/options/4d_tech
Unsub:  mailto:4d_tech-unsubscr...@lists.4d.com
**

Re: Capturing barcodes without a 'text' field

[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
> 
> Was wondering what technique people used for capturing scans into 4D. At the 
> moment I’m using a simple text field and the scanner simply ‘pastes’ the code 
> into the text field, but something a bit more sophisticated is called for 
> ideally where a scan can be “detected” by the 4D form even though no text 
> field may be present. (e.g. as one of a number of possible form actions or as 
> an alternative to a manual lookup of the product).
> 
> Is anybody implementing such an approach ? What capture methods do you use ? 
> (The scanner is connected 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
=-= =-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=
"Microsoft is a cross between the Borg and the Ferengi. Unfortunately,
they use Borg to do their marketing and Ferengi to do their programming."
-- Simon Slavin



**
4D Internet Users Group (4D iNUG)
Archive:  http://lists.4d.com/archives.html
Options: https://lists.4d.com/mailman/options/4d_tech
Unsub:  mailto:4d_tech-unsubscr...@lists.4d.com
**

Re: Error -1 using SQL.

[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 expecting listed.

I’m not sure why the difference.

> On Jul 25, 2019, at 1:16 PM, Chip Scheide via 4D_Tech <4d_tech@lists.4d.com> 
> wrote:
> 
> I am working up a method to set the primary key property on a field.
> I am using SQL to do this, as it seems the only way.
> 
> I have working code, but - I noticed if I try to apply the primary key 
> property a second time I get a runtime error either 43 or 44 with the 
> message : Failed to execute ALTER TABLE command.
> 
> So... naturally I setup an ON ERR CALL method to catch and report the 
> problem. However, 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 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 Ferengi. Unfortunately,
they use Borg to do their marketing and Ferengi to do their programming."
-- Simon Slavin



**
4D Internet Users Group (4D iNUG)
Archive:  http://lists.4d.com/archives.html
Options: https://lists.4d.com/mailman/options/4d_tech
Unsub:  mailto:4d_tech-unsubscr...@lists.4d.com
**

Re: 4D Write Pro license question

[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:
> 
> Hi Chuck,
> 
> IMHO this is not correct.
> 
> I recently struggled a lot with 4D View (Pro) licenses. A customer has 40+ 
> users on 4D Server (v16), but only a few of them need 4D View. So they bought 
> a 5 user license. These are my findings :
> 
> - if there are no user groups, the licenses are assigned upon login (until 
> the number of licenses is exceeded) and freed when the user logs out. 
> Actually using the plugin code is not required.
> 
> - if there are user groups, it depends...
> -- a user who is not in a group will get a license on login
> -- if the plugin access is not limited to a group (plugin checkbox not 
> checked in any group), all users will get a license (if available)
> -- if plugin access is limited to a group (plugin access can be limited to 
> only one group!), only users belonging to that group will get a license when 
> logging in (which I needed)
> 
> Caveats:
> - USERS TO BLOB will only store the goups created by Administrator (standard 
> behaviour). Eg when you want to restore the settings when updating your db at 
> a customers site.
> - BLOB TO USERS does not restore the group plugin access (at least not in 
> v16.3, haven't tested v17 yet). Bug? I don't know (yet). Maybe USERS TO BLOB 
> does not store these settings correctly?
> 
> HTH
> Koen
> 
>> Op 14 jan. 2019, om 02:28 heeft cjmiller--- via 4D_Tech 
>> <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, training, support, programming, internet
specializing in 4th Dimension
=-= =-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=
"Microsoft is a cross between the Borg and the Ferengi. Unfortunately,
they use Borg to do their marketing and Ferengi to do their programming."
-- Simon Slavin

**
4D Internet Users Group (4D iNUG)
Archive:  http://lists.4d.com/archives.html
Options: https://lists.4d.com/mailman/options/4d_tech
Unsub:  mailto:4d_tech-unsubscr...@lists.4d.com
**

Re: Pasting Spreadsheet Data into 4D Records

[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 Tilson via 4D_Tech <4d_tech@lists.4d.com> 
> wrote:
> 
> Greetings everyone,
> 
> Is there a way to copy from a spreadsheet like data source and to paste
> directly into 4d while parsing it into table(s) and fields? I'm using v17
> if that matters.
> 
> I thought 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

hardware, installation, training, support, programming, internet
specializing in 4th Dimension
=-= =-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=
"Microsoft is a cross between the Borg and the Ferengi. Unfortunately,
they use Borg to do their marketing and Ferengi to do their programming."
-- Simon Slavin



**
4D Internet Users Group (4D iNUG)
Archive:  http://lists.4d.com/archives.html
Options: https://lists.4d.com/mailman/options/4d_tech
Unsub:  mailto:4d_tech-unsubscr...@lists.4d.com
**

Re: UI Form Updates

[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 data entry form and a '-' button to display a 'confirm the 
> deletion of the selected row' dialog.  However, once the entry form or the 
> dialog are dismissed the ListBox in the table does not update to show that 
> the new data has been entered 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-8538

hardware, installation, training, support, programming, internet
specializing in 4th Dimension
=-= =-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=
"Microsoft is a cross between the Borg and the Ferengi. Unfortunately,
they use Borg to do their marketing and Ferengi to do their programming."
-- Simon Slavin


**
4D Internet Users Group (4D iNUG)
Archive:  http://lists.4d.com/archives.html
Options: https://lists.4d.com/mailman/options/4d_tech
Unsub:  mailto:4d_tech-unsubscr...@lists.4d.com
**

Re: Colocation - Recommendations Survey

[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, 2018, at 10:09 AM, Randy Engle via 4D_Tech <4d_tech@lists.4d.com> 
> wrote:
> 
> We are ready to roll out a couple of SaaS/Cloud solutions
> 
> We have our test server installed at our site, but know that for production, 
> it really needs to be at much more protected/powerbacked facility.
> We will also "very likely" need access via Citrix/Remote Desktop as besides 
> the web interface, we will also need a standard 4D Client connection.
> The performance over WAN to the server will most likely not be adequate.  
> It's a relatively complex 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
> XC2 Software LLC – XC2LIVE!


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 Ferengi. Unfortunately,
they use Borg to do their marketing and Ferengi to do their programming."
-- Simon Slavin



**
4D Internet Users Group (4D iNUG)
Archive:  http://lists.4d.com/archives.html
Options: https://lists.4d.com/mailman/options/4d_tech
Unsub:  mailto:4d_tech-unsubscr...@lists.4d.com
**

Re: Export/ImportSQL

[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 database using EXPORT SQL and importing it
> into a v16 database.
> For the most part this works OK, but in some tables, records are missing.
> I can't see anything consistently different or wrong within the missing
> records.
> 
> All text fields are stored within 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
=-= =-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=
"Microsoft is a cross between the Borg and the Ferengi. Unfortunately,
they use Borg to do their marketing and Ferengi to do their programming."
-- Simon Slavin



**
4D Internet Users Group (4D iNUG)
Archive:  http://lists.4d.com/archives.html
Options: https://lists.4d.com/mailman/options/4d_tech
Unsub:  mailto:4d_tech-unsubscr...@lists.4d.com
**

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

[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 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) 974-8538

hardware, installation, training, support, programming, internet
specializing in 4th Dimension
=-= =-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=
"Microsoft is a cross between the Borg and the Ferengi. Unfortunately,
they use Borg to do their marketing and Ferengi to do their programming."
-- Simon Slavin



**
4D Internet Users Group (4D iNUG)
FAQ:  http://lists.4d.com/faqnug.html
Archive:  http://lists.4d.com/archives.html
Options: https://lists.4d.com/mailman/options/4d_tech
Unsub:  mailto:4d_tech-unsubscr...@lists.4d.com
**

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

[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 home/office to Gigabit internet today and quickly discovered 
> that the WAN to LAN routing performance of my 5th generation Apple AirPort 
> Extreme is lacking in a big way. I can get as high as 941 Mbps downstream 
> directly connected to my SB-8200. When I go through AirPort Extreme router, 
> I’m getting 552 Mbps at best. Can you recommend a high-performance internet 
> router for the modern age? Also, the Apple router was always lacking in 
> features such as: no QOS and no VPN. So, I’m interested in more of a full 
> featured product. What 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

hardware, installation, training, support, programming, internet
specializing in 4th Dimension
=-= =-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=
"Microsoft is a cross between the Borg and the Ferengi. Unfortunately,
they use Borg to do their marketing and Ferengi to do their programming."
-- Simon Slavin



**
4D Internet Users Group (4D iNUG)
FAQ:  http://lists.4d.com/faqnug.html
Archive:  http://lists.4d.com/archives.html
Options: https://lists.4d.com/mailman/options/4d_tech
Unsub:  mailto:4d_tech-unsubscr...@lists.4d.com
**

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

[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 COLUMN(myQR;4;->[InvoiceItems]PartNo)

QR SET DESTINATION(myQR;qr text file;$path_vT)
QR RUN(myQR)
QR DELETE OFFSCREEN AREA(myQR)

What you were able to do in versions prior to v16 was generate this code by 
simply designing the report in the QR editor and using the wizard.  I cannot 
find the wizard in the new QR editor.


> On Dec 28, 2017, at 8:30 AM, Douglas von Roeder via 4D_Tech 
> <4d_tech@lists.4d.com> wrote:
> 
> John:
> 
> I wasn't sure of how QR REPORT worked. I checked the docs and the path at
> $2 is the path to the report so my thinking was there there was a save file
> dialog needed.
> 
> The other thing that came to mind was is you could handle this like you
> would with 4D Write - create an offscreen area, run the report in the
> offscreen area, and then handle the report as desired. That's what the last
> example (#5) in the docs does - it creates the report in a BLOB which you
> can handle with 4D document commands. Is that something that might take
> care of it?
> 
> --
> Douglas von Roeder
> 949-336-2902
> 
> On Wed, Dec 27, 2017 at 10:54 PM, John Baughman via 4D_Tech <
> 4d_tech@lists.4d.com> wrote:
> 
>> Thanks Doug. What I need is specifically related to using the command QR
>> REPORT with a prebuilt .4qr file which exports a selection of records to a
>> text file. I am not at all concerned with where the file is being saved,
>> but what the file name will be.
>> 
>> I do not see any way to force QR REPORT to bypass the Save As dialogue, or
>> to set the suggested file name to anything other than My Report.txt.
>> 
>> Correct me if I am wrong, but I don’t think what you suggested will work
>> with QR REPORT to set the file name or to otherwise use the .4qr file such
>> that I can specify the file name.
>> 
>> John
>>> 
>>> On Wed, Dec 27, 2017 at 4:43 PM, John Baughman via 4D_Tech <
>>> 4d_tech@lists.4d.com> wrote:
>>> 
 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 or at least offer a preset file
 name to the end user in the save dialogue. Tried various approaches
>> without
 any success.
 
 Thanks for any help.
 
 John
 


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 Ferengi. Unfortunately,
they use Borg to do their marketing and Ferengi to do their programming."
-- Simon Slavin



**
4D Internet Users Group (4D iNUG)
FAQ:  http://lists.4d.com/faqnug.html
Archive:  http://lists.4d.com/archives.html
Options: http://lists.4d.com/mailman/options/4d_tech
Unsub:  mailto:4d_tech-unsubscr...@lists.4d.com
**

Re: Hosting Service for Small System

[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 working with a company that has a seven user server running on a Mac
> mini. They've decided to go "office-less" and are looking to have their
> system hosted.
> 
> This is a new area to me so I'm looking for recommendations for hosting
> services. 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?
> 
> Thanks in advance.
> 


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 Ferengi. Unfortunately,
they use Borg to do their marketing and Ferengi to do their programming."
-- Simon Slavin



**
4D Internet Users Group (4D iNUG)
FAQ:  http://lists.4d.com/faqnug.html
Archive:  http://lists.4d.com/archives.html
Options: http://lists.4d.com/mailman/options/4d_tech
Unsub:  mailto:4d_tech-unsubscr...@lists.4d.com
**

Re: Method Header Strategies

[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

hardware, installation, training, support, programming, internet
specializing in 4th Dimension
=-= =-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=
"Microsoft is a cross between the Borg and the Ferengi. Unfortunately,
they use Borg to do their marketing and Ferengi to do their programming."
-- Simon Slavin



**
4D Internet Users Group (4D iNUG)
FAQ:  http://lists.4d.com/faqnug.html
Archive:  http://lists.4d.com/archives.html
Options: http://lists.4d.com/mailman/options/4d_tech
Unsub:  mailto:4d_tech-unsubscr...@lists.4d.com
**

Re: Optimizing and improving 4D queries.

[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 performance tuning an optimizing on one of my 
> 4D databases and am finding that one function RELATE MANY is taking over 1790 
> ms. At lease are there any 4d Tools that are available to help analyze the 
> case of tis timeout and resolve the issue. I have tried adjusting the indexes 
> on the related records but that does not seem to help.
> 
> It would be useful to have a function or a way to find out what the database 
> is doing when the functions run to find out why the function takes so long to 
> run.  Any suggestions on tools to help solve this problem.
> 
> I tried the analyze query command but that did not tell me anything. So far 
> al I have tis the debug log to try to help guide where my slowdowns are but 
> that is rather tedious.
> 
> ---
> 
> MacCafe
> 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 r...@mac-cafe.com 
> 
> AOL IM: erlic
> 


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 Ferengi. Unfortunately,
they use Borg to do their marketing and Ferengi to do their programming."
-- Simon Slavin



**
4D Internet Users Group (4D iNUG)
FAQ:  http://lists.4d.com/faqnug.html
Archive:  http://lists.4d.com/archives.html
Options: http://lists.4d.com/mailman/options/4d_tech
Unsub:  mailto:4d_tech-unsubscr...@lists.4d.com
**

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

[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 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,
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 Ferengi. Unfortunately,
they use Borg to do their marketing and Ferengi to do their programming."
-- Simon Slavin



**
4D Internet Users Group (4D iNUG)
FAQ:  http://lists.4d.com/faqnug.html
Archive:  http://lists.4d.com/archives.html
Options: http://lists.4d.com/mailman/options/4d_tech
Unsub:  mailto:4d_tech-unsubscr...@lists.4d.com
**

Re: 4D and Sage

[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 know how they compare to something like Sage.

It would be great to hear how others are using Xero. Seems like a good fit for 
4D...

> On Jun 13, 2017, at 9:34 AM, Pat Bensky via 4D_Tech <4d_tech@lists.4d.com> 
> wrote:
> 
> Hi Dougie,
> Interesting ... we use Xero for our own business. Hadn't thought of
> integrating with that, but seems like it would be an interesting idea.
> 
> Unfortunately lots of companies are deeply entrenched in Sage :)
> 
> Is it not possible to integrate via ODBC? For example a customer might want
> to set up an automated 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,
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 Ferengi. Unfortunately,
they use Borg to do their marketing and Ferengi to do their programming."
-- Simon Slavin



**
4D Internet Users Group (4D iNUG)
FAQ:  http://lists.4d.com/faqnug.html
Archive:  http://lists.4d.com/archives.html
Options: http://lists.4d.com/mailman/options/4d_tech
Unsub:  mailto:4d_tech-unsubscr...@lists.4d.com
**

Re: Tags in record on 4d.

[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 you want to be.

Did you go to the World Tour? JPR demo’d something like this on Day 1.


> On May 19, 2017, at 8:25 AM, Eric Naujock via 4D_Tech <4d_tech@lists.4d.com> 
> wrote:
> 
> Has anybody come up with a good way add tags records in a table?
> 
> For instance I have a table of contacts, but I would like to be able to tags 
> them with labels and then be able to filter on those labels. Kind of like the 
> usage of tags in osx. 
> 
> In this case I would like to be able to add tags created by users to tag 
> contacts. I have my contacts table, I am thinking 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

hardware, installation, training, support, programming, internet
specializing in 4th Dimension
=-= =-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=
"Microsoft is a cross between the Borg and the Ferengi. Unfortunately,
they use Borg to do their marketing and Ferengi to do their programming."
-- Simon Slavin



**
4D Internet Users Group (4D iNUG)
FAQ:  http://lists.4d.com/faqnug.html
Archive:  http://lists.4d.com/archives.html
Options: http://lists.4d.com/mailman/options/4d_tech
Unsub:  mailto:4d_tech-unsubscr...@lists.4d.com
**