Miyako’s reply confirms that RESOURCE LIST does not work with XLIFF files, as I
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
Roll your own.
this solves the control issue.
and you can extend the sequence number generator to other things - not just
Think License plates alphas and numerics, embedded dates, fixed text, just
> Well I stand corrected.
> On Wed, Mar 8, 2017 at
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
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
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,
Ah Relationships-well you never mentioned them I was thinking of an
…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
> On Mar 8, 2017,Keisuke Miyako > wrote:
> 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
> On Mar 8, 2017, at 6:26 AM, Two Way Communications via 4D_Tech
> <email@example.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
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
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
> On Mar 8, 2017, at 9:09 AM, Kirk Brooks via 4D_Tech <firstname.lastname@example.org>
> 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
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
A cunning plan, but wouldn't work because
a) only one database can be active at a time, so only one table would be
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 :)
> Le 8 mars 2017 à 13:26, Two Way Communications via 4D_Tech
> <email@example.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
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
1) Put some code in the ‘save’ part of the
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
Yeah I did look into that option as well, but it doesn't solve the trigger
problem. Triggers are essential to us!
On 8 March 2017 at 12:19, Nigel Greenlee via 4D_Tech <firstname.lastname@example.org>
> A sideways question for your concept.
> 1) Are you creating the tables in
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
„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
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
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 <
> > Le 8 mars 2017 à 10:19, Pat
> Le 8 mars 2017 à 10:19, Pat Bensky via 4D_Tech <email@example.com> a écrit
> [...] Also I've realised that there is another fundamental problem with the
> of allowing customers to create new fields: when we issue a program update,
> those custom fields - and their data - will
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
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
Mail list logo