Re: v17.4 source Stand-alone and Remote: picture drop onto a picture field in an input form

2019-06-13 Thread Keisuke Miyako via 4D_Tech
I am unaware of any changes starting with v17 (I presume R4) but in general, the way to process drag and drop over a picture is: On After Edit: accept native drop or paste. On Drop: accept custom drag and drop. $0 must be assigned 0 in On Drag Over. On Drag Over: check if Pasteboard data size is

Re: Emojis in text

2019-06-13 Thread macjimbo via 4D_Tech
Thank you all very much indeed. I can confirm that the "[[:^ascii:]]" worked perfectly for me (I didn't try the one with the single brackets) and the simple use of match regex also worked like a charm. Thanks again for helping me fix this annoying issue. James -- Sent from:

v17.4 source Stand-alone and Remote: picture drop onto a picture field in an input form

2019-06-13 Thread David Ringsmuth via 4D_Tech
I know some things have changed with v17.4 drag and drop. When I enable a form picture object to accept drop, and I trace the “on drop” database method, nothing happens in the form, object method or on-drop database method. Suggestions please! David Ringsmuth

Re: How to call Oracle stored procedure

2019-06-13 Thread Chuck Miller via 4D_Tech
Oracle used to give different results from transact and from a program. I will look tomorrow at code I am using and see if I am calling stored proc. I am inserting only. Regards Chuck Sent from my iPhone > On Jun 13, 2019, at 4:34 PM, Olson, Brad via 4D_Tech <4d_tech@lists.4d.com> > wrote:

How to call Oracle stored procedure

2019-06-13 Thread Olson, Brad via 4D_Tech
Hello, I am needing some assistance in executing an Oracle stored procedure from a 4D v17R4 application. It has only one input parameter as varchar, and the output results come in the form of a cursor, consisting of a table with three columns and n rows. This is the stored procedure that the

RE: 400 Bad Request

2019-06-13 Thread Randy Engle via 4D_Tech
Hi Jacques, (re your post from 2017) We are having this same problem on our web pages. If is particularly bad on iPhones and iPads. Intermittent on Windows Chrome Did you find any way to resolve it? Much appreciated Randy Engle XC2 Software - XC2LIVE! -Original Message- From:

4D v17 Mac Crashing on First Launch

2019-06-13 Thread Narinder Chandi via 4D_Tech
So, I was trying to install 4D v17.1 on a 2016 MacBook Pro running OS X 10.13.6 (High Sierra). The installer was a direct download from 4D.com. Any attempt to launch 4D resulted in a hard crash - the output from the Crash Report for 17.2 is below. I tried re-installing, re-booting, starting

Re: Import mysql dump into 4D v15, build database structure & import data

2019-06-13 Thread Narinder Chandi via 4D_Tech
Could you import the SQL script file using the SQL EXECUTE SCRIPT command? Regards, Narinder Chandi, ToolBox Systems Ltd. -- -Original Message- From: 4D_Tech <4d_tech-boun...@lists.4d.com> on behalf of 4D Tech Mailing List <4d_tech@lists.4d.com> Reply-To: 4D Tech Mailing List

Import mysql dump into 4D v15, build database structure & import data

2019-06-13 Thread jarosz via 4D_Tech
In 4D v15 there is an SQL EXPORT DATABASE command which exports the database as an SQL dump file. Is there an equivalent function to import an SQL dump file, create the database structure in 4D, and import the data into it? ie the equivalent of the import function in phpmyadmin? Or does anybody

Re: Emojis in text

2019-06-13 Thread Narinder Chandi via 4D_Tech
Thanks Keisuke, that looks like an acceptable solution for James I hope. The only comment I have is whether: $regex:="[:^ascii:]" should actually be: $regex:="[[:^ascii:]]" Since although 4D is accepting the first version, when I tested this with https://regex101.com it complained that "A