Re^4: Increment DB using Perl

Replies are listed 'Best First'.
Re^5: Increment DB using Perl by RazorbladeBidet (Friar) on Mar 08, 2005 at 16:49 UTC
You need a static ID. If you want to go based on the ordering of the select statement, try (not sure how many DB's support this): `SELECT ROWID, ID FROM REQUEST` [download] and then update based upon that rowid (if possible)... but it's tricky when there's no key to go off of. I'm not even 100% sure that'll work. -------------- It's sad that a family can be torn apart by such a such a simple thing as a pack of wild dogs	[reply] [d/l]

Replies are listed 'Best First'.

Re^5: Increment DB using Perl
by RazorbladeBidet (Friar) on Mar 08, 2005 at 16:49 UTC

SELECT ROWID, ID
FROM  REQUEST
[download]

--------------
It's sad that a family can be torn apart by such a such a simple thing as a pack of wild dogs