Calling java

Hi all, We need to call some java classes from within 4D. These classes deliver an interface to interact with a smart card connected to the local PC Does anybody have an opinion how to handle this? I don't see any other way than to use these java classes, and one way or the other call this java

Re: SQL query for the current date

Thanks for the idea... very clever. Unfortunately 4D still won't do an indexed query in this case like it does when passed a literal. > On Dec 3, 2018, at 7:49 PM, Keisuke Miyako via 4D_Tech <4d_tech@lists.4d.com> > wrote: > > SQL functions such as CURRENT_DATE() seems to return a TIMESTAMP,

Re: SQL query for the current date

I would hazard a guess that the CURRENT_DATE() function is called for every record (row) in the table. to verify: create a project method "CD" published for SQL: $0:=Current date place a break point. --- then do ARRAY DATE($ad;0) Begin SQL SELECT Field_2 from Table_1 WHERE {FN CD() AS

Re: 4D Mojave full disk access

Thanks for chiming in Keisuke. Looks like this particular security protection included in Mojave should not be anything to worry about for general file access from 4D. Amin’s code is certainly good to keep around. Thanks again Amin! John > On Dec 3, 2018, at 2:22 PM, Keisuke Miyako via

Re: 4D Mojave full disk access

full disk access on Mojave protect system directories that store private and sensitive information, such as browser history, call history, geolocation, messages and contacts. https://developer.apple.com/videos/play/wwdc2018/702 see slide #22 for full list 2018/12/04 5:49、JOHN BAUGHMAN via

Re: Mojave

Hello, there are 4 Mojave related issues listed on the 17.0HF 4 fix list. https://bugs.4d.fr/fixedbugslist?version=17.0_HF4 ACI0098799On macOS 10.14.x (Mojave), unexpected white vertical line is displayed in the Administration window. ACI0098805Unexpected error "Could not open the specified

Re: Publishing a DB on the WWW. Howto.

Nolen, As Chuck Miller said, you can check out 4D Lightning to avoid all that nasty HTML stuff! ;-0 Here is a link to a demo database using 4D Lightning. http://www.grahamlangley.co.uk/ Graham Langley is the author of 4D Lightning & is very responsive to

Re: Mojave

Hi Jim, Do you have more specific information about this issue? Thanks. -- Cannon.Smith Synergy Farm Solutions Inc. Hill Spring, AB Canada 403-626-3236 > On Dec 3, 2018, at 2:54 PM, Jim Hays via 4D_Tech <4d_tech@lists.4d.com> wrote: > > We had a problem with SVG graphics in v17.0 on Mojave

Error in backup index definitions

I'm trying to compact my structure file, but it seems to be failing due to this error in the "Compacting Backup Index Definitions" step: Problem on index definition [index #1339] : Field reference is invalid I queried the _User_Indexes system table, but there is no index #1339 (it skips over

Re: Mojave

We had a problem with SVG graphics in v17.0 on Mojave - fixed with v17 HF3. On Fri, Nov 30, 2018 at 4:47 PM Cannon Smith via 4D_Tech < 4d_tech@lists.4d.com> wrote: > Thanks John and Kirk. I appreciate the feedback. If anyone else has more > information, feel free to chime in. > > Thanks. > > --

Re: 4D Mojave full disk access

Armin, Not sure what a DMS folder is, but does one still have access to and remain able to create and move files within the database folder? What about 4D Backup to an external disk? Perhaps your code should be implemented just as a normal practice regardless. John John

Re: 4D Mojave full disk access

4D Tech mailing list wrote > Armin, > Thanks! > > Could you expand on what you mean by “full disk access”? In Mojave what > becomes inaccessible? > John John, as an example. My App scans the emails from Apple Mail and shows them inside a Listbox to work with them (grab attachments,

Re: 4D Mojave full disk access

Armin, Thanks! Could you expand on what you mean by “full disk access”? In Mojave what becomes inaccessible? John > On Dec 3, 2018, at 3:38 AM, ADeeg via 4D_Tech <4d_tech@lists.4d.com> wrote: > > Hi, > > if your app needs full disk access an macOS 10.14.x Mojave and

Re: Publishing a DB on the WWW. Howto.

Nolan, As others have pointed out, you have lots of ways to go. I use Xojo (xojo.com ) to create web apps to talk to 4D using much of what you will find in David Adam’s book “4D Web Companion”. I did a demo of what I am doing at a 4DMethod meeting recently which you

Re: Publishing a DB on the WWW. Howto.

Nolen - There are many, many more options today than there used to be (browse the iNug archives for some lively discussions), but David Adams book is a comprehensive primer that many developers have used over the years, especially to get started. It is now available for download, free, as

Re: Publishing a DB on the WWW. Howto.

Look at lightning 4 for 4D you can find it http://www.foundationshell.com/store/ Regards Chuck Chuck Miller Voice: (617) 739-0306 Informed Solutions, Inc. Fax: (617) 232-1064

4D Mojave full disk access

Hi, if your app needs full disk access an macOS 10.14.x Mojave and newer, then the users have to grant the access for your 4D application. I use this to check the access privileges: C_TEXT($in;$out;$err;$path) If ((<>SystemVersion="Mac 10.14") | (<>SystemVersion="Mac 10.15") |

Re: Compact data file

Hi Keith, Considering this issue. Last week I had to repair a v16 datafile. In the MSC, right after the repair I ran a verification. The verification was done on the old datafile. The repaired datafile was still in the subfolder '...repairing...' instead of on the original location as I would