Reasonable Error Handling: Web App

[FrankR]

I'm taking a second look at the excellent Total Web Apps videos.
[Highly recommended]

Here is a very simple code clip for adding a record to a table.

t = table.open("member_sw")
t.enter_begin()
    t.Firstname = alltrim(CurrentForm.Controls.vFirstname.value)
    t.Lastname = alltrim(CurrentForm.Controls.vLastname.value)
    t.Company = alltrim(CurrentForm.Controls.vCompany.value)
    t.State = ut(CurrentForm.Controls.vState.value)
t.enter_end(.t.)
t.close()

Anyone willing to offer a comparable clip - with reasonable, sufficient error checking added? Thanks.

[Steve Wood]

Re: Reasonable Error Handling: Web App

What do you mean by error checking?

There is no unique ID in this record, so you cannot test to see if the record already exists. What other error checking would there be?

Typically no other error checking would go in this script. If you want to allow/exclude particular data in each individual field, you do that in the dialog's Validate event.

[FrankR]

Re: Reasonable Error Handling: Web App

- Checking that the table opened successfully
- If not, getting at the text of that error
- Check that the table insert was successful
- If not, getting at the text of that error
- Displaying that info on the page
etc. etc.

[Steve Wood]

Re: Reasonable Error Handling: Web App

I've never seen anyone include such error checking in any example script. There are many place where you CANNOT do this testing because the table is being opened in a function, like lookup().

But in script you can test that the dbf file exists before you attempt to open with file.exist() function. After you open the table, you can test that it is open with the table.isopen() function. Search for "ON ERROR" in the help, that creates an environment to control the script if there are any errors. To test that the record was inserted, you would include code in your script to test if that record exists, such as the exist() function, but you will need a unique value to use that particular function. You can display the results also by finding the record, and displaying it on the screen or with functions such as table.external_record_content_get().