Re: 4D and Mongo

2019-03-07 Thread Pat Bensky via 4D_Tech
Thanks Chuck and Tom! On Thu, 7 Mar 2019 at 20:34, Tom DeMeo via 4D_Tech <4d_tech@lists.4d.com> wrote: > Hi, > > > I’ve worked on a web site that does quite a bit of this. A MongoDB is > typically part of an Apache/PHP based web site configuration which would > already have a PHP Mongo module in

Re: code crashes server

2019-03-07 Thread Tom Benedict via 4D_Tech
Hi Chuck, I’m wondering whether the crash is related to HAVING. Have you tried it without HAVING to do the subquery? Would it work to simply change HAVING to AND? I guess I could set up a test system to try it out, but I’m lazy. The 4D docs claim that HAVING should work without a GROUP BY.\,

code crashes server

2019-03-07 Thread Charles Miller via 4D_Tech
Hi All the first begin sql end sql works 100% of the time -- ARRAY TEXT($InspectionIDs_atxt;0) Begin SQL select [LSS_Inventory].[LSS_InventoryId_s] from [LSS_Inventory], [LSS_Inspection] where [LSS_Inspection].[LSS_CondFoundationCurr_s] = '2' and [LSS_Inspection].[LSS_InventoryId_s] =

Re: 4D and Mongo

2019-03-07 Thread Tom DeMeo via 4D_Tech
Hi, I’ve worked on a web site that does quite a bit of this. A MongoDB is typically part of an Apache/PHP based web site configuration which would already have a PHP Mongo module in place (its just a database of JSON objects). If that is the case, a 4D DB can make HTTP Client requests, and

Re: sql assistance

2019-03-07 Thread Charles Miller via 4D_Tech
OK here is another related question has anyone used the CASE inside 4D SQL in the context of my previous post Regards Chuck On Thu, Mar 7, 2019 at 12:49 PM Charles Miller wrote: > > Hi All > > Given the following > Table_1 > Table_1Key > > Table_2 > Table_2Key > Table_1Key > Table_2Date > >

Re: 4D and Mongo

2019-03-07 Thread Charles Miller via 4D_Tech
according to their web site there is a ODBC driver. Go take a look and see if it meets your needs Regards Chuck On Thu, Mar 7, 2019 at 2:02 PM Pat Bensky via 4D_Tech <4d_tech@lists.4d.com> wrote: > > Had a request from a client wanting to know if our 4D app can integrate > with their Mongo data.

4D and Mongo

2019-03-07 Thread Pat Bensky via 4D_Tech
Had a request from a client wanting to know if our 4D app can integrate with their Mongo data. Can it? -- * CatBase - Top Dog in Data Publishing tel: +44 (0) 207 118 7889 w: http://www.catbase.com skype: pat.bensky

sql assistance

2019-03-07 Thread Charles Miller via 4D_Tech
Hi All Given the following Table_1 Table_1Key Table_2 Table_2Key Table_1Key Table_2Date Table_3 Table_3Key Table_2Key Table3_Criteria I am trying to figure out how to write a sql statment that would get the table_1Keys where Table3_Criteria exists for max(Table_2Date) I am pretty sure this

Re: Printing forms modified with Duplicate Object

2019-03-07 Thread Arnaud de Montard via 4D_Tech
> Le 7 mars 2019 à 15:48, Keisuke Miyako via 4D_Tech <4d_tech@lists.4d.com> a > écrit : > > [...] > it was useful, because the old label editor could only position objects in > mac points (1/72 of an inch) > > but I see that the doc says C_LONGINT. > >

Re: Printing forms modified with Duplicate Object

2019-03-07 Thread Keisuke Miyako via 4D_Tech
that has been my experience, in particular when I wrote my own label editor. https://github.com/miyako/4d-component-label-editor it was useful, because the old label editor could only position objects in mac points (1/72 of an inch) but I see that the doc says C_LONGINT.

Re: Printing forms modified with Duplicate Object

2019-03-07 Thread Jeremy French via 4D_Tech
Can we use real values for positioning and width/height with the "Print object" command? > On Mar 6, 2019, at 7:41 PM, Keisuke Miyako via 4D_Tech <4d_tech@lists.4d.com> > wrote: > > have you looked into the "Print object" command? > > you can print … at any position (decimal, not integer