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:

    
  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)
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:

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)