Re: trouble updating records in database
This WebDNA talk-list message is from 1998
It keeps the original formatting.
numero = 19070
interpreted = N
texte = At 17:09 Uhr 24.07.1998, Charles Kefauver wrote:>> (4D)...if you flag a field >>as unique then an error message will pop up to warn the user. Fine for a >>dedicated database client, but if you do not catch this situation in your >>web-application, the popup would be shown on the webserver! > >Not really, it can be handled just like required form fields: you get an >error page stating the problem, and the user just has to click the back >button and reenter the data. No need to popup anything on the server.This is exactly the point: If you do not want the error message of 4D, you must check the unique value BEFORE you save the record - means, you must programmatically disable this automatic feature. Makes no sense...>How about making SKU unique, and if you don't want to make it unigue, >don't call it SKU...In this case I believe WebCat has to do a lookup - which you can also do with few lines of code, and for any fieldname you want. Second, you often want to search for two fields, which have to be unique if they are both in one record - user AND password for example. Here one single reserved fieldname is not enough... No, the feature was worth to think about, but the possible solutions go straight against WebCat's flexibility which I like most (beside the speed). Peter__________________________________________ Peter Ostry - po@ostry.com - www.ostry.com Ostry & Partner - Ostry Internet Solutions Auhofstrasse 29 A-1130 Vienna Austria fon ++43-1-8777454 fax ++43-1-8777454-21
Associated Messages, from the most recent to the oldest:
At 17:09 Uhr 24.07.1998, Charles Kefauver wrote:>> (4D)...if you flag a field >>as unique then an error message will pop up to warn the user. Fine for a >>dedicated database client, but if you do not catch this situation in your >>web-application, the popup would be shown on the webserver! > >Not really, it can be handled just like required form fields: you get an >error page stating the problem, and the user just has to click the back >button and reenter the data. No need to popup anything on the server.This is exactly the point: If you do not want the error message of 4D, you must check the unique value BEFORE you save the record - means, you must programmatically disable this automatic feature. Makes no sense...>How about making SKU unique, and if you don't want to make it unigue, >don't call it SKU...In this case I believe WebCat has to do a lookup - which you can also do with few lines of code, and for any fieldname you want. Second, you often want to search for two fields, which have to be unique if they are both in one record - user AND password for example. Here one single reserved fieldname is not enough... No, the feature was worth to think about, but the possible solutions go straight against WebCat's flexibility which I like most (beside the speed). Peter__________________________________________ Peter Ostry - po@ostry.com - www.ostry.com Ostry & Partner - Ostry Internet Solutions Auhofstrasse 29 A-1130 Vienna Austria fon ++43-1-8777454 fax ++43-1-8777454-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:
shownext (1997)
[WebDNA] Authentication across domains (2009)
Problems passing [SKU] with $Replace in 2.0 (1997)
WebMerchant 3.0 for Mac shipping now (1998)
[isfile] ? (1997)
Mac: LModelDirector bug fix (1997)
Nesting format tags (1997)
RE: WebCat and image maps (1997)
Interfacing WebMerchant to www.fedex.com (1997)
math on date? (1997)
Hiding words (2000)
Re:What file? (1997)
NTbeta18 corrupted? (1997)
Help with database strategy (1998)
[WebDNA] An unknown error occured // Deadlock avoided (2011)
disappearing SKU (etc.) fields (1998)
WebCat2b12plugin - [search] is broken ... not! (1997)
French Webcat User (2002)
TeaRoom (1997)
Snake Bites (1997)