Re: Scope of entity selection

2018-10-13 Thread Alan Chan via 4D_Tech
Hi Peter, I haven't touched v17 yet. There might be easier way. If not, you could try LONGINT ARRY FROM SELECTION and pack the array into shared object. Alan Chan 4D iNug Technical <4d_tech@lists.4d.com> writes: >This may be related to other thread - Defining and documenting objects - as >it

Re: Scheduled ISP Maintenance @ 4D Office (France)

2018-08-07 Thread Alan Chan via 4D_Tech
I guess most engineers of its ISP were on vacation (the famous French summer vacation). Alan Chan 4D iNug Technical <4d_tech@lists.4d.com> writes: >I have been trying to get licensing since Friday Still no luck. > >dave > >On Tue, Aug 7, 2018 at 4:26 AM, Pat Bensky via 4D_Tech

Re: v16 & 17 components and plugins

2018-07-18 Thread Alan Chan via 4D_Tech
Quote "Over the course of different versions, the most useful 4D Pack routines were progressively integrated into 4D itself, while those that became obsolete were removed. Starting with 4D v16 R2, the 4D Pack plug-in is no longer provided in versions of 4D" end quote

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

2018-07-16 Thread Alan Chan via 4D_Tech
We use RealVNC on all servers but use TeamViewer for client machines. We used to use LogMeIn for client machines but our support guys prefer Teamviewer and I didn't ask why. Alan Chan ** 4D Internet Users Group (4D iNUG) FAQ:

Re: just a curiosity - pre emptive threads

2018-07-13 Thread Alan Chan via 4D_Tech
Oops... I reply too fast. You've answered your question. Alan Chan Chip Scheide <4d_o...@pghrepository.org> writes: >(I think that to get around the Set process variable you would use >'Storage') ** 4D Internet Users Group (4D

Re: just a curiosity - pre emptive threads

2018-07-12 Thread Alan Chan via 4D_Tech
May be using Shared Object to replace variable. Alan Chan 4D iNug Technical <4d_tech@lists.4d.com> writes: >1 - doesn't this idea 'break' with preemptive code (using Set Process >Variable)? >(I think that to get around the Set process variable you would use >'Storage') >2 - how does 4D

Re: just a curiosity - pre emptive threads

2018-07-12 Thread Alan Chan via 4D_Tech
Why not? It isn't supported? I just checked In Transaction in trigger is a preemptive compliant. It means, preemptive mode does expect transaction. Any hidden constraint? Without transaction, trigger is meaningless. When a trigger invoked, mulitple tables might be updated inside the trigger.

Re: just a curiosity - pre emptive threads

2018-07-12 Thread Alan Chan via 4D_Tech
I don't need preemptive client side on data updates. I care about server side only. Data entry/updates are human works in our case, one at a time (one entry per second through barcode scanner). If triggers on server could be completed in less time even when server loading is heavy, it won't

Re: just a curiosity - pre emptive threads

2018-07-12 Thread Alan Chan via 4D_Tech
That's what I understand in the first place as following. - do data entry in a form (UI in application process) - in the form, I click a button call SAVE RECORD (in the same applicaation process) - As long as all codes in the trigger are preemptive compliant, the trigger would be running in

Re: just a curiosity - pre emptive threads

2018-07-12 Thread Alan Chan via 4D_Tech
I'm a bit confused. When I just call SAVE RECORD in data entry form (cooperative process), I was told it's not OK because it's from a process that have UI. Now, your latest reply claimed it's OK. Or only if there's no trigger and transaction? If I create a new process that contain "no" UI from

Re: just a curiosity - pre emptive threads

2018-07-12 Thread Alan Chan via 4D_Tech
Thanks. OK. Forget about the syntax, just the idea. - open data entry dialog - check button value - if button value is validate, save all new value in an object, then call worker with object and form window process as parameters - the worker process create new/load an existing record and modify

Re: just a curiosity - pre emptive threads

2018-07-12 Thread Alan Chan via 4D_Tech
>other processes (without using semaphores etc.), so in many ways its like a >stored procedure (and not a method with the “execute on server” property.) > >2018/07/12 13:36、Alan Chan via 4D_Tech ><4d_tech@lists.4d.com<mailto:4d_tech@lists.4d.com>>のメール: >Of cours

Re: just a curiosity - pre emptive threads

2018-07-11 Thread Alan Chan via 4D_Tech
o resolve expressions such as Table(n)-> >(all triggers are inspected for such expressions, so actually its better to >use absolute tokens) > >2018/07/12 12:20、Alan Chan via 4D_Tech ><4d_tech@lists.4d.com<mailto:4d_tech@lists.4d

Re: just a curiosity - pre emptive threads

2018-07-11 Thread Alan Chan via 4D_Tech
Hopefully, 4D remote could be supported in 4D 18:-( However, 4D server (thus triggers) is supported. I'm just wondering does anyone try that out on triggers? Alan Chan 4D iNug Technical <4d_tech@lists.4d.com> writes: >Are you doing all this in single user mode? > >I think a lot of people don't

Re: Bug reports?

2018-06-11 Thread Alan Chan via 4D_Tech
Try http://forums.4d.com/Bugs/EN/ Alan Chan 4D iNug Technical <4d_tech@lists.4d.com> writes: >Hi, > >Where do we file bug reports now? bugs.4d.fr no longer >exists, and TAOW doesn’t allow me to create any bug reports, I’m not a partner. > >All the best, > > - Aparajita >

Re: "Your password does not allow you to use this form"

2018-05-24 Thread Alan Chan via 4D_Tech
May be trying to use Char(1) instead of "xxx". Char(1) works well for us. Alan Chan 4D iNug Technical <4d_tech@lists.4d.com> writes: >On v13.5: > >Forever, we've had a Labels option with this code: > >PRINT LABEL(Table(iTableNumber)->;"xxx") > >​This has always worked as expected: it opens the

Re: Preventing Return and Enter from Closing a Dialog

2018-05-20 Thread Alan Chan via 4D_Tech
In additions to what you did in your link, did you also do the following : 1) Set standard action to no action instead of accept 2) Set form event to on clicked 3) Add a method in button to do your search or whatever and make sure no command of ACCEPT being used. It has been working for us for

Re: Preventing Return and Enter from Closing a Dialog

2018-05-20 Thread Alan Chan via 4D_Tech
Our system has all default Accept/Cancel shortcut unchecked in Database Design Interface setting. We disabled it 20+ years ago:-) It was a tough call back then. Alan Chan 4D iNug Technical <4d_tech@lists.4d.com> writes: >It gets weird if you have an application-wide default close and cancel

Re: Preventing Return and Enter from Closing a Dialog

2018-05-20 Thread Alan Chan via 4D_Tech
Would setting the Standard Action to No Action be OK in button properties? Then add a method in button to do whatever you like. Alan Chan 4D iNug Technical <4d_tech@lists.4d.com> writes: >Aloha, > >I'm playing with the "proper" way to open up a form. Here's what I have: > Open form

Re: 4d servers down

2018-04-22 Thread Alan Chan via 4D_Tech
We can't access it either:-( Very unstable recently. Alan Chan 4D iNug Technical <4d_tech@lists.4d.com> writes: >livedoc, taow, 4dbb web servers do not respond. >So do you? > >-- >Arnaud de Montard > > > >** >4D Internet

Re: Error Code reserved by 4D

2018-02-03 Thread Alan Chan via 4D_Tech
by error handler but mostly could be get around with extra coding. We are still in 15.5 and may be -20002 is new in 16 or 16Rx Alan Chan 4D iNug Technical <4d_tech@lists.4d.com> writes: > >> Le 3 févr. 2018 à 11:18, Alan Chan via 4D_Tech <4d_tech@lists.4d.com> a >> écr

Re: Error Code reserved by 4D

2018-02-03 Thread Alan Chan via 4D_Tech
Hmm... I didn't see -20002 there. Alan Chan 4D iNug Technical <4d_tech@lists.4d.com> writes: >which should logically exclude predefined error codes, >but even then, you are not prohibited from using a certain range. > >http://doc.4d.com/4Dv16R4/4D/16-R4/Error-Codes.200-3316679.en.html

Re: Error Code reserved by 4D

2018-02-02 Thread Alan Chan via 4D_Tech
ml >http://doc.4d.com/4Dv16R4/4D/16-R4/On-Backup-Shutdown-database-method.301-3316859.en.html > >which should logically exclude predefined error codes, >but even then, you are not prohibited from using a certain range. > >http://doc.4d.com/4Dv16R4/4D/16-R4/Error-Codes.200-3316679.en

Re: Error Code reserved by 4D

2018-02-02 Thread Alan Chan via 4D_Tech
m: 4D_Tech [mailto:4d_tech-boun...@lists.4d.com] On Behalf Of Alan Chan via >4D_Tech >Sent: Friday, February 02, 2018 1:36 AM >To: 4d_tech@lists.4d.com >Cc: Alan Chan <a...@belhk.com> >Subject: Error Code reserved by 4D > >I thought error codes under -15000 were not rese

Error Code reserved by 4D

2018-02-02 Thread Alan Chan via 4D_Tech
I thought error codes under -15000 were not reserved by 4D. Now it produces error -20002 that might crash with user generated error for business rules control. Could anyone tell if 4D changes error code range reserved by 4D? TIA. Alan Chan 4D iNug Technical <4d_tech@lists.4d.com> writes: >I

Re: "Goodbye 4D Write" email

2018-02-01 Thread Alan Chan via 4D_Tech
Omnis is still around and very alive. Alan Chan 4D iNug Technical <4d_tech@lists.4d.com> writes: >How many of you >used to work using Foxbase, dBase, Omnis, to name a few. Just be greatful >that the company has been able to keep up with the times and is still a >viable product.

Re: 4D v13 and Windows 10

2018-01-28 Thread Alan Chan via 4D_Tech
We don't know about 13.5. However, with 13.6, we haven't encountered any issue on Windows 10 so far. Alan Chan 4D iNug Technical <4d_tech@lists.4d.com> writes: >Hey everyone - in a nutshell, what's the current wisdom on 4D v13.5 >compatibility with the different flavors of Windows 10? I've

Re: localisation (again)

2017-12-13 Thread Alan Chan via 4D_Tech
Alternative simplified version of Num for this situation C_REAL($0;$num) //same as ES_num yet support decimal C_TEXT($1) C_LONGINT($len;$i;$k;$j) $num:=0 $len:=Length($1) For ($i;$len;1;-1) $k:=Character code($1[[$i]]) If (($k>47) & ($k<58)) $num:=$num+(($k-48)*(10^($len-$i-$j))) Else If

Re: poor performance LISTBOX INSERT COLUMN

2017-12-04 Thread Alan Chan via 4D_Tech
4D iNug Technical <4d_tech@lists.4d.com> writes: >Maybe it does matter how many listboxes are on the form? I assumed you built LB with one method per LB. > >Maybe LISTBOX INSERT COLUMN becomes slower when more columns are inserted? I assumed that you were "appending" column instead of inserting

Re: poor performance LISTBOX INSERT COLUMN

2017-12-03 Thread Alan Chan via 4D_Tech
I just tested LISTBOX INSERT COLUMN command on array based LB that takes only 0 to 1 ms to complete on my MBP 2.90GHZ with 16G memory. I'm not sure if size of array is the factor. Alan Chan 4D iNug Technical <4d_tech@lists.4d.com> writes: >The LISTBOX INSERT COLUMN command takes on average

Re: poor performance LISTBOX INSERT COLUMN

2017-12-03 Thread Alan Chan via 4D_Tech
If your customer want to be king, he/she has to act like one, spend like one. Did your customer try to put up more resources on hardware? Investing 32G+ memory on 4.0Ghz+ machine with great grahic chip for big monitor to run your application might be helpful especially populating 27 listbox

Re: Connection is broken, cannot receive request reply

2017-11-14 Thread Alan Chan via 4D_Tech
Just curious, 4 seconds for idle connections timeout? Alan Chan 4D iNug Technical <4d_tech@lists.4d.com> writes: >SET DATABASE PARAMETER(54;4)// Idle connections timeout ** 4D Internet Users Group (4D iNUG) FAQ:

Re: Gridline for header in Listbox

2017-11-11 Thread Alan Chan via 4D_Tech
I agree with your taste:-) In fact, we originally used alternate color that looks really good and I love it. This is the case in "most" scenario except those contains so many columns and rows in a limited sized LB. This would make it so cramped. Finally, we have 2 desgins - one with alternate

Re: Gridline for header in Listbox

2017-11-10 Thread Alan Chan via 4D_Tech
Hi Keith, Good trick. For the moment, we didn't use zebra stripes for other reasons. We might simply draw a line under the header for Windows 10 users with Miyako's approach. Alan Chan 4D iNug Technical <4d_tech@lists.4d.com> writes: >Alan, I noticed this too - it does look odd - and I

Re: Gridline for header in Listbox

2017-11-10 Thread Alan Chan via 4D_Tech
this: > >https://github.com/4D-JP/4d-tips-listbox-header-border > >> 2017/11/10 17:47、Alan Chan via 4D_Tech <4d_tech@lists.4d.com> のメール: >> no line for header which looks odd. > > ** 4D Internet Use

Gridline for header in Listbox

2017-11-10 Thread Alan Chan via 4D_Tech
Any idea how to set horizontal gridline only for header but not rows in Listbox in 4D 15.5? On Mac, there’s horizontal line for header automatically which looks good. However, on Windows 10, no line for header which looks odd. I tried LISTBOX SET GRID and none of followings works:-( LISTBOX

Re: Normalization question

2017-11-08 Thread Alan Chan via 4D_Tech
Table Project Master Employee Master Project member Project master <- Project member -> Employee master Project member table contains Role (integer) 0=regular member; 1=role A; 2=role B; 3=whatever role Alan Chan 4D iNug Technical <4d_tech@lists.4d.com> writes: >Given a Project table and an

Re: [Warning] Settings properties values on object field by object notation

2017-11-02 Thread Alan Chan via 4D_Tech
I am not challenging how 4D feature request should be working. I'm just wondering if 4D support folks file the request with the link to this thread like http://4d.1045681.n5.nabble.com/Warning-Settings-properties-values-on-object-field-by-object-notation-td5755088.html and

Re: San Fransisco Font

2017-10-10 Thread Alan Chan via 4D_Tech
Interesting, we don't actual use stylesheet. Back to old days (non-unicode), we need to assign different font for different languages. Due to different OS version and platform, we allow users to set font but not font size and saved by machine. These setting has been embedded in our system for

Re: 4D v16.2 false record locks

2017-10-04 Thread Alan Chan via 4D_Tech
Are you running in new network layer in production? If you're unable to run on new network layer reliably, I might not be calling it "improved stability". Alan Chan 4D iNug Technical <4d_tech@lists.4d.com> writes: >In my opinion, Stability has improved A LOT since the R-release program. >I was

Re: v13 - replace string, odd slowness

2017-09-30 Thread Alan Chan via 4D_Tech
Just rewrite it not to use variable to blob which might be easier to read. C_TEXT($0;$1;$2;$3;$source;$oldStr;$newStr;$result;$tempTxt) //ES_ReplaceStr($source;$oldString;$newString;{$count pointer})->Resulted text C_POINTER($4)

Re: v13 - replace string, odd slowness

2017-09-30 Thread Alan Chan via 4D_Tech
Hi Chip, I forgot to mention that the method is for doc which is in utf16 format. Alan Chan 4D iNug Technical <4d_tech@lists.4d.com> writes: >To replace shorter old string with longer one, you could try the following: ** 4D

Re: v13 - replace string, odd slowness

2017-09-29 Thread Alan Chan via 4D_Tech
Hi Chip, This is a known issue on v13. When old string and new string is of different length, it will become very slow if the file was large and large number of occurance. 4D has rewritten it on v15. I posted a method on

Re: 4D v16.2 false record locks

2017-09-20 Thread Alan Chan via 4D_Tech
Hi Koen, I think your case is very different and might be v16 issue as user was still on server list and you couldn't disconnet it. The trigger issue (not actually an issue) I mentioned was the record was locked and the related user wasn't even on the server list. Alan Chan 4D iNug Technical

Re: 4D v16.2 false record locks

2017-09-19 Thread Alan Chan via 4D_Tech
If a record wasn't unloaded in trigger properly, the record would be locked even after the invoking client user left the system (no longer signed in). The only way is to restart the server. Alan Chan 4D iNug Technical <4d_tech@lists.4d.com> writes: >The client timeout will remove a dead user

Re: Unable to Compile - Crash - looking for ideas - SOLVED

2017-08-21 Thread Alan Chan via 4D_Tech
Yes, this is highly recommended. "All Variables are typed" is one of greatest debug tool in 4D. Alan Chan 4D iNug Technical <4d_tech@lists.4d.com> writes: >I would also recommend changing the settings from > Generate Typing >to > All Variables are typed

Re: Arrays vs Object for Key/Value pair lookups

2017-07-17 Thread Alan Chan via 4D_Tech
Case sensitive comparison support in Find in array/Find in sorted array is long overdue. Even best, supported in string compariosn operator (or new operator for string) $true:=($string1=*$string2) $true:=($string1>*$string2) $true:=($string1<*$string2) Alan Chan 4D iNug Technical

Re: Quick report strange behavior

2017-07-11 Thread Alan Chan via 4D_Tech
We do use v13.6 on Windows 8 and 10 without your problem. Did you try 13.6 instead of 13.3? v11 of 4D does exhibit problem you mentioned. I'm not sure if the problem exists in 13.3 or not. Alan Chan 4D iNug Technical <4d_tech@lists.4d.com> writes: >Hi all, > >No one use 4D V13 on windows 8? >

Re: Interesting(?) Tales of Coding Was : Request for tech note

2017-07-11 Thread Alan Chan via 4D_Tech
I wrote a Get Prime routine in 56 lines of 4D code years ago for fun to generate prime number in array of whatever number users enter as parameter. Alan Chan 4D iNug Technical <4d_tech@lists.4d.com> writes: >https://i.redd.it/fjcv9evg6u8z.png

Re: What exactly is the scope of the On err call between 4D server & Client?

2017-07-07 Thread Alan Chan via 4D_Tech
We always install new On err call on triggers. Alan Chan 4D iNug Technical <4d_tech@lists.4d.com> writes: >I don't remember...triggers? ** 4D Internet Users Group (4D iNUG) FAQ: http://lists.4d.com/faqnug.html Archive:

Re: Request : Text utilities

2017-07-06 Thread Alan Chan via 4D_Tech
Thanks. It's good to know. Alan Chan 4D iNug Technical <4d_tech@lists.4d.com> writes: >Well observed. Aussies can be *way* to polite to tell someone when they're >being rude, so, yeah, they might not complain about a little thing that >they can live with.

Re: Request : Text utilities

2017-07-06 Thread Alan Chan via 4D_Tech
We have been formatting Australia phone number like (2) 3456 7899 434 567 899 Are these acceptable by Australian? So far, we haven't got any complaint (may be they're too nice to say anything). TIA Alan Chan 4D iNug Technical <4d_tech@lists.4d.com> writes: >Note that local custom varies. For

Re: Nested transactions - most appreciated feature

2017-07-02 Thread Alan Chan via 4D_Tech
It's our standard design to do test "In Transaction" and Trigger Level in trigger. We never used cascade trigger either. Error handling in trigger is also standard in our design. We have to create large error code base for error interpretion in multiple language. Alan Chan 4D iNug Technical

Re: Nested transactions - most appreciated feature

2017-07-02 Thread Alan Chan via 4D_Tech
Yes, having UI in transaction is not ideal (at least in our design) and that's why we never used that approach. Update pricing is pretty routine for us as well (in our retail module) but we never need nested transaction. if no ui is involved, Master transaction nested transaction 1 for task

Re: Nested transactions - most appreciated feature

2017-07-02 Thread Alan Chan via 4D_Tech
Hi Peter, I never used component and have no idea what complication would it be in transaction. Nonetheless, we do a lot of updates from time to time. We only use normal transaction and trigger even for millions of records. We normally split into 5,000 to 10,000 records per transaction. I

Re: Nested transactions - most appreciated feature

2017-07-02 Thread Alan Chan via 4D_Tech
If I understand nested transaction correctly, it's like creating an invoice master in a transaction (remain opened), then add invoice line item in nested transaction (start and end nested transaction in one go), add nth line of invoice items in new nested transaction continously. Failure of one

Re: Nested transactions - most appreciated feature

2017-07-01 Thread Alan Chan via 4D_Tech
It's a great feature if long transaction that holding up records isn't an issue to your operation. Of course, make sure no one would take coffee in the middle of a transaction:-) We could only afford single transaction started and ended within a short wrapper method. Alan Chan 4D iNug

Re: v13 (+?) - Replace String [warning]

2017-06-27 Thread Alan Chan via 4D_Tech
Hi Chip, Try the following and it should be done in a second or 2 (compiled). //ES_ReplaceStr_Shrink($source;$oldString;$newString;{$count pointer})->Resulted text C_TEXT($0;$1;$2;$3;$source;$oldStr;$newStr;$result;$tempTxt) C_POINTER($4)

Re: USE DATABASE from 4D client

2017-05-31 Thread Alan Chan via 4D_Tech
I might be missing something obvious. Why not simply using SQL login to access external database and the data could be accessed by multiple 4D clients. SQL LOGIN($externaAddress;$user;$pswd;*) If (OK=1) Begin SQL //do whatever SQL query End SQL SQL LOGOUT End if Alan Chan 4D iNug Technical

Re: Compatibility Mode v12 (How to change to Unicode?)

2017-05-23 Thread Alan Chan via 4D_Tech
on for "multilang.txt" > >> 2017/05/23 19:42、Alan Chan via 4D_Tech <4d_tech@lists.4d.com> のメール: >> >> However, data in other non-roman character sets couldn't be viewed correctly >> and >> requires manual update (re-enter the field). > *

Re: Compatibility Mode v12 (How to change to Unicode?)

2017-05-23 Thread Alan Chan via 4D_Tech
During conversion of our customers' data from 2003 to v11 in unicode mode, we did some trick to allow 4D convert data to unicode correctly. It only helps if your data contains only one type of non-roman character. For instance, most of our users use Traditional Chinese (big5) in 2003. Before

Re: Corrupted index that won't fix

2017-05-21 Thread Alan Chan via 4D_Tech
If you have removed a table or field, then add new table or field, it might cause problem if the old data is still there. Repair it might help. It won't harm if it doesn't. Alan Chan 4D iNug Technical <4d_tech@lists.4d.com> writes: >I verified a data file and MSC reported the data were fine

Re: v13 - Send record

2017-05-17 Thread Alan Chan via 4D_Tech
Did you check OK variable after SET CHANNEL? By the way, I prefer using Goto Selected Record instead of Next Record. Alan Chan 4D iNug Technical <4d_tech@lists.4d.com> writes: >SET CHANNEL(10;$File_Path) > >For ($i;1;Records in selection([Bug_Reporting])) >SEND RECORD([Bug_Reporting]) >NEXT

Re: Disable close button on Splash screen windows v12

2017-05-17 Thread Alan Chan via 4D_Tech
From my code in v13 Called on Startup method DisableWinAppCloseBox (0) //disable mdi window close box DisableWinAppCloseBox (1) //disable flash screen close box The following is trim down version for clarity If (<>Platform=3) //if it is window If ($1=0) $winRef:=gui_GetWindow ("") //this is

Re: How to detect EOL character in text file

2017-05-15 Thread Alan Chan via 4D_Tech
Replace String($text;lf;cr) -> all lf becomes cr including crlf becoming crcr Replace string($text;crlf;cr) -> none would be found That's why you need to run Replace String($text;crlf;cr) first. Alan Chan 4D iNug Technical <4d_tech@lists.4d.com> writes: >That should have read replace string of

Re: Schemes for record level access control

2017-05-15 Thread Alan Chan via 4D_Tech
Like I said, many developers don't like 4D access system, in fact, any 4D inbuilt-tools such as QR editor, Query Editor, Label Editor, Sequence Number, Triggers etc. I'm weird and kept using them intensively even after developing on 4D for 27 years. I'm happily remained to be amature:-)

Re: Schemes for record level access control

2017-05-12 Thread Alan Chan via 4D_Tech
Technical <4d_tech@lists.4d.com> writes: >Right - so the ultimate permission is the most permissive of all available. > >On Fri, May 12, 2017 at 4:56 PM, Alan Chan via 4D_Tech <4d_tech@lists.4d.com >> wrote: > >> I assume a member might belongs to multiple teams but

Re: Schemes for record level access control

2017-05-12 Thread Alan Chan via 4D_Tech
If implemented correctly, performance hit could be minimum. Do what query if(records in selection([WhateverTable]>0) if(<>TeamAccessRequired)\\some customers do not need this feature Query selection with array([WhateverTable]Team;<>CurTeam) end if end if <>CurTeam is loaded from team member

Re: Schemes for record level access control

2017-05-12 Thread Alan Chan via 4D_Tech
I assume a member might belongs to multiple teams but will a member belongs to multiple clubs? Alan Chan 4D iNug Technical <4d_tech@lists.4d.com> writes: >Hi Alan, >Those are the go-to solutions. In my case we aren't using the 4D password >system so I can't rely on that. Plus I need actual

Re: Number display format - trailing spaces

2017-05-11 Thread Alan Chan via 4D_Tech
How about String(number;"|yourPreferredFormat") and set it right justified? Alan Chan 4D iNug Technical <4d_tech@lists.4d.com> writes: >Resurrecting a question for which I haven't seen an answer: > >If I choose the built-in format "###,##0.00 ;###,##0.00CR" >Forms, list boxes and quick reports

Re: Counting # of specific characters in string/text

2017-05-08 Thread Alan Chan via 4D_Tech
Hi Chip, Thanks for your advice. The discussion is about how optimized Replace String is in v16 especially on * operation even comparing with position(*) which supposed to be very fast. It's not about how to design a 4D app with those commands. Alan Chan 4D iNug Technical

Re: Counting # of specific characters in string/text

2017-05-06 Thread Alan Chan via 4D_Tech
Hi Chip We have been talking about * all along. Without * has never been in my test. My test always consider total length of text "and" total count of occurrence. My test is for 4,300,000 length text and 100,000 occurrence. It took 14ms on my machine. Alan Chan 4D iNug Technical

Re: Counting # of specific characters in string/text

2017-05-06 Thread Alan Chan via 4D_Tech
Oops... my bad. Reading too fast. Please ignore this. Alan Chan 4D iNug Technical <4d_tech@lists.4d.com> writes: >I found out why your result is quite different from mine. In your code, you >evaluate the time once per execution of position. However, the replace string >was evaluated once per

Re: Counting # of specific characters in string/text

2017-05-06 Thread Alan Chan via 4D_Tech
Hi Arnaud, I found out why your result is quite different from mine. In your code, you evaluate the time once per execution of position. However, the replace string was evaluated once per 10,000 replacement (per execution of replace string). Alan Chan 4D iNug Technical <4d_tech@lists.4d.com>

Re: v13: what causes boolean fields to display radios instead of check boxes

2017-04-20 Thread Alan Chan via 4D_Tech
This was a known problem only happened on Mac. The issue seems fixed in 13.6. Alan Chan 4D iNug Technical <4d_tech@lists.4d.com> writes: >Hi Walt, > >No, not grouped. > >I worked around it by using OBJECT SET FORMAT in the on load event. Which >works but begs the question of why I have to. > > >

Re: y2038 -- is 4D ready?

2017-03-29 Thread Alan Chan via 4D_Tech
I agree. Longint for sequence number would definitely outlast me:-( Alan Chan 4D iNug Technical <4d_tech@lists.4d.com> writes: >last I knew (this could easily have changed) >Sequence number range is +/- MAX LONGINT (so ~2.1 x 10^9) > > >On Wed, 29 Mar 2017 18:38:56 +0800,

Re: y2038 -- is 4D ready?

2017-03-29 Thread Alan Chan via 4D_Tech
4D would support 64bit integer by then. If not, sequence number (or auto-increment) would be the first one to get in trouble. Alan Chan 4D iNug Technical <4d_tech@lists.4d.com> writes: >so code to convert date to epoch time like that one just recently discussed >(Re: [4DTidbits Blog] Epoch &

Re: 4D v15.4: Sequence number issue / Duplicate key error

2017-03-08 Thread Alan Chan via 4D_Tech
We have been using Sequence Number for years without any problem. It depends how/when you use it My suggestion is to make use of newer features such as Auto-increment on either UUID or Longint. If you don't want to use auto-increment for whatever reasons, you could call it at Trigger for new

Re: Sierra 10.12.3

2017-02-17 Thread Alan Chan via 4D_Tech
Hi David, It WORKS like a charm! THANKS for sharing the tips. Alan Chan 4D iNug Technical <4d_tech@lists.4d.com> writes: >We ran into the v13 / MacBook Pro with touchbar crashing issue in Sierra >10.12.1 and 10.12.2. The fix was maddeningly simple - instead of attempting >to connect to a