So there is no chance to do something like that, right? I have to use generators?! *argh*

-----Ursprüngliche Nachricht-----
Von: Martijn Tonies [mailto:m.tonies@...]
Gesendet: Dienstag, 17. Februar 2004 14:35
An: firebird-support@yahoogroups.com
Betreff: Re: [firebird-support] Stored Procedure for Insert


Hi Marc,

> One question: If I write a stored procedure which gets the maximum value

of a field and adds 1 (or if it is null set it to 1), do a insert and give
the new number back.

>
> Would that work if more users would use that stored procedure?

If you mean by "getting the max value" is doing a SELECT MAX(...)
then: No. Multi-user/contextswitching problems.

With regards,

Martijn Tonies
Database Workbench - developer tool for InterBase, Firebird, MySQL & MS SQL
Server.
Upscene Productions
http://www.upscene.com



Yahoo! Groups Sponsor

ADVERTISEMENT


<http://rd.yahoo.com/SIG=12cpulvvv/M=274551.4550177.5718621.1261774/D=egroupweb/S=1705115386:HM/EXP=1077111170/A=1994230/R=2/*http://ad.doubleclick.net/jump/N3349.yahoo1/B1282054.22;abr=!ie4;abr=!ie5;sz=300x250;code=18634;dcopt=rcl;ord=1077024770007905?> Click HereClick Here
<http://us.adserver.yahoo.com/l?M=274551.4550177.5718621.1261774/D=egroupweb/S=:HM/A=1994230/rand=936733629>


_____

Yahoo! Groups Links


* To visit your group on the web, go to:
http://groups.yahoo.com/group/firebird-support/


* To unsubscribe from this group, send an email to:
firebird-support-unsubscribe@yahoogroups.com <mailto:firebird-support-unsubscribe@yahoogroups.com?subject=Unsubscribe>


* Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service <http://docs.yahoo.com/info/terms/> .




[Non-text portions of this message have been removed]