Re: trouble updating records in database
This WebDNA talk-list message is from 1998
It keeps the original formatting.
numero = 19064
interpreted = N
texte = >>The WebDNA programmer, not the software, should perform a check for the >>existence of the duplicate SKU, then he/she should program WebCatalog to >>NOT append that new record if the SKU already exists *AND* if the SKU >>field is actually being used as a unique record identification value. > >Sure, but it is more work, and the programmer must remember to do so in >each new proyect. In all other Database systems, when you flag a field as >being unique, the underlying database makes sure it is unique.The SKU value doesn't have to be unique unless the particular situation calls for it. In fact, there doesn't even have to be a field named SKU unless the particular situation calls for it.In WebCatalog, having a field with a unique value is entirely up to the programmer, it's not something that's forced on the programmer by the software and it is definitely not a requirement of the software. In other words, WebCatalog is a lot more flexible than the database software you're used to.Many of my db's don't need SKU fields or unique record identifiers, so I don't even bother to create them ... :)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:
>>The WebDNA programmer, not the software, should perform a check for the >>existence of the duplicate SKU, then he/she should program WebCatalog to >>NOT append that new record if the SKU already exists *AND* if the SKU >>field is actually being used as a unique record identification value. > >Sure, but it is more work, and the programmer must remember to do so in >each new proyect. In all other Database systems, when you flag a field as >being unique, the underlying database makes sure it is unique.The SKU value doesn't have to be unique unless the particular situation calls for it. In fact, there doesn't even have to be a field named SKU unless the particular situation calls for it.In WebCatalog, having a field with a unique value is entirely up to the programmer, it's not something that's forced on the programmer by the software and it is definitely not a requirement of the software. In other words, WebCatalog is a lot more flexible than the database software you're used to.Many of my db's don't need SKU fields or unique record identifiers, so I don't even bother to create them ... :)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:
Applying discounts as more items are added... (1997)
PIXO (1997)
Problems with ^ could be solved with [REPLACE CHARACTERS] (1997)
Addlineitems ... grrr (2004)
Setting up emailer (1998)
mem leak: webcat (2001)
40,000+ items = mutiple dbs? (1999)
Not reading blanks (1998)
Any problem with using a g4 with WebCat (2000)
Tags not being Interpreted-Resending (1999)
Weird Math and SV (1997)
errormessages.db (1997)
Shipcost Based on SubTotal (1998)
Mail Service Dead (1998)
More Shopping Cart Problems (2000)
Unix Webcat Permission - Suggestions (2000)
A note for NT4 users (1998)
Need formatting help (1998)
WebTen and WebCat (1997)
success - serial numbers and webmerch (1997)