Re: WEB SERVICE CALL parsing error

2017-03-09 Thread Keisuke Miyako via 4D_Tech
when you process the WSDL (if there is one) using the built-in Wizard of 4D,
you would see orange flags, denoting "complex" types.

http://doc.4d.com/4Dv15/4D/15.4/Subscribing-to-a-Web-Service-in-4D.300-3285567.en.html
Note: If the parsing of the WSDL file reveals the presence of complex type 
parameters, the Wizard displays a yellow flag next to the method concerned

they are complex, in that the values are like objects,
so the parse needs to go more levels deep to reach 4D compatible types (scalar 
or array).

it is not impossible to use such services from 4D,
it's just that the auto-mapping feature of the wizard (and WEB SERVICE CALL) 
are literally out of their depth.

> 2017/03/10 16:21、John Baughman via 4D_Tech <4d_tech@lists.4D.com> のメール:
> What does "Complex types are not parsed in this version” mean?




**
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
**

JPR - Content of the World Tour 2017 Training Day

2017-03-09 Thread JPR via 4D_Tech
[JPR]

Hi Guys,

I've got some demands to described a little bit more what is going to be the 
content of the World Tour 2017's Training day. Some developers would like 
(probably) to know if they will not lose time and money to come and listen to 
JPR's speech once more time...

Most of the topic I will cover are new, as well as the examples I will show. 
This training is entirely based on the new horizons brought by 4D versions from 
V15R5 to V16R2, and how to smoothly make the steps that will lead developers 
using 4D for years, to much more powerful, fast, efficient ways of writing the 
code, thus getting full advantage of this brilliant version. We will boldly go 
together where you have never been before...

So this is a detailed description of what I will teach, explain, and 
demonstrate, during the second day (Training day):

- Adding more Objects in your Code:
Objects in programming
Objects as Parameters
Hashing Functions & Arrays
Associative Arrays

- The Data Structure from Schemaful to Schemaflex:
Objects as Fields
Dealing with variable-structure Fields
Adding User-parametrable Fields to an application in few clicks (with 
Component supplied)
Query, Sort, and use of this fields: Now and tomorrow.
The traps of Key-Value Stores.

- From Static to Dynamic Variables:
Form Object Names.
Form Objects & Data Sources.
Extensive use of ListBoxes.
CallBacks.
Concepts on Contexts. (How to deal with all the different levels of 
contexts)

- From Numbers to Names:
Moving slowly from Table number, Field number, Process number, Record 
number, etc. to Names, why and how.

- From 32-bit to 64-bit:
Reasons why to use 64-bit.
The problems of resources on Mac: PICT, cicn, STR#. (with Component 
supplied)

- From CALL PROCESS to CALL FORM:
Getting rid of the Outside Call event.
Getting rid of the On Timer event.
Getting rid of the CallBack Process.
Multiple windows without multiple processes.

- From Process to Worker:
Similarities & Differences between Process and Worker.
Advantages of Workers.

- From Cooperative to Pre-emptive:
Getting prepared for V16 Multithreading.
Parallel & Asynchronous programming.
Pre-emptive Multithreading: How to get prepared.
Understanding Workers, Processes, and Windows contexts.
Messaging, Slicing, Chunking, without (too much) Head-scratching.
How to go on breathing without Inter-process Variables.

Of course, all the examples I will use during this training will be given on 
the USB key. I spend a lot of time to find the easiest and lowest energy path, 
and I think, honestly, that the time you will spend in this one-day training 
will not be lost, for it will save you a lot on trying to break new ground in 
development. I'm 101% sure that the development time you will save worth the 
time you will spend coming to this day. And also the money. And even much 
more...

And if, after the training, you think you have lost your time and money, I 
promise I will make amends and cut a little finger (or a 3D printing of it, 
let's be modern!)

I hope to see you during this Tour, I got so many good memories of the 2015 
Tour! And meanwhile, should you have any questions, please feel free to ask it!

My very best,

JPR

P.S. You didn't ask about the first day, so I will not describe what you will 
see, but be sure it will not only be a lot of very interesting things in the 
topic "Yes you can do this with 4D V16", but it will be also a lot of fun!





**
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
**

WEB SERVICE CALL parsing error

2017-03-09 Thread John Baughman via 4D_Tech
I am getting the following error…

Error when executing the method "proxy_GetAllProjects" at line number 44

-
Error 9911 (The returned XML is incorrect. : Complex types are not parsed in 
this version.
error at line 1238, column 0: invalid character reference
)

Error code: 9911
Error 9911 (The returned XML is incorrect. : Complex types are not parsed in 
this version.
error at line 1238, column 0: invalid character reference
)
component: '4DRT'
The returned XML is incorrect.
task -4, name: 'P_15'
———

What does "Complex types are not parsed in this version” mean? 
I have sent a message to the web service to make sure the problem is not on 
their end, but Is there anything I can do on my end to get the response? As it 
is an empty blob is received.

4D 14.4
Mac OS El Capitan

Thanks,

John
**
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
**

Re: RESOURCE LIST & XLIFF Resource Files

2017-03-09 Thread Steven via 4D_Tech
Thanks Miyako and Nigel for your prompt replies.

> On Mar 9, 2017,Keisuke Miyako  > wrote:
> 
> there is no need to even open the file, let alone parse it with native 4D 
> commands.

Miyako, rather than creating an array of the strings within a designated list, 
I want to create arrays of the string list ids and resnames analogous to the 
results of "RESOURCE LIST (“STR#”; ResIDs_an;ResNames_at)".  My existing DBs 
rely on these arrays to reference the strings within each list.  

> On Mar 9, 2017,Nigel Greenlee  > wrote:
> 
> I don’t have an exact solution for you. but the following might give you some 
> pointers on the way to go. I got this code from the 4DBB-I DID NOT WRITE IT 
> MYSELF. it extracts all the 4D constants from the constants xliff file.


Nigel, with a bit of tinkering and lots of testing in the debugger I have 
gotten a variant of the code you posted to work.  In its raw state it is 
already adequate for my immediate purposes, with converted DBs.  But I intend 
to tweak it a bit more so that it can locate the Resource folder in 4dbase 
packages as well.  Mañana.  When it has a bit more polish I will post my code, 
just in case it may be of some use to others.  

Thanks again to both of you.

Steven Prins
Santa Fe, NM
**
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
**

Re: Copy or Drag from a listbox?

2017-03-09 Thread Keith Goebel via 4D_Tech
I’d like to offer a belated thank you to everyone who replied to my post and 
offered suggestions how to do it.
Much food for thought.
Cheers, Keith
**
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
**

osx open url vs osascript FYI

2017-03-09 Thread David Ringsmuth via 4D_Tech
4D v15.2
OSX 10.12+

I tried many different things to launch a .htm on OSX using OPEN URL, and it 
would not automatically open the document.

Included “safari” in the OPEN URL.
Used the “*” parameter in OPEN URL.
Stripped the volume name.
Removed Document Type and Creator, replaced with 4*char(0).
Added the Type in CREATE DOCUMENT.

So I used:

$outputStream_t:=""
$errorStream_t:=""

$LF:=Char(Line feed)

$script_t:="tell application \"Finder\""+$LF
$script_t:=$script_t+"print \""+$Path_Doc_t+"\" as alias"+$LF
$script_t:=$script_t+"end tell"+$LF
LAUNCH EXTERNAL PROCESS("osascript -";$script_t;$outputStream_t;$errorStream_t)

This works great!

David Ringsmuth

**
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
**

Re: v16 and Canvas

2017-03-09 Thread Jim Hays via 4D_Tech
16 beta 1 - yeah - I was surprised it's that old.  That's how often I get
to work with it I guess.  :(


On Thu, Mar 9, 2017 at 12:49 PM, Jeffrey Kain via 4D_Tech <
4d_tech@lists.4d.com> wrote:

> On Mar 9, 2017, at 12:40 PM, Jim Hays via 4D_Tech <4d_tech@lists.4d.com>
> wrote:
>
> > v16 beta 1 32 bit
>
> That's probably why you're crashing. :)  Why such an old (and beta)
> version, since v16 has been out of beta for quite a long time (and 16.0 HF1
> is also available)?
> **
> 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)
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
**

Re: 4D v15.4: Sequence number issue / Duplicate key error

2017-03-09 Thread Arnaud de Montard via 4D_Tech

> Le 9 mars 2017 à 17:18, Two Way Communications via 4D_Tech 
> <4d_tech@lists.4d.com> a écrit :
> 
> [...]
> I wonder … has anybody else had issues with Primary keys in combination with 
> sequence number?

Since v11 I use "auto increment": never. 

About index kind, unique _must_ be b-tree. 
Distinct value gives as much items as records? 
Some NaN (not a number) in the values? 

-- 
Arnaud de Montard 



**
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
**

Re: 4D v15.4: Sequence number issue / Duplicate key error

2017-03-09 Thread Kirk Brooks via 4D_Tech
Rudy,
I still use longint IDs as PKs on a lot of tables in v15 with no problems.
All of them autoincrement however. Like I said before if I need to ensure a
sequence I don't use the PK.

On Thu, Mar 9, 2017 at 8:18 AM, Two Way Communications via 4D_Tech <
4d_tech@lists.4d.com> wrote:

> I wonder … has anybody else had issues with Primary keys in combination
> with sequence number?
>

-- 
Kirk Brooks
San Francisco, CA
===
**
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
**

Re: v16 and Canvas

2017-03-09 Thread Pat Bensky via 4D_Tech
​Sorry - HF1 not HF2.
Also tried with v16R2 - same problem.
PB​

On 9 March 2017 at 17:53, Pat Bensky  wrote:

> Hmmm. I am using
> v16HF2 -  64bit
> Macbook Pro
> El Capitan 10.11.5
>
> It instantly crashes as soon as I select the "Canvas Plugin Area" plugin
> type.
>
> I'll try with the 32-bit version and see if that behaves better.
>
> Pat
>
> On 9 March 2017 at 17:40, Jim Hays via 4D_Tech <4d_tech@lists.4d.com>
> wrote:
>
>> Canvas is working for us with v16, but we haven't gone very far with it.
>> Our app crashes a lot, and we haven't had time to figure out why.
>> We still ship with v12.6.
>>
>> MacBook Pro touch bar
>> Sierra 10.12.3
>> v16 beta 1 32 bit
>> Interpreted
>>
>>
>> On Thu, Mar 9, 2017 at 11:46 AM, Pat Bensky via 4D_Tech <
>> 4d_tech@lists.4d.com> wrote:
>>
>> > Anybody successfully using the Canvas plugin with v16?
>> >
>> > --
>> > *
>> > CatBase - The Database Publishing Solution
>> > tel: +44 (0) 207 118 7889
>> > w: http://www.catbase.com
>> > skype: pat.bensky
>> > *
>> > **
>> > 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)
>> 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
>> **
>
>
>
>
> --
> *
> CatBase - The Database Publishing Solution
> tel: +44 (0) 207 118 7889 <+44%2020%207118%207889>
> w: http://www.catbase.com
> skype: pat.bensky
> *
>



-- 
*
CatBase - The Database Publishing Solution
tel: +44 (0) 207 118 7889
w: http://www.catbase.com
skype: pat.bensky
*
**
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
**

RE: 4D 15.4 HF1 (windows) - crashes when run as service

2017-03-09 Thread Timothy Penner via 4D_Tech
Hi Keith,

> Is this meant as a reminder to 4D to not create a user interface for 4D 
> Server?  ;-)   (4D may be working towards a headless 4D Server?)

That was meant as a reminder for the 4D Community to not activate the user 
interface on service. Here is another reminder:
When 4D Server is launched as a service the 4D Server Administration is not 
displayed; one must interact with the service and choose to display the Admin 
Window from 4D's Window Menu. Interacting with the service is already 
discouraged on the latest versions of Windows and one must modify the registry 
to even see the service. In addition, we have discouraged creating interfaces 
on the server for many versions/years (see forbidden and inappropriate commands 
here: http://livedoc.4d.com/4Dv15.4/help/Title/en/page2759.html and a similar 
list for v11: http://livedoc.4d.com/4D-Serverv11.6/help/Title/en/page316.html)

> Retaining access to 4D Server's user interface is currently essential for 
> system admins to be able to drop users or to see 4D error message dialogs 
> that may have appeared on the 4D Server UI.
> Now I know you're going to tell me that you can use the 4D Remote 
> Administration Window to do the drop-users thing.  Great, but how do you get 
> to _that_ if all your 4D connection licenses are currently used up?  Catch-22

Yes, using the Administration Window on the 4D Remote (client) is the perfect 
solution for this. As to your catch 22 the best answer is to purchase enough 
license for your users, and then the 2 included licenses from 4D Server could 
be used for Administrator and/or Designer related tasks. Neil and Tom have also 
provided very good responses for this.

> Good to know that this has been fixed, so thanks.

The fixed versions are already available in the Nightly Build forums.

I hope this helps,

Tim PENNER




**
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
**

Re: v16 and Canvas

2017-03-09 Thread Pat Bensky via 4D_Tech
Hmmm. I am using
v16HF2 -  64bit
Macbook Pro
El Capitan 10.11.5

It instantly crashes as soon as I select the "Canvas Plugin Area" plugin
type.

I'll try with the 32-bit version and see if that behaves better.

Pat

On 9 March 2017 at 17:40, Jim Hays via 4D_Tech <4d_tech@lists.4d.com> wrote:

> Canvas is working for us with v16, but we haven't gone very far with it.
> Our app crashes a lot, and we haven't had time to figure out why.
> We still ship with v12.6.
>
> MacBook Pro touch bar
> Sierra 10.12.3
> v16 beta 1 32 bit
> Interpreted
>
>
> On Thu, Mar 9, 2017 at 11:46 AM, Pat Bensky via 4D_Tech <
> 4d_tech@lists.4d.com> wrote:
>
> > Anybody successfully using the Canvas plugin with v16?
> >
> > --
> > *
> > CatBase - The Database Publishing Solution
> > tel: +44 (0) 207 118 7889
> > w: http://www.catbase.com
> > skype: pat.bensky
> > *
> > **
> > 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)
> 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
> **




-- 
*
CatBase - The Database Publishing Solution
tel: +44 (0) 207 118 7889
w: http://www.catbase.com
skype: pat.bensky
*
**
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
**

Re: v16 and Canvas

2017-03-09 Thread Jeffrey Kain via 4D_Tech
On Mar 9, 2017, at 12:40 PM, Jim Hays via 4D_Tech <4d_tech@lists.4d.com> wrote:

> v16 beta 1 32 bit

That's probably why you're crashing. :)  Why such an old (and beta) version, 
since v16 has been out of beta for quite a long time (and 16.0 HF1 is also 
available)?
**
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
**

Re: v16 and Canvas

2017-03-09 Thread Jim Hays via 4D_Tech
Canvas is working for us with v16, but we haven't gone very far with it.
Our app crashes a lot, and we haven't had time to figure out why.
We still ship with v12.6.

MacBook Pro touch bar
Sierra 10.12.3
v16 beta 1 32 bit
Interpreted


On Thu, Mar 9, 2017 at 11:46 AM, Pat Bensky via 4D_Tech <
4d_tech@lists.4d.com> wrote:

> Anybody successfully using the Canvas plugin with v16?
>
> --
> *
> CatBase - The Database Publishing Solution
> tel: +44 (0) 207 118 7889
> w: http://www.catbase.com
> skype: pat.bensky
> *
> **
> 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)
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
**

v16 and Canvas

2017-03-09 Thread Pat Bensky via 4D_Tech
Anybody successfully using the Canvas plugin with v16?

-- 
*
CatBase - The Database Publishing Solution
tel: +44 (0) 207 118 7889
w: http://www.catbase.com
skype: pat.bensky
*
**
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
**

RE: 4D 15.4 HF1 (windows) - crashes when run as service

2017-03-09 Thread Benedict, Tom via 4D_Tech
Keith White writes:

>Retaining access to 4D Server's user interface is currently essential for 
>system admins to be able to drop users or to see 4D error message dialogs that 
>may have appeared on the 4D Server UI.

>Now I know you're going to tell me that you can use the 4D Remote 
>Administration Window to do the drop-users thing.  Great, but how do you get 
>to _that_ if all your 4D connection licenses are currently used up?  Catch-22

When 4D Server starts up, have it launch a 4D Client logged into 4D Server. 
That way it will always get the first license and you'll have access to the 
Administration Window.

HTH,

Tom Benedict
Optum

This e-mail, including attachments, may include confidential and/or
proprietary information, and may be used only by the person or entity
to which it is addressed. If the reader of this e-mail is not the intended
recipient or his or her authorized agent, the reader is hereby notified
that any dissemination, distribution or copying of this e-mail is
prohibited. If you have received this e-mail in error, please notify the
sender by replying to this message and delete this e-mail immediately.
**
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 v15.4: Internet commands

2017-03-09 Thread Two Way Communications via 4D_Tech
Hi guys,

Since my customer is using 4D v15.4 (2 weeks now), he is experiencing frequent 
issues while sending e-mails.

I did have to change SMTP_SetPrefs from (0;1;0) to (1;8;0), but 95% of the 
emails are sent correctly.

For the other 5%, they get an error mail from the provider’s email stating that 
the e-mail could not be delivered.

it says:

Status: 5.1.1
Diagnostic-Code: smtp; 501 5.5.4 Syntax error in BODY parameter


Has 4D something changed in the headers of outgoing mail messages? What is it 
doing different in v15.4?


Regards,

Rudy Mortier
Two Way Communications bvba  -

**
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
**

Re: 4D v15.4: Sequence number issue / Duplicate key error

2017-03-09 Thread Two Way Communications via 4D_Tech
Hi Arnaud,

Yes, it is only 4D v15.4 (haven’t tried yet with v15R4)

Index kind: I tried all, no difference

It is a small table (20.000 records)

Rebuilding the index fixes the problem for a short while, but it returns. 
Database has been compacted twice, no errors.

I wonder … has anybody else had issues with Primary keys in combination with 
sequence number?


Regards,

Rudy Mortier
Two Way Communications bvba  -



> On 08 Mar 2017, at 14:43, Arnaud de Montard via 4D_Tech 
> <4d_tech@lists.4d.com> wrote:
> 
> 
>> Le 8 mars 2017 à 13:26, Two Way Communications via 4D_Tech 
>> <4d_tech@lists.4d.com> a écrit :
>> 
>> Hi all,
>> 
>> I ran into an issue while using SEQUENCE NUMBER in 4D v15.4, in a 
>> client-server setup.
>> 
>> I put the result in a field called ‘ID’, which is the primary key for that 
>> table, and by default is unique. Auto increment is off.
>> The code is running in a transaction.
> 
> I do the reverse:
> - auto increment on
> - no sequence number call
> Let's say I'm lazy enough to consider primary key delivery is the DB job, not 
> mine… 
> 
> But it seems your problem is the index, as you mention rebuilding fixes the 
> issue. 
> What is the index kind? 
> Big table? 
> Is it only since v15.4? (I should have started by this…)
> 
> -- 
> Arnaud de Montard 
> 
> 
> 
> **
> 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)
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
**

RE: 4D 15.4 HF1 (windows) - crashes when run as service

2017-03-09 Thread Dennis, Neil via 4D_Tech
>  Great, but how do you get to _that_ if all your 4D connection licenses are 
> currently used up?  Catch-22

Buy licenses for each user, you get 2 for free with a purchase of a 4D server, 
you can use these as spares :)

Neil









Privacy Disclaimer: This message contains confidential information and is 
intended only for the named addressee. If you are not the named addressee you 
should not disseminate, distribute or copy this email. Please delete this email 
from your system and notify the sender immediately by replying to this email.  
If you are not the intended recipient you are notified that disclosing, 
copying, distributing or taking any action in reliance on the contents of this 
information is strictly prohibited.

The Alternative Investments division of UMB Fund Services provides a full range 
of services to hedge funds, funds of funds and private equity funds.  Any tax 
advice in this communication is not intended to be used, and cannot be used, by 
a client or any other person or entity for the purpose of (a) avoiding 
penalties that may be imposed on any taxpayer or (b) promoting, marketing, or 
recommending to another party any matter addressed herein.
**
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
**

Re: RESOURCE LIST & XLIFF Resource Files

2017-03-09 Thread Nigel Greenlee via 4D_Tech
Steven

I don’t have an exact solution for you. but the following might give you some 
pointers on the way to go. I got this code from the 4DBB-I DID NOT WRITE IT 
MYSELF. it extracts all the 4D constants from the constants xliff file.

C_POINTER($1;$constantNames_p_at)
C_POINTER($2;$constantIDs_p_at)

C_TIME($constantsXLIFFFile_h)
C_TEXT($constantsXLIFFFile_t)
C_TEXT($elementName_t;$elementPrefix_t;$constantName_t;$constantID_t)
C_BOOLEAN($transUnitFound_f;$targetFound_f)
C_LONGINT($SAXEvent_l;$pos_l)

ARRAY TEXT($attributeNames_at;0)
ARRAY TEXT($attributeVals_at;0)

$constantNames_p_at:=$1
$constantIDs_p_at:=$2

$constantsXLIFFFile_t:=(Application file)+Folder separator+"Contents"+Folder 
separator+"Resources"+Folder separator+"en.lproj"+Folder 
separator+"4D_ConstantsEN.xlf"

$constantsXLIFFFile_h:=Open document($constantsXLIFFFile_t;Read mode)

If (OK=1)

Repeat 
$SAXEvent_l:=SAX Get XML node($constantsXLIFFFile_h)
Case of 

: ($SAXEvent_l=XML start element)
SAX GET XML ELEMENT($constantsXLIFFFile_h;$elementName_t;\
$elementPrefix_t;$attributeNames_at;$attributeVals_at)

  // Need to locate the "target" element for each constant "trans-unit".
Case of 
: ($elementName_t="trans-unit")
$pos_l:=Find in array($attributeNames_at;"id")
If ($pos_l>0)
$constantID_t:=$attributeVals_at{$pos_l}
  // Ignore the first trans-unit in each group, it's not a constant.
If ($constantID_t#"@_0")
$transUnitFound_f:=True
$constantID_t:=Substring($constantID_t;3)
Else 

End if 
End if 

: ($elementName_t="target")
If ($transUnitFound_f)
$targetFound_f:=True
$transUnitFound_f:=False
End if 
End case 

: ($SAXEvent_l=XML DATA)
  // With the target located, we have the constant name.
If ($targetFound_f)
SAX GET XML ELEMENT VALUE($constantsXLIFFFile_h;$constantName_t)
APPEND TO ARRAY($constantNames_p_at->;$constantName_t)
APPEND TO ARRAY($constantIDs_p_at->;Num($constantID_t))
$constantName_t:=""
$constantID_t:=""
$targetFound_f:=False
End if 

End case 
Until ($SAXEvent_l=XML end document)

CLOSE DOCUMENT($constantsXLIFFFile_h)
End if 

> On 9 Mar 2017, at 02:07, Steven via 4D_Tech <4d_tech@lists.4d.com> wrote:
> 
> Miyako’s reply confirms that RESOURCE LIST does not work with XLIFF files, as 
> I suspected.  
> 
> So having extracted my STR# resources into XLIFF files (with the help of 
> Miyako's component, thanks again), what I would like to do is replicate its 
> functionality, i.e. extract arrays of the ‘ids’ and ’resnames’ of all of the 
> ‘group’ elements present within those XLIFF files.  I am confident that that 
> can be done, but as I said I am entirely out of my depth with respect to XML 
> and native 4D XML commands.  
> 
> Any direction, better yet, sample code would be greatly appreciated.  
> 
> Thanks in advance.
> 
> Steven Prins
> Santa Fe, NM
> 
> 
>> On Mar 8, 2017, at 3:32 AM, 4d_tech-requ...@lists.4d.com wrote:
>> 
>> Message: 3
>> Date: Wed, 8 Mar 2017 03:08:52 +
>> From: Keisuke Miyako mailto:keisuke.miy...@4d.com>>
>> To: 4D iNug Technical <4d_tech@lists.4d.com >
>> Subject: Re: RESOURCE LIST & XLIFF Resource Files
>> Message-ID: <7fd1fa79-e659-4e63-a649-592762650...@4d.com 
>> >
>> Content-Type: text/plain; charset="utf-8"
>> 
>> Hello,
>> 
>> the command RESOURCE LIST was never associated with XLIFF.
>> 
>> resource commands that work with XLIFF are:
>> 
>> STRING LIST TO ARRAY
>> http://doc.4d.com/4Dv15/4D/15.4/STRING-LIST-TO-ARRAY.301-3274706.en.html 
>> 
>> 
>> and
>> 
>> Get indexed string
>> http://doc.4d.com/4Dv15/4D/15.4/Get-indexed-string.301-3274707.en.html 
>> 
>> 
>> see also:
>> 
>> Appendix C: XLIFF architecture
>> http://doc.4d.com/4Dv15/4D/15.4/Appendix-C-XLIFF-architecture.300-3285323.en.html
>>  
>> 
>> 
>>> 2017/03/08 1:22、Steven via 4D_Tech <4d_tech@lists.4d.com 
>>> > のメール:
>>> Does the 4D command “RESOURCE LIST” still work with XLIFF string resource 
>>> files?
>> 
> 
> **
> 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)
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
**

RE: 4D 15.4 HF1 (windows) - crashes when run as service

2017-03-09 Thread Keith White via 4D_Tech
>Reminder: it is not recommended to create user interface on 4D Server when 
>launched as a service

Tim

Is this meant as a reminder to 4D to not create a user interface for 4D Server? 
 ;-)   (4D may be working towards a headless 4D Server?)

Retaining access to 4D Server's user interface is currently essential for 
system admins to be able to drop users or to see 4D error message dialogs that 
may have appeared on the 4D Server UI.

Good to know that this has been fixed, so thanks.

Now I know you're going to tell me that you can use the 4D Remote 
Administration Window to do the drop-users thing.  Great, but how do you get to 
_that_ if all your 4D connection licenses are currently used up?  Catch-22

Best regards

Keith White
Synergist Express Ltd, UK.

**
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
**