Re: trouble updating records in database

This WebDNA talk-list message is from

1998


It keeps the original formatting.
numero = 19079
interpreted = N
texte = >I also have databases without a SKU field. I just thought it would be >nice to have automatic unique fields. Is it not a problem to be solved, >but rather a possible nice feature.I agree. If there were a new preference called something like UniqueFieldNames, then we could name one or several fields -- to be used in ANY db where we might need them to have unique values -- and those fields would ALWAYS be checked in every append and replace action.Of course, that means we would also need a new record in the errormessages.db that tells WebCatalog what to do when the append or replace fails because of an attempted duplicate value ... :)Sincerely, Ken Grome 808-737-6499 WebDNA Solutions mailto:ken@webdna.net http://www.webdna.net Associated Messages, from the most recent to the oldest:

    
  1. Re: trouble updating records in database (Peter Ostry 1998)
  2. Re: trouble updating records in database (Charles Kefauver 1998)
  3. Re: trouble updating records in database (Kenneth Grome 1998)
  4. Re: trouble updating records in database (Peter Ostry 1998)
  5. Re: trouble updating records in database (Charles Kefauver 1998)
  6. Re: trouble updating records in database (Charles Kefauver 1998)
  7. Re: trouble updating records in database (Kenneth Grome 1998)
  8. Re: trouble updating records in database (Peter Ostry 1998)
  9. Re: trouble updating records in database (Charles Kefauver 1998)
  10. Re: trouble updating records in database (Gil Poulsen 1998)
  11. Re: trouble updating records in database (Peter Ostry 1998)
  12. Re: trouble updating records in database (Will Starck 1998)
  13. Re: trouble updating records in database (Peter Ostry 1998)
  14. Re: trouble updating records in database (PCS Technical Support 1998)
  15. Re: trouble updating records in database (Kenneth Grome 1998)
  16. Re: trouble updating records in database (Charles Kefauver 1998)
  17. Re: trouble updating records in database (PCS Technical Support 1998)
>I also have databases without a SKU field. I just thought it would be >nice to have automatic unique fields. Is it not a problem to be solved, >but rather a possible nice feature.I agree. If there were a new preference called something like UniqueFieldNames, then we could name one or several fields -- to be used in ANY db where we might need them to have unique values -- and those fields would ALWAYS be checked in every append and replace action.Of course, that means we would also need a new record in the errormessages.db that tells WebCatalog what to do when the append or replace fails because of an attempted duplicate value ... :)Sincerely, Ken Grome 808-737-6499 WebDNA Solutions mailto:ken@webdna.net http://www.webdna.net Kenneth Grome

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:

Still Stumped on ShowNext...HELP! (1997) Ok here is a question? (1997) Help name our technology! (1997) WebCat2b13MacPlugIn - More limits on [include] (1997) possible, WebCat2.0 and checkboxes-restated (1997) WCS Newbie question (1997) WebCatalog and WebMerchant reviewed by InfoWorld (1997) problem: mail changed (1997) Calculating multiple shipping... (1997) results in a table (2000) WebCat2: Found Items syntax, etc. (1997) Frames and WebCat (1997) WebCatalog Beta Documentation (1997) WC Database Format (1997) Shipping charges depending on tax rate? (1997) WC Database Format (1997) We have Proof (1997) Help! WebCat2 bug (1997) Max Record length restated as maybe bug (1997) two unique banners on one page (1997)