Re: Client communication

2024-03-05 Thread David Samson via 4D_Tech
looks like VARIABLE TO VARIABLE would help. David Samson Message: 1 > Date: Mon, 4 Mar 2024 16:01:40 +0100 > From: "stardata.info" > To: 4d_tech@lists.4d.com, 4d_tech-requ...@lists.4d.com > Subject: Client communication > Message-ID: <51ecb4f8-c681-402e-8a9

Re: Field calculations

2023-09-12 Thread David Samson via 4D_Tech
+ [Table]Field2 $nDenom:= $nDenom +1 End If etc. If ( $nDenom > 0) v_total:= $nTotal/ $nDenom Else v_total:=0 End If David Samson Manchester U.K. From: Stephane Potvin > To: 4d_tech@lists.4d.com > Subject: Field calculations > Message-ID: <3b074a65-f592-415b-97ab-fad010c

Re: Slow speed on 4D Client (stardata.info)

2023-02-01 Thread David Samson via 4D_Tech
If it is just two of the clients then it could be a faulty switch on the network. David Hi All, > > I have a question: > I use 4D V16 Client server on windows. > I notice that on two of my four 4D Clients, after some work on the > network ( i think on routers and firewall) , the query are very

Re: How to convert date to integer or vice versa

2022-08-09 Thread David Samson via 4D_Tech
I think this is what you are looking for: https://kb.4d.com/assetid=28510 David > 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

Re: How to Sort with Quick Report V17.5

2022-07-27 Thread David Samson via 4D_Tech
The QR editor changed in the 64 bit version. There is a little drop-down arrow in the column header which has an option "Sort order". Hope this helps David Samson Hello everyone, > Can someone please tell me how to add a sort to Quick Reports v17.5? > I have an old report that

re: Choice list in a list box

2022-07-15 Thread David Samson via 4D_Tech
You make the list in Toolbox -> Lists. There might be a more modern way but this is how it used to work. What version are you on? David I use a list box in one 4d form. > > In one row of a listbox, i have an association with one choice list, to > manage the values that can insert. > > Where i

Re: Signing Fail in creating app in 4D 19

2022-04-06 Thread David Samson via 4D_Tech
There is a lot of discussion about these sort of issues on the new forum: https://discuss.4d.com/ > > 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

Re: maximun number of clients reached

2022-03-22 Thread David Samson via 4D_Tech
If a client does not log off properly it can hold the licence. If you restart the 4D server application are all 4 users able to log in? You can also abort users from the 4D server administration window. David Samson Manchester UK > I use 4D V16 on windows. > > In the 4D server appli

Re: DISPLAY NOTIFICATION

2022-01-18 Thread David Samson via 4D_Tech
I have not seen the command fail. Are you sure that the method calling it is working correctly? David Samson Hi All, > > I use DISPLAY NOTIFICATION command with 4D V16 on windows, and after > some month that its work fine, some days he does not > > work, and in windows, i

Re: 4D scanning

2021-06-21 Thread David Samson via 4D_Tech
Hello, I don't know about Macs but on a PC you don't need a plugin for simple scanning. I use I use a free program called NAPS2 which has proven to be very reliable over the years. I scan the document into a known folder and retrieve it from there and can then do what I want with it. The code

Re: Array combination

2021-05-28 Thread David Samson via 4D_Tech
ay2)) $cCombination:=Array1{1}+Array2{$i}+Array1{2}+Array2{$j} APPEND TO ARRAY(ArraysCombined;$cCombination) End for End for Hope this helps David Samson > In one 4D application i need to combine two array. > > For example i have an array with sone analyte

Re: Ring Central Integration

2021-02-22 Thread David Samson via 4D_Tech
Hello Kenneth, We did this some years ago with another VOIP phone system and it worked ok. It is not trivial but it can be done. Here are the basic steps: 1) register the 4D clients and store their phone extensions in 4D.(so you can direct the call to the correct client) 2) Detect the call from

Re: Need Help! - Customer upgraded from Win 7 to Win 10 Pro.

2021-01-20 Thread David Samson via 4D_Tech
As an interim solution you might be able to run a virtual PC with Win 7. -- D Samson ** 4D Internet Users Group (4D iNUG) New Forum: https://discuss.4D.com Archive: http://lists.4d.com/archives.html Options:

Re: Designer Password Question

2021-01-19 Thread David Samson via 4D_Tech
Hello Ken, I suggest you contact 4D tech support. As mentioned you need to prove ownership or authorisation from the owner. This route has worked for me in the past. HTH David Samson Manchester U.K. P.S. The recent banter about age on this list reminded me of a cute saying: "Age is a que

Re: Bugs with Quick Report Editor v18.4

2020-11-05 Thread David Samson via 4D_Tech
Hello Pete, I presume you are on Windows 10. Microsoft in their wisdom have removed the XPS reader and writer from Windows 10. XPS is what 4D uses for print preview. You just need to install both of these for print preview to work. HTH David Samson Manchester UK > On Windows 10 Platform,

Re: 4D ODBC, MS SQL and Alpha Fields

2019-10-04 Thread David Samson via 4D_Tech
Hello Paul, For years we have been doing it the other way round with very few problems. We write to SQL from 4D using ODBC. Then you have full control of what you send both on the record and field level. You are welcome to contact me off list if you want some sample code. HTH David Samson

Re: spelling check in 4D v15.6 4DView W7

2019-07-11 Thread David Samson via 4D_Tech
There was a bug with spellchecker in v15 which might be related to your problem: https://kb.4d.com/resources/inug?msgid=GmailId156c96e169a13159 Have you tried a newer version of 4D? HTH David Samson Manchester UK > 4D v15.6 pc W7. > Created a database solution for a customer and on an

Re: Conversion from v2003

2019-06-12 Thread David Samson via 4D_Tech
as well - another possibility. Maybe we could be of more help we knew what the DDE calls were trying to achieve. David Samson Manchester U.K. I am not too familiar with DDE_Tools. I am wondering if someone can point > me in a direction to help me have more information on that plugins and

Re: XLS plugins by Miyako

2019-04-03 Thread David Samson via 4D_Tech
I am also using the first one ( XLS : https://github.com/miyako/4d-plugin-xls ) and have been for years. I was quite surprised to learn about releasing objects. When does one have to do that? The release commands do not appear in my command list in 4D. TIA David Samson Manchester U.K. > I

v17 web area

2019-03-05 Thread David Samson via 4D_Tech
displayed but on a blank background. I have checked the Leaflet map is in the correct resources folder. I tried to download the tech note again and the demo has the same problem when converted to v17. Any ideas? David Samson -- D Samson ***

Re: Controlling Laptop Camera from 4D

2018-11-13 Thread David Samson via 4D_Tech
Hello Randy, There is an old tech note about this: http://kb.4d.com/assetid=77204 It was also demonstrated at the 4D roadshow a few years ago - so it is not just theory, we saw it working. HTH David Samson Manchester UK > > I'm trying to run the camera on my laptop (Dell 7720) - yes

Sorting an array of email addresses

2018-11-06 Thread David Samson via 4D_Tech
Would this be reliable since they all contain the "@" sign? You might have " i...@abc.com" and "i...@def.com". (Windows v17 if it matters) D Samson Manchester UK ** 4D Internet Users Group (4D iNUG) Archive:

Re: Current time (*) incorrect today on v17?

2018-11-06 Thread David Samson via 4D_Tech
> > > This is not only on Mac. We had the same problem on Windows. 64 bit server and 32 bit clients. -- D Samson ** 4D Internet Users Group (4D iNUG) Archive: http://lists.4d.com/archives.html Options:

Blank server administration window v17

2018-10-10 Thread David Samson via 4D_Tech
already had one IT department genius shut down the 4D server because he thought it was not running. 50 users were thrown out of 4D. Anyone else seen this? Any ideas? David Samson Manchester UK ** 4D Internet Users Group (4D iNUG

Error on HTTP request on v16B6

2018-06-21 Thread David Samson via 4D_Tech
k -7, name: 'Process_ContractList' Any suggestions? David Samson Manchester UK ** 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/optio

Re: v16 Time picker - bound variable changed

2018-06-13 Thread David Samson via 4D_Tech
Thank you Miyako. That was it. David Samson > it is a bug that was fixed in 16.3 Hotfix 1 (latest is Hotfix 4) > > ACI0097700 > > 2018/06/12 0:40、David Samson via 4D_Tech <4d_tech@lists.4d.com 4d_tech@lists.4d.com>> のメール: > Should I be defaulting the time on the on-l

Re: Icons On Tab Control

2018-06-04 Thread David Samson via 4D_Tech
I really wish the tab object > had more configuration options (especially on Windows). It just seems to > be a forgotten object. > > > Steve > > -Original Message- > From: 4D_Tech [mailto:4d_tech-boun...@lists.4d.com] On Behalf Of David > Samson via 4D_

Re: Icons On Tab Control

2018-06-04 Thread David Samson via 4D_Tech
in v14 Windows but without success. David Samson Manchester U.K. > May be a dumb question, but I noticed in the Tab Control documentation > (V16.3) it says icons can be displayed on each tab, however I don't see any > documentation on how that is accomplished. &g

Print preview on RDP

2018-01-19 Thread David Samson via 4D_Tech
Has anybody experienced print preview not working over RDP? Printing (e.g. to PDF) works fine. This is on Windows and 4D v14.3. -- D Samson Manchester England ** 4D Internet Users Group (4D iNUG) FAQ:

Re: What Texting Services Are People Using?

2017-12-11 Thread David Samson via 4D_Tech
Have you looked at Contrôle SMS from Bertrand SOUBEYRAND? It is a component. We have been using it for years and it is excellent. https://www.controle-sms.com/en/ David Samson > > Message: 8 > Date: Wed, 6 Dec 2017 12:22:30 -0700 > From: Dave Nasralla <dnasra...@gmail.com

What does INF mean?

2017-12-11 Thread David Samson via 4D_Tech
I correct in my supposition and is this documented anywhere? Thank you, David Samson Manchester UK ** 4D Internet Users Group (4D iNUG) FAQ: http://lists.4d.com/faqnug.html Archive: http://lists.4d.com/archives.html Options: http://list

Re: USE DATABASE from 4D client

2017-05-30 Thread David Samson via 4D_Tech
Keisuke Miyako wrote: >rather activating the "execute on server" method property, >I would recommend using the REMOTE keyword: Does that allow multiple users to access it simultanously? Thanks for the reply, David ** 4D

Re: USE DATABASE from 4D client

2017-05-30 Thread David Samson via 4D_Tech
David Adams wrote: >On another note, is there some reason that you can't or don't want to >download the file to the clients? It is a 28 million record postal address file so segmenting won't work. I have thought of copying it over to the clients but then the issue of keeping it updated raises

USE DATABASE from 4D client

2017-05-30 Thread David Samson via 4D_Tech
as anybody tried this arrangement in a busy database (40-50 users and additional web cleints)? David Samson Manchester UK ** 4D Internet Users Group (4D iNUG) FAQ: http://lists.4d.com/faqnug.html Archive: http://lists.4d.com/arc

Re: Preemptive mode flaw

2017-05-11 Thread David Samson via 4D_Tech
I can second this. The TAOW system is well monitored and responsive. > I have to say that the Taow system works really well, in my experience. -- D Samson ** 4D Internet Users Group (4D iNUG) FAQ:

Re: Can 4D connect to Firebird?

2017-03-07 Thread David Samson via 4D_Tech
. > Before I commit to a project I though I will find out if 4D can connect to > Firebird SQL.. > > David Samson Manchester UK ** 4D Internet Users Group (4D iNUG) FAQ: http://lists.4d.com/faqnug.html Archive: http://

SagePay Direct from 4D

2017-02-03 Thread David Samson
mpatible" error which I suspect just means it was unable to connect since I have double-checked all the parameters. I have checked that our firewall is not blocking it. Any ideas? David Samson Manchester UK ** 4D Internet Users

Re: SVG - how to encode angle brackets as text?

2017-01-25 Thread David Samson
Hello Kirk, SVG is all XML behind the scenes so you need to replace the angle brackets with and respectively. HTH David Samson Manchester UK > I'm playing with some SVG and using the *SVGTool_SHOW_IN_VIEWER.* I notice > that when I attempt to set angle brackets in some text I get an

Re: intermittent 10042 SMTP 550 mail box unavailable

2016-11-07 Thread David Samson
We had a similar problem when the mail server was moved to the cloud. The solution was to increase the timeout (I think one minute was enough.) HTH David Samson Manchester UK > > > A customer sending emails from a variety of computers within their LAN > intermittently gets 10042 S

Re: Sharepoint vs 4D

2016-10-14 Thread David Samson
Hello Robert, I found this which appears to be fair comparison. https://msdn.microsoft.com/en-us/library/ff647105.aspx David > I have client that wants to rewrite an old 4D database from scratch. At > least one member on the board is pushing for us to consider Sharepoint or > another non-4D

HMACSHA1 signed signature

2016-09-15 Thread David Samson
calculated with HMAC-SHA1 and then converted to base64 PeKNVo1BAiuZyHxIdMisidG92bg= 5. The signature is now ready to be added to the Http authentication header for the request. TIA David Samson -- D Samson