Re: RESOURCE LIST & XLIFF Resource Files

2017-03-08 Thread Steven via 4D_Tech
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

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

2017-03-08 Thread Chip Scheide via 4D_Tech
Roll your own. this solves the control issue. and you can extend the sequence number generator to other things - not just numeric values. Think License plates alphas and numerics, embedded dates, fixed text, just about anything. > John, > Well I stand corrected. > > On Wed, Mar 8, 2017 at

Re: Tables created with SQL CREATE TABLE command and triggers

2017-03-08 Thread Tim Nevels via 4D_Tech
On Mar 8, 2017, at 2:00 PM, David Samson wrote: > One problem I came up against with external data files is that they are not > multi user i.e. one user accessing it locks all other users out. I am on > v14 so things might have changed. But if you have the external database “served" from 4D

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

2017-03-08 Thread Timothy Penner via 4D_Tech
Hi Randy, It looks like I was wrong; I didn’t see the issue when I tested yesterday because I ran the service in Non-Interactive mode. Apparently there is an issue with Interactive services or when a dialog/window is displayed within the service. The bug is: ACI0096507 : Crash when opening a

[OFF] Details of NSA Hacking Group

2017-03-08 Thread Tim Nevels via 4D_Tech
Here’s some programming related information on the details of how the NSA hacking group, called “Equation Group”, operated and were found before the Snowden Wikileaks dump a few days ago. NSA and CIA both have groups of 20 - 100 people that spend all day hacking everything computer related,

Re: Tables created with SQL CREATE TABLE command and triggers

2017-03-08 Thread Nigel Greenlee via 4D_Tech
Pat Ah Relationships-well you never mentioned them I was thinking of an Autistic System:) …i guess there is no way other than external database file with 500 or so tables(that should be enough:)) as mentioned by Tim Nevels (You can easily automate the creation of the tables of course

Re: RESOURCE LIST & XLIFF Resource Files

2017-03-08 Thread Steven via 4D_Tech
> On Mar 8, 2017,Keisuke Miyako > wrote: > > Hello, > > the command RESOURCE LIST was never associated with XLIFF. > > resource commands that work with XLIFF are: > > STRING LIST TO ARRAY Doh! I told you I you I suspected I might be

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

2017-03-08 Thread John DeSoi via 4D_Tech
> On Mar 8, 2017, at 6:26 AM, Two Way Communications via 4D_Tech > <4d_tech@lists.4d.com> wrote: > > I have exported the data to a tab delimited file, truncated the table, and > imported the data. Problem is still there. > I have compacted the data file. Same problem. After doing this import

Re: Tables created with SQL CREATE TABLE command and triggers

2017-03-08 Thread Tim Nevels via 4D_Tech
On Mar 8, 2017, at 8:34 AM,Pat Bensky wrote: > Yeah I did look into that option as well, but it doesn't solve the trigger > problem. Triggers are essential to us! Here is an idea: Create the number of tables that you want for your users to be able to use, but only include 1 field for the

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

2017-03-08 Thread Alan Chan via 4D_Tech
We have been using Sequence Number for years without any problem. It depends how/when you use it My suggestion is to make use of newer features such as Auto-increment on either UUID or Longint. If you don't want to use auto-increment for whatever reasons, you could call it at Trigger for new

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

2017-03-08 Thread John DeSoi via 4D_Tech
> On Mar 8, 2017, at 9:09 AM, Kirk Brooks via 4D_Tech <4d_tech@lists.4d.com> > wrote: > > Currently, let's say a user begins a transaction ​and the new record gets > the sequence number. Before that transaction is completed another user > starts a new record (or that user starts another process

Re: Tables created with SQL CREATE TABLE command and triggers

2017-03-08 Thread Chip Scheide via 4D_Tech
On Wed, 8 Mar 2017 09:19:35 +, Pat Bensky wrote: > Hi Chip, > The problem with that scenario is that it would preclude the use of 4D > features such as the report editor, 4DWrite, label editor, etc. - all > things that our customers use. Or we would have to roll out our own, which > I'm not

Re: Tables created with SQL CREATE TABLE command and triggers

2017-03-08 Thread Pat Bensky via 4D_Tech
Hi Nigel, A cunning plan, but wouldn't work because a) only one database can be active at a time, so only one table would be accessible. b) We allow the customer to define their own relations between their tables, and that wouldn't be possible. But I like your outside-the-box thinking :) Pat On

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

2017-03-08 Thread Arnaud de Montard via 4D_Tech
> 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,

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

2017-03-08 Thread Nigel Greenlee via 4D_Tech
Rudy In my vast head banging experience of this its usually that a record has been created with no ID, or in the case of sequence the 4D sequence is out of sync. My suspicions would be records in transactions or record deletions Two suggestions.. 1) Put some code in the ‘save’ part of the

Re: Tables created with SQL CREATE TABLE command and triggers

2017-03-08 Thread Nigel Greenlee via 4D_Tech
Pat OK.. Let me suggest something crazy then... 1) You create an external data(file) with a single table(with a trigger).. Lets call this the template.-we never use the template 2) When a user wants to create a custom table you duplicate the template(Using LEP)..rename the ‘copy’ to reflect

Re: Tables created with SQL CREATE TABLE command and triggers

2017-03-08 Thread Pat Bensky via 4D_Tech
Hi Nigel, Yeah I did look into that option as well, but it doesn't solve the trigger problem. Triggers are essential to us! Pat On 8 March 2017 at 12:19, Nigel Greenlee via 4D_Tech <4d_tech@lists.4d.com> wrote: > Pat > > A sideways question for your concept. > > 1) Are you creating the tables in

Re: Tables created with SQL CREATE TABLE command and triggers

2017-03-08 Thread Nigel Greenlee via 4D_Tech
Pat A sideways question for your concept. 1) Are you creating the tables in the main structure or using the external datafile( CREATE DATABASE IF NOT EXISTS DATAFILE <<$_t_CustomTablesPath>>;) .(I use an external datafile structure for some things-very useful..it could be useful in your

Re: What is Cadran?

2017-03-08 Thread Herr Alexander Heintz via 4D_Tech
„Cadran“ is french for „frame“. You ran into a bug in 4D itself, as you might know much of 4Ds interfaces are programmed in 4D itself! Most of the time these go away after a restart, otherwise delete all preferences and re-install the application. > Am 08.03.2017 um 11:28 schrieb Douglas

What is Cadran?

2017-03-08 Thread Douglas Cryer via 4D_Tech
I have number of EPOS tills which use an engined 4D application which has been in place for around 6 years with a few upgrades and version releases. One of the till has just started reporting an error: Error when executing the method “Cadran_1” at line number 8 The method cannot be executed

Re: Tables created with SQL CREATE TABLE command and triggers

2017-03-08 Thread Pat Bensky via 4D_Tech
Hi Arnaud, Yes, but the thing is that the TABLES will not be missing, only the custom fields that the client created. Now if there was a REGENERATE MISSING FIELDS function ... On 8 March 2017 at 09:59, Arnaud de Montard via 4D_Tech < 4d_tech@lists.4d.com> wrote: > > > Le 8 mars 2017 à 10:19, Pat

Re: Tables created with SQL CREATE TABLE command and triggers

2017-03-08 Thread Arnaud de Montard via 4D_Tech
> Le 8 mars 2017 à 10:19, Pat Bensky via 4D_Tech <4d_tech@lists.4d.com> a écrit > : > > [...] Also I've realised that there is another fundamental problem with the > idea > of allowing customers to create new fields: when we issue a program update, > those custom fields - and their data - will

Re: Tables created with SQL CREATE TABLE command and triggers

2017-03-08 Thread Pat Bensky via 4D_Tech
Hi Chip, The problem with that scenario is that it would preclude the use of 4D features such as the report editor, 4DWrite, label editor, etc. - all things that our customers use. Or we would have to roll out our own, which I'm not inclined to do :) Also I've realised that there is another

Re: Can 4D connect to Firebird

2017-03-08 Thread Douglas Cryer via 4D_Tech
David, I did a project in 2001 where I knew before I started that 4D could not handled the number of records in it’s database. I found Firebird and I also found someone who had written a plugin for 4D to speak to it. Firebird is a very powerful, very versatile and is very SQL compliant, I