It is currently Mon May 21, 2012 7:07 pm

All times are UTC + 2 hours




Post new topic Reply to topic  [ 3 posts ] 
Author Message
 Post subject: Sequence
PostPosted: Sun May 22, 2011 5:26 pm 
Offline

Joined: Thu Dec 03, 2009 4:30 pm
Posts: 18
In sale_order_line (postgres db) I insert: nextval('sale_order_line_insertion'::regclass)
But inside the program I always get 10 and it is not incrementing the value.
How do I achieve the mess?


Top
 Profile  
 
 Post subject: Re: Sequence
PostPosted: Tue May 24, 2011 10:04 am 
Offline

Joined: Wed Jan 27, 2010 6:21 pm
Posts: 797
Location: Auckland, NZ
I think you are getting sequence confused with sequences. Given you are doing nothing more than incrementing the sequence and the default is to order by sequence, then id, there really isn't any point to the incrementing in the first place.

_________________
Graeme


Top
 Profile  
 
 Post subject: Re: Sequence
PostPosted: Sun Jun 19, 2011 3:26 pm 
Offline

Joined: Tue Oct 06, 2009 10:33 am
Posts: 35
Location: Ukraine
Hi gdaddy.

Did you find any solution for your problem (automatic sequence increment)?

Firstly I'll describe some my situation (sales model). I'm selling spare parts for agricultural machines. I get a requests for quotation from client and make offer for him. The products list is splitted on some parts in my offer depending on machine model or machine bundle so lines order is very important because it should go directly as it's needed. I'm using sales_layout module for sequences in sales orders but I found it very anoying to put the number all the time by hands especially if you have to make offer for about 200 positions. Also sometimes clients add or deduct some positions. In this case I need to have some gap between seq. numbers to add product in right place (with deduction there is no problems).

I think the right way is to mention "sequence" as function in sale_layout.py of a sale_layout module (at least I'm using this module). For me solution will be to get sequence with some incrementing value, say 10, so we would have 10, 20, 30... product lines sequence values (offcource with possibility to change by hands).

Any thoughts?

_________________
Best Regards, Eugene Babiy

Sales/Purchase Manager
Agrolinii LLC.
Kiev, UKRAINE


Top
 Profile  
 
Display posts from previous:  Sort by  
Post new topic Reply to topic  [ 3 posts ] 

All times are UTC + 2 hours


You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum

Search for:

Protected by Anti-Spam ACP