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, youmust check the unique value BEFORE you save the record - means, you mustprogrammatically 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 dowith few lines of code, and for any fieldname you want. Second, you oftenwant to search for two fields, which have to be unique if they are both inone record - user AND password for example. Here one single reservedfieldname is not enough...No, the feature was worth to think about, but the possible solutions gostraight against WebCat's flexibility which I like most (beside the speed).Peter__________________________________________Peter Ostry - po@ostry.com - www.ostry.comOstry & Partner - Ostry Internet SolutionsAuhofstrasse 29 A-1130 Vienna Austriafon ++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, youmust check the unique value BEFORE you save the record - means, you mustprogrammatically 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 dowith few lines of code, and for any fieldname you want. Second, you oftenwant to search for two fields, which have to be unique if they are both inone record - user AND password for example. Here one single reservedfieldname is not enough...No, the feature was worth to think about, but the possible solutions gostraight against WebCat's flexibility which I like most (beside the speed).Peter__________________________________________Peter Ostry - po@ostry.com - www.ostry.comOstry & Partner - Ostry Internet SolutionsAuhofstrasse 29 A-1130 Vienna Austriafon ++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:
autosensing lanague selection (1997)
Off Topic: Frames Killer? (1998)
WebCatalog Mac 2.1b3 (1997)
OFF-TOPIC: No messages since Saturday (1998)
Handy Browser Counter Tip (1997)
WebCatalog as a ListServ (1998)
Webstar 1.3.1 PPC (1997)
Mult-File Upload w/ Web Star (2000)
Duplicate Hell (1999)
Mail Service Dead (1998)
RE: [isfolder] and [filename] (1997)
Protect and Serve (1999)
Using Plug-In while running 1.6.1 (1997)
RE: New WebCatalog Version !!! (1997)
[WebDNA] WebDNA crash and now emailer not working (2010)
WC2b15 File Corruption (1997)
Field lenght (1998)
Do .tpls A Max File Size? (1998)
Database Options (1997)
answers - opinions? (1998)