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
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.\, so
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] = [LSS_Inven
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 the
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
>
> Tab
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.
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
*
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 can
> 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.
>
> https://doc.4d.com/4Dv17/4D/17.1/Print-o
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.
https://doc.4d.com/4Dv
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 posi
11 matches
Mail list logo