> another point that I did not make clear. The accounting programs are not
> associated with the technical programs, different people, different security
> access. The tech databases and programs are in portable computers that go out
> in the field, but not the accounting, etc. There indexes
> another point that I did not make clear. The accounting programs are not
> associated with the technical programs, different people, different security
> access. The tech databases and programs are in portable computers that go out
> in the field, but not the accounting, etc. There indexes
> This is not strictly a SQLite question, though in my case it is.
>
> Any application that involves a "persistent" database, i.e., one where the
> data is long-lived and expected to exist and evolve over time, sooner or later
> has the issue of moving customers from a V1 database to a V2
> On 4/5/19 11:14 AM, Arthur Blondel wrote:
> > I have enough disk space. I just limit the database file size artificially
> > for testing purpose as you can see.
> > There is no problem of privilege and there is nothing else than the code I
> > sent. No other access to the DB.
> > I'm using
> I do not know what the underlying representation for floating point
> numbers is in Excel, but as your experiment shows, it is probably not
> IEEE754 double-precision binary.
>
Well according to this is does...
> This is what I would call "forward compatibility": You expect an old
> application
> to be able to read file formats of a future version. Do you have an example
> where there is really required?
I have an Android app that lets you share the database between users. The
app will run on a variety
> > > This is what I would call "forward compatibility": You expect an old
> > application
> > > to be able to read file formats of a future version. Do you have an
> > example
> > > where there is really required?
> >
> > I have an Android app that lets you share the database between users. The
>
>On 12/03/2020 08:47, David Blake wrote:
>> I'm looking for an easy way to maintain a last updated column for each
>> record in several tables and considering if using a triggers is viable.
>>
>> I thought that defining a trigger like this on each table would work
>>
>> CREATE TRIGGER
>Thanks Andy
>> In addition, the role of the "when" clause is unclear. Is it necessary?
>>
>> I don't think it is. I have a very similar trigger which I've been
>> using for several years And it doesn't have the where...
>>
>> CREATE TRIGGER [UpdatePortTime] AFTER UPDATE ON ports FOR EACH ROW
> Please consider subscribing to the new Forum. The intent is that the forum
> will eventually replace this mailing list.
Having just had a go at subscribing, I screwed up and mistyped my email address.
Is there any way for me to change it?
Regards
Andy Ling
10 matches
Mail list logo