Re: [WebERP-developers] GetNextTransNo

[Phil D. <we...@pa...>]

The first transaction was sales orders and they use an auto-increment column. 
However, whilst seeding from a specified transaction number can be done 
equally with an auto increment the GetNextTransNo allows is more flexible. A 
record of the transaction number is also retained in the table systypes - its 
much quicker to retrieve the last transaction number from this table rather 
than use MAX() in the busy transaction table.
It would be preferable in my view to keep the code consistent with what is 
already there and use the GetNextTransNo function.

Phil

On Tue, 29 Nov 2005 05:52, Clay Mockus wrote:
> Hi Everyone
> Just curious - what's the purpose of GetNextTransNo()? Is it for
> databases that don't have auto_increment functionality?
>
> Can I just ignore this and make my primary key auto_increment when
> designing a new table?
>
> Thanks,
> Clay Mockus
> SE Solutions
> cla...@se...
>
>
>
> -------------------------------------------------------
> This SF.net email is sponsored by: Splunk Inc. Do you grep through log
> files for problems?  Stop!  Download the new AJAX search engine that makes
> searching your log files as easy as surfing the  web.  DOWNLOAD SPLUNK!
> http://ads.osdn.com/?ad_id=7637&alloc_id=16865&op=click
> _______________________________________________
> Web-erp-developers mailing list
> Web...@li...
> https://lists.sourceforge.net/lists/listinfo/web-erp-developers

-- 
Phil Daintree
webERP Project Admin