Re: incrementing sku

This WebDNA talk-list message is from

1998


It keeps the original formatting.
numero = 21047
interpreted = N
texte = At 11:12 Uhr -0800 16.11.1998, Chirs W wrote:>I made a field named record to give each item >there own specific number other than a sku. >but the question is , does any one now how I could make webcat search this >record field and find the last number >added (or Greatest) and then have add +1 to it when adding a new record ? >something like max+1 or something...Do a search, order it descending by your record field and put max=1 in the search context. This returnes the highest value and you can add 1 to it. Peter++++++++++++++++++++++++++++++++++++++++++++++++ Peter Ostry - Vienna/Austria - www.ostry.com Fon ++43-1-877 74 54 Fax ++43-1-877 74 54-21 ++++++++++++++++++++++++++++++++++++++++++++++++ Associated Messages, from the most recent to the oldest:

    
  1. Re: incrementing sku (Peter Ostry 1998)
At 11:12 Uhr -0800 16.11.1998, Chirs W wrote:>I made a field named record to give each item >there own specific number other than a sku. >but the question is , does any one now how I could make webcat search this >record field and find the last number >added (or Greatest) and then have add +1 to it when adding a new record ? >something like max+1 or something...Do a search, order it descending by your record field and put max=1 in the search context. This returnes the highest value and you can add 1 to it. Peter++++++++++++++++++++++++++++++++++++++++++++++++ Peter Ostry - Vienna/Austria - www.ostry.com Fon ++43-1-877 74 54 Fax ++43-1-877 74 54-21 ++++++++++++++++++++++++++++++++++++++++++++++++ Peter Ostry

DOWNLOAD WEBDNA NOW!

Top Articles:

Talk List

The WebDNA community talk-list is the best place to get some help: several hundred extremely proficient programmers with an excellent knowledge of WebDNA and an excellent spirit will deliver all the tips and tricks you can imagine...

Related Readings:

WCS Newbie question (1997) [subtotal] and others (1997) WC2b12: Yes, Formulas.db is for real (1997) Payment Processors (2005) New Web Site Developers Database (1996) PCS Frames (1997) Help name our technology! I found it (1997) default value from Lookup (was Grant, please help me) (1997) Weird problems with [SHOWIF]s (1997) 4.0 send email ticks. . (2000) More than one db with the same namn (was: WC2f3) (1997) Sendmail (1998) writing db to disk (1997) [WebDNA] TCPconnect and Bitcoin rate (2019) carriage returns in data (1997) WebCat2b13MacPlugIn - [include] (1997) inetinfo.exe (1999) Return records from another (1997) Searching Relational Databases (2004) Questions about maximum (1999)