Help with GetUpdateSQL in ADOdb

[hsceeus]

i'am using the ADOdb to did the select, insert, and update function.
but i have some question of using the GetUpdateSQL in ADOdb.

For example, i have a form that can edit the user profile that content name, address, and tel no. fields with the edit button at the bottom of the form.

1st: if i edit the name field and then click the edit button, the GetUpdateSQL in ADOdb can perform the update properly.

2nd: if i didn't modified any of the fields in the form, when i click the edit buuton, a error message displayed: *Query was empty*

Can anyone explain to me why and how to solve this problem?

[jatar_k]

my guess is that you aren't testing whether the value has changed or whether it's empty or some other such test

take a look at the query that is returning the error.

[hsceeus]

the problem is not there. i just want to know is there any setting in the ADOdb library there, that can allow NULL string when perform update

[coopster]

I think jatar_k's point is that you may want to be doing your data editing prior to attempting the query. This will allow you to give proper error messages to your user as well.