Re: trouble updating records in database
This WebDNA talk-list message is from 1998
It keeps the original formatting.
numero = 19045
interpreted = N
texte = >>Do you have any SKUs that are identical to others in the database? This is>>illegal, and can cause the database admin templates to be unable to update>>that record.>>May I suggest that this is a problem with WebCat. The [Append] command>should fail if the SKU already exists, that is the way all other>databases work (FileMaker, SQL, etc).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.By the way, if you use [cart] to create your SKU values, you will never have to worry about this problem anyways ... so no matter what other record numbering or tracking scheme you decide to implement, you should still be using [cart] to create a new unique SKU value for each new record.Sincerely,Ken Grome808-737-6499WebDNA Solutionsmailto:ken@webdna.nethttp://www.webdna.net
Associated Messages, from the most recent to the oldest:
>>Do you have any SKUs that are identical to others in the database? This is>>illegal, and can cause the database admin templates to be unable to update>>that record.>>May I suggest that this is a problem with WebCat. The
[append] command>should fail if the SKU already exists, that is the way all other>databases work (FileMaker, SQL, etc).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.By the way, if you use
[cart] to create your SKU values, you will never have to worry about this problem anyways ... so no matter what other record numbering or tracking scheme you decide to implement, you should still be using
[cart] to create a new unique SKU value for each new record.Sincerely,Ken Grome808-737-6499WebDNA Solutionsmailto:ken@webdna.nethttp://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:
4.5.1 upgrade fee (2003)
[protect admin] (1997)
Okay, I give up... (1999)
Bug? (1997)
Chat (2000)
WebCat2b15MacPlugin - [protect] (1997)
Live server problems (1999)
encryption madness (2003)
Merging databases (1997)
cart limit (2002)
WebCat and WebTV (1997)
[WebDNA] Installing 6.0 onto Server 2008 (2011)
MySQL UPDATE (2007)
Random Images (2000)
E-mail Attachments (1997)
Pull Down Search (2000)
No answers by SM? (2000)
[SHOWIF AND/OR] (1997)
WebCat2b13MacPlugIn - [showif][search][/showif] (1997)
can you see what is wrong here? (2002)