Re: v17.4 source Stand-alone and Remote: picture drop onto a picture field in an input form
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 not negative On Begin Drag Over: append custom data to pasteboard (start custom drag and drop) --- I recall there were some special refactoring in 17 R4 to support the 10.12 to 10.14 range on Mac. but the implementation should be transparent to the 4D language. > 2019/06/14 6:06、David Ringsmuth via 4D_Tech <4d_tech@lists.4d.com>のメール: > > 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. ** 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: Emojis in text
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: http://4d.1045681.n5.nabble.com/4D-Tech-f1376241.html ** 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 **
v17.4 source Stand-alone and Remote: picture drop onto a picture field in an input form
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 ** 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: How to call Oracle stored procedure
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: > > 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 oracle developer created and sent me - > ADC.PKG_EXTACCESSSQL.SELECTJOBINFORMATIONBYSERIAL(serialNumber IN varchar2, > dataOutput OUT cursorType). > > I can run this, using Oracle SQL Developer, and get the expected results, but > running it in 4D generates various errors depending on how I format the > method. > > I have tried the following approaches, based on the examples in the Language > reference, but both generate ODBC errors. > Method 1 > C_TEXT($sql) > C_TEXT(serialNumber;dataOutput) > serialNumber:="711030309743" > $sql:="call ADC.PKG_EXTACCESSSQL.SELECTJOBINFORMATIONBYSERIAL(?, ?)" > SQL LOGIN("ODBC:fbcDelicias_test";"REPORT_USR";"RptB0Us#r") > If (OK=1) > >SQL SET PARAMETER(serialNumber;SQL param in) >SQL SET PARAMETER(dataOutput;SQL param out) >SQL EXECUTE($sql;dataOutput) >SQL LOAD RECORD(SQL all records) > //Place the data validation code here >SQL CANCEL LOAD > End if > SQL LOGOUT > > Method 2 > C_TEXT($sql) > C_TEXT(serialNumber;dataOutput) > serialNumber:="711030309743" > $sql:="call > ADC.PKG_EXTACCESSSQL.SELECTJOBINFORMATIONBYSERIAL(<>,<>)" > > SQL LOGIN("ODBC:myUserName";"REPORT_USR";"RptB0Us#r") > If (OK=1) >SQL EXECUTE($sql;dataOutput) >SQL LOAD RECORD(SQL all records) > //Place the data validation code here >SQL CANCEL LOAD > End if > SQL LOGOUT > > Thank you for any suggestions you might have! > > Brad Olson > CommScope, Inc. > > ** > 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 > ** ** 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 **
How to call Oracle stored procedure
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 oracle developer created and sent me - ADC.PKG_EXTACCESSSQL.SELECTJOBINFORMATIONBYSERIAL(serialNumber IN varchar2, dataOutput OUT cursorType). I can run this, using Oracle SQL Developer, and get the expected results, but running it in 4D generates various errors depending on how I format the method. I have tried the following approaches, based on the examples in the Language reference, but both generate ODBC errors. Method 1 C_TEXT($sql) C_TEXT(serialNumber;dataOutput) serialNumber:="711030309743" $sql:="call ADC.PKG_EXTACCESSSQL.SELECTJOBINFORMATIONBYSERIAL(?, ?)" SQL LOGIN("ODBC:fbcDelicias_test";"REPORT_USR";"RptB0Us#r") If (OK=1) SQL SET PARAMETER(serialNumber;SQL param in) SQL SET PARAMETER(dataOutput;SQL param out) SQL EXECUTE($sql;dataOutput) SQL LOAD RECORD(SQL all records) //Place the data validation code here SQL CANCEL LOAD End if SQL LOGOUT Method 2 C_TEXT($sql) C_TEXT(serialNumber;dataOutput) serialNumber:="711030309743" $sql:="call ADC.PKG_EXTACCESSSQL.SELECTJOBINFORMATIONBYSERIAL(<>,<>)" SQL LOGIN("ODBC:myUserName";"REPORT_USR";"RptB0Us#r") If (OK=1) SQL EXECUTE($sql;dataOutput) SQL LOAD RECORD(SQL all records) //Place the data validation code here SQL CANCEL LOAD End if SQL LOGOUT Thank you for any suggestions you might have! Brad Olson CommScope, Inc. ** 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: 400 Bad Request
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_Tech <4d_tech-boun...@lists.4d.com> On Behalf Of Jacques Chatenay via 4D_Tech Sent: Monday, September 18, 2017 6:43 PM To: 4D iNug Technical <4d_tech@lists.4d.com> Cc: Jacques Chatenay Subject: 400 Bad Request I have started receiving 400 bad request errors on a website's served by 4D the errors occur using chrome 60.0.3112.116 on android 8.0.0 using firefox on the same device has no problems using chrome 60.0.3112.116 on android 6.0.1 device dose not have any problem I have had reports of this problem on Apple devices however I do not have an apple device to test on I have no problems on windows computers accessing the sites with any browser. Problem seems to be isolated to chrome 60.0.3112.116 on android 8.0.0 and likely apple devices One site that has the problem has http://mcknight-law.com The database is running on v14 R5 I have tested on 16 R3 with the same results Any help would be greatly appreciated J Chatenay Aware Data Services ** 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 ** ** 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 **
4D v17 Mac Crashing on First Launch
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 the Mac with Shift key down but none of these worked as a solution. I also tried the latest 17.2 released yesterday 13/06 and also 17 R4 but no luck. Eventually, after some Googling I tried this in the terminal : > xattr -d com.apple.quarantine path/to/4D.app and 4D now launches! So, it seems that the Mac's FileVault is unable to verify the app upon first run. Anyway experienced this or know what gives? Thanks. Process: 4D [5053] Path: /private/var/folders/*/4D.app/Contents/MacOS/4D Identifier:com.4d.4d Version: 17.2 build 17.238379 (17.0.2) Code Type: X86-64 (Native) Parent Process:??? [1] Responsible: 4D [5053] User ID: 501 Date/Time: 2019-06-13 15:51:03.010 +0100 OS Version:Mac OS X 10.13.6 (17G7024) Report Version:12 Bridge OS Version: 3.0 (14Y901) Anonymous UUID:4ED4AFD8-EE83-0BE5-B395-516D9FA1CC69 Sleep/Wake UUID: 2C8D228F-7093-44C6-91EE-C685662CEB64 Time Awake Since Boot: 11000 seconds Time Since Wake: 7700 seconds System Integrity Protection: enabled Notes: Translocated Process Crashed Thread:0 (id = 775) Dispatch queue: com.apple.main-thread Exception Type:EXC_BAD_ACCESS (SIGSEGV) Exception Codes: KERN_INVALID_ADDRESS at 0x0018 Exception Note:EXC_CORPSE_NOTIFY Termination Signal:Segmentation fault: 11 Termination Reason:Namespace SIGNAL, Code 0xb Terminating Process: exc handler [0] VM Regions Near 0x18: --> __TEXT 00010b731000-00010c26a000 [ 11.2M] r-x/rwx SM=COW /var/folders/*/4D.app/Contents/MacOS/4D Thread 0 Crashed:: (id = 775) Dispatch queue: com.apple.main-thread 0 com.4d.4d 0x00010b946da1 MacStringToVString(unsigned char const*, int, xbox::VString&, VUniToMacConverter*) + 274 1 com.4d.4d 0x00010bbfa1fe V4DLocalizationManager::_LocalizeStrSharpCode(int, int, xbox::VString&) + 174 2 com.4d.4d 0x00010bdbf6ec V4DCoreApplication::RetainFolder(unsigned int) const + 94 3 com.4d.4d 0x00010bdbde4b V4DCoreApplication::_Init_ResourceChain() + 99 4 com.4d.4d 0x00010bdbd7c9 V4DCoreApplication::Init(unsigned int) + 445 5 com.4d.4d 0x00010ba3fcab V4DApplication::Init(unsigned int) + 95 6 com.4d.4d 0x00010bbdf008 _main() + 40 7 libdyld.dylib 0x7fff59a97015 start + 1 Regards, Narinder Chandi, ToolBox Systems Ltd. -- ** 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: Import mysql dump into 4D v15, build database structure & import data
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 <4d_tech@lists.4d.com> Date: Thursday, 13 June 2019 at 15:34 To: 4D Tech Mailing List <4d_tech@lists.4d.com> Cc: jarosz Subject: Import mysql dump into 4D v15, build database structure & import data 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 have some code to do this which they'd be willing to share? Michael Jarosz -- Sent from: http://4d.1045681.n5.nabble.com/4D-Tech-f1376241.html ** 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 ** ** 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 **
Import mysql dump into 4D v15, build database structure & import data
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 have some code to do this which they'd be willing to share? Michael Jarosz -- Sent from: http://4d.1045681.n5.nabble.com/4D-Tech-f1376241.html ** 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: Emojis in text
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 posix character class may only appear inside a character class" which is explained here, https://www.regular-expressions.info/posixbrackets.html 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 <4d_tech@lists.4d.com> Date: Thursday, 13 June 2019 at 01:41 To: 4D Tech Mailing List <4d_tech@lists.4d.com> Cc: Keisuke Miyako Subject: Re: Emojis in text according to https://unicode.org/reports/tr51/#Property_Stability an Emoji is \p{RI} \p{RI} | \p{Emoji} ( \p{EMod} | \x{FE0F} \x{20E3}? | [\x{E0020}-\x{E007E}]+ \x{E007F} )? (\x{200D} \p{Emoji} ( \p{EMod} | \x{FE0F} \x{20E3}? )?)+ no kidding. but the ICU in 4D does not support the [:Emoji:] or \p{Emoji} property. --- that said, if you just want to filter non-ASCII, for example, it could be as simple as $text:="I an unwell cough cough" $regex:="[:^ascii:]" While (Match regex($regex;$text;1;$pos;$len)) $text:=Delete string($text;$pos;$len) End while ** 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 ** ** 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 **