date:20200301

Re: ORDA - NOT(IN)

2020-03-01 Thread Chip Scheide via 4D_Tech

maybe because the array [] is not empty when there is a an empty string in it.
and the query, in the second case is looking for empty string values, or just 
string values

> 
> NOT(IN []) 
>versus 
> NOT(IN [""]) 

Hell is other people 
 Jean-Paul Sartre
**
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: ORDA - NOT(IN)

2020-03-01 Thread Tom-Lists via 4D_Tech

That's an interesting find, but I don't see that as the case as the value of 
the variable (as seen in the debugger) remains the same with or without the NEW 
COLLECTION parenthesis. 

So my question still stands:

Why is my query of 
NOT(IN []) 
   versus 
NOT(IN [""]) 
 producing difference results?

Tom



> On Mar 1, 2020, at 5:18 PM, Jeremy French  wrote:
> 
> Hi Tom.
> 
> I believe this statement has a silent syntax error, which the compiler/syntax 
> checker fails to flag:
> $vC_uuidsToIgnore:=New collection()
> 
> Remove the parenthesis so you have:
> $vC_uuidsToIgnore:=New collection
> 
> See: https://doc.4d.com/4Dv18/4D/18/New-collection.301-4505843.en.html 
> 
> 
> Best regards,
> Jeremy French
> 
> 
> 
> 
>> On Mar 1, 2020, at 2:05 PM, Tom-Lists via 4D_Tech <4d_tech@lists.4d.com 
>> > wrote:
>> 
>> Now assuming that the field "entityUUID" is populated (no null values), How 
>> come I get different results with:
>> 
>> $vC_uuidsToIgnore:=New collection()
>> $deletes:=ds.SyncDeletes.query("NOT(entityUUID IN :1)";$vC_uuidsToIgnore)
>>  $deletes --> zero length entitySelection (not what I expect!)
>> 
>> versus
>> $vC_uuidsToIgnore:=New collection("")
>> $deletes:=ds.SyncDeletes.query("NOT(entityUUID IN :1)";$vC_uuidsToIgnore)
>>  $deletes --> all SyncDeletes records (good!)
>> 
>> The ONLY difference between the above snippets is that one collection is 
>> empty versus the other has a single empty value.
>> 
>> v18.0 
>> 
>> I can exclude uuids when my vC_uuidsToIgnore contains one or more UUID's, 
>> the problem appears when that collection is empty… I should get ALL 
>> SyncDeletes records.
> 

**
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: Printing List Box v16R5 - never mind

2020-03-01 Thread JOHN BAUGHMAN via 4D_Tech


I forgot that I needed to set the x, y start positions otherwise it prints 
based on the position of the list box on the form, which would push it off the 
page.

John


> On Mar 1, 2020, at 2:37 PM, JOHN BAUGHMAN  wrote:
> 
> 4dI have done this many times before but for this particular listbox I am 
> getting a blank page using…
> 
>   PRINT SETTINGS  
>   If (ok=1)
>   OPEN PRINTING JOB
>   FORM LOAD("DistrictPromotions")
>   $end:=False
>   Repeat 
>   $end:=Print object(*;”Statistics")
>   Until ($end)
> 
>   CLOSE PRINTING JOB
> 
>   End if 
> 
> The List Box is array based.
> 
> What am I missing?
> 
> Thanks,
> 
> John
> 
> 
> John Baughman
> Kailua, Hawaii 
> (808) 262-0328
> john...@hawaii.rr.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
**

Printing List Box v16R5

2020-03-01 Thread JOHN BAUGHMAN via 4D_Tech

4dI have done this many times before but for this particular listbox I am 
getting a blank page using…

PRINT SETTINGS  
If (ok=1)
OPEN PRINTING JOB
FORM LOAD("DistrictPromotions")
$end:=False
Repeat 
$end:=Print object(*;”Statistics")
Until ($end)

CLOSE PRINTING JOB

End if 

The List Box is array based.

What am I missing?

Thanks,

John


John Baughman
Kailua, Hawaii 
(808) 262-0328
john...@hawaii.rr.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
**

Re: ORDA - NOT(IN)

2020-03-01 Thread Jeremy French via 4D_Tech

Hi Tom.

I believe this statement has a silent syntax error, which the compiler/syntax 
checker fails to flag:
$vC_uuidsToIgnore:=New collection()

Remove the parenthesis so you have:
$vC_uuidsToIgnore:=New collection

See: https://doc.4d.com/4Dv18/4D/18/New-collection.301-4505843.en.html 


Best regards,
Jeremy French




> On Mar 1, 2020, at 2:05 PM, Tom-Lists via 4D_Tech <4d_tech@lists.4d.com> 
> wrote:
> 
> Now assuming that the field "entityUUID" is populated (no null values), How 
> come I get different results with:
> 
> $vC_uuidsToIgnore:=New collection()
> $deletes:=ds.SyncDeletes.query("NOT(entityUUID IN :1)";$vC_uuidsToIgnore)
>   $deletes --> zero length entitySelection (not what I expect!)
> 
> versus
> $vC_uuidsToIgnore:=New collection("")
> $deletes:=ds.SyncDeletes.query("NOT(entityUUID IN :1)";$vC_uuidsToIgnore)
>   $deletes --> all SyncDeletes records (good!)
> 
> The ONLY difference between the above snippets is that one collection is 
> empty versus the other has a single empty value.
> 
> v18.0 
> 
> I can exclude uuids when my vC_uuidsToIgnore contains one or more UUID's, the 
> problem appears when that collection is empty… I should get ALL SyncDeletes 
> records.

**
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: Can't use Zint plugin since upgrading my Mac

2020-03-01 Thread Aparajita Fishman via 4D_Tech

> the latest Catalina tends to rejects v17 style plugins (manifest.json in

> Contents),

As long as there are no nested frameworks that are themselves signed, you can 
use codesign --deep and it works with manifest.json in Contents.

- Aparajita
**
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: An API for my 4D app

2020-03-01 Thread Tom-Lists via 4D_Tech

We provide API resources just by using the web extension and returning JSON to 
validated queries. 
For example a customer device might make a request like:

https://online.myDomain.ca/4DACTION/API/API_GetAssets?key=8B99FB68=new=yes
 


would receive something like:

{
 "IosUpdateAvailable": "v0.5b2133",
 "Date": "2/29/20",
 "Time": "13:57:44",
 "Username": "Tom",
 "Query": {
  "key": "8B99FB68",
  "criteria": "new"
  "pretty": "yes"
 },
 "Result": {
  "SetUTC": "2020-02-29T20:57:45.367Z",
  "Status": "Success",
  "Assets": [
   {
"esn": "0814IG3054E",
"lat": 56.14575,
"lon": -117.72689,
"alt": 0,
"speed": 0,
"heading": 0,
"utc": "2020-02-29T01:24:10Z",
"localDT": "2/28/20 18:24:10",
 "UID": "A7250F54E0B34E679AF06E5A64B2101B",
 "modUTC": "2019-09-10T22:00:01.975Z",
 "Ident": "C-FHUY",
 }
 ]
}
   }

Easy and fast!
Cheers,
Tom


Tom Buckler | Buckler Microelectronics Inc.
17008 - 90 Avenue NW | Suite 272 | Edmonton | AB | Canada | T5T 1L6
Cell: (780) 499-5525 




> On Feb 27, 2020, at 4:49 AM, Pat Bensky via 4D_Tech <4d_tech@lists.4d.com 
> > wrote:
> 
> I've been asked a few times by prospective customers if we have an API for
> our 4D app. My answer is that it can be accessed via ODBC. But that isn't
> really what they want.
> 
> I'd like to ask you guys what solutions you have implemented in this regard?
> 
> Pat
> 
> -- 
> *
> CatBase - Top Dog in Data Publishing
> tel: +44 (0) 207 118 7889
> w: http://www.catbase.com 
> skype: pat.bensky
> *
> **
> 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
**

ORDA - NOT(IN)

2020-03-01 Thread Tom-Lists via 4D_Tech

Hi All,
I'm generally in love with ORDA, but:

Now assuming that the field "entityUUID" is populated (no null values), How 
come I get different results with:

$vC_uuidsToIgnore:=New collection()
$deletes:=ds.SyncDeletes.query("NOT(entityUUID IN :1)";$vC_uuidsToIgnore)
$deletes --> zero length entitySelection (not what I expect!)

versus
$vC_uuidsToIgnore:=New collection("")
$deletes:=ds.SyncDeletes.query("NOT(entityUUID IN :1)";$vC_uuidsToIgnore)
$deletes --> all SyncDeletes records (good!)

The ONLY difference between the above snippets is that one collection is empty 
versus the other has a single empty value.

v18.0 

I can exclude uuids when my vC_uuidsToIgnore contains one or more UUID's, the 
problem appears when that collection is empty… I should get ALL SyncDeletes 
records.


Cheers
Tom





Tom Buckler | Buckler Microelectronics Inc.
17008 - 90 Avenue NW | Suite 272 | Edmonton | AB | Canada | T5T 1L6
Cell: (780) 499-5525 




**
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: Can't use Zint plugin since upgrading my Mac

2020-03-01 Thread Pat Bensky via 4D_Tech

I'm using 4D v17r6, Mac OS 10.5.3.
ZINT plugin version 3.2

Thanks
PB

On Sun, 1 Mar 2020 at 04:02, Keisuke Miyako via 4D_Tech <
4d_tech@lists.4d.com> wrote:

> are you trying to use v18 plugin on v17?
>
> as I posted before, it's really important to specify the version and
> platform.
>
> **
> 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
> **



-- 
*
CatBase - Top Dog in Data Publishing
tel: +44 (0) 207 118 7889
w: http://www.catbase.com
skype: pat.bensky
*
**
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: ORDA - NOT(IN)

Re: ORDA - NOT(IN)

Re: Printing List Box v16R5 - never mind

Printing List Box v16R5

Re: ORDA - NOT(IN)

Re: Can't use Zint plugin since upgrading my Mac

Re: An API for my 4D app

ORDA - NOT(IN)

Re: Can't use Zint plugin since upgrading my Mac

9 matches

Site Navigation

Mail list logo

Footer information