hi,
just a short question to speed up:
as with any database one has quite often to decide if we *INSERT a NEW
row -- or -- UPDATE an existing row*
at the moment I do a check select on an unique ID intege which is
resonable fast:
code:
------------------------------------------------------------------------
SELECT ID FROM MyTable WHERE Account='MyAccountName'
------------------------------------------------------------------------
I just fetch one row.
if that get's a return I update otherwise I insert a new row.
QUESTION: is there a better way to make this important decision? using
Sqlite
regards W.Braun