4D v 18 on Sonoma

2024-02-05 Thread Stephane Potvin via 4D_Tech
Hello all, Is it possible to install and run v 18 on Mac latest OS (Sonoma)? Thanks. ** 4D Internet Users Group (4D iNUG) New Forum: https://discuss.4D.com Archive: http://lists.4d.com/archives.html Options: https://lists.4d.com

Field calculations

2023-09-10 Thread Stephane Potvin via 4D_Tech
Hello all, This is likely a simple thing but, being an amateur in 4D, I am hoping someone can help me with a simple formula. My situation: I audition singers and grade them on up to 9 criteria. When all 9 criteria are used, the formula is simple: v_total:=([Table]Field1+[Table]Field2+[Table]Fie

How to convert date to integer or vice versa

2022-08-07 Thread Stephane Potvin via 4D_Tech
I have two fields in a table which must contain the same information. One is date, the other an integer. Rather than entering the same information twice, I would like to enter it in one field and have 4d fill the other field automatically. Can you help with the proper method to do so. Thank you. *

Re: Built app in v18 can't find data file

2022-04-05 Thread Stephane Potvin via 4D_Tech
ings.4DD > > > > On 4/5/22, 1:10 PM, "4D_Tech on behalf of Stephane Potvin via 4D_Tech" > <4d_tech-boun...@lists.4d.com on behalf of 4d_tech@lists.4d.com> wrote: > >Having no luck with built apps in v19, I decided to resort to v18. V18 > generate

Built app in v18 can't find data file

2022-04-05 Thread Stephane Potvin via 4D_Tech
Having no luck with built apps in v19, I decided to resort to v18. V18 generates the apps no problem. However, every time I open said app it always asks for the data file. The data file is in the same folder. I tried changing the folder to a .4dbase package to no avail. I even deleted the data fi

Signing Fail in creating app in 4D 19

2022-04-04 Thread Stephane Potvin via 4D_Tech
Good day all, I am trying to create a self running application in 4D 19. Never had a problem before. Another almost identical app was generated without problem today but this one DB will not go. I get Signing Fail error. The log shows the following: Application SIGNING_FAILED 38 /Volumes/Drop

Finding duplicates

2022-03-18 Thread Stephane Potvin via 4D_Tech
O ARRAY($al_Positions;$i) > > End if > > End for > > SET QUERY LIMIT(0) > > $tSetFound:=Generate UUID > $tSetAll:=Generate UUID > > CREATE EMPTY SET($p2Table->;$tSetFound) > CREATE EMPTY SET($p2Table->;$tSetAll) > > SET QUERY DESTINATION(

Finding duplicates

2022-03-16 Thread Stephane Potvin via 4D_Tech
Hello, I am looking for a simple a method to find duplicates. A method that would show only the duplicates if they exist or return a message if there are no such duplicates. I already looked in the 4D doc but found nothing that wakers the way I want. Thank you, Stephane **

Search & menu questions

2021-10-28 Thread Stephane Potvin via 4D_Tech
Hello all. Hoping someone can help me. I have two questions. 1. My partner provides piano tuning services and I built a DB for us to keep track of her clients, their pianos, and the tuning/services she provided on each piano. Main table is client information, linked table for services provided

Auto numbering method acting weirdly. Help needed

2020-07-22 Thread Stephane Potvin via 4D_Tech
Good day all, I have a database for organizing my printed music collection. I use a folder numbering system to do so, using this format: Letter-number i.e. A-25, A-26, B-17, B-18, etc. I have one field for the letter and one field for the number. To make it easy, I use the method below to autom