Re: RESOURCE LIST & XLIFF Resource Files

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: Tables created with SQL CREATE TABLE command and triggers

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

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

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

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

> 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

> 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

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

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

> 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

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

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

> 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

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

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

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

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?

„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?

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

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

> 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

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