OpenEuphoria

EUSQL UPDATE Query (I can't figure out why this isn't working)

• Posted by robby1066 <robby1066 at hotmail.com> Aug 02, 2004
• 575 views

Hi there, I'm working on a win32lib application that uses an EUSQL database. It
seems like everything is working correcly until I run an update query to change
an already existing record.

After trying to narrow down the problem (I'm not getting an error message, just
a silent failure), I determined that I can use and update query on a single
field, but not on multiple fields for the row selected in the where clause.

Basically for a table called DOCBANK that has the following structure:

KEY as Autonumber
TITLE as Text
DESC as Text

I can get these statements to work:
run_sql("UPDATE DOCBANK SET DOCBANK.TITLE = 'NEW TITLE' WHERE (KEY = 16)")
and 
run_sql("UPDATE DOCBANK SET DOCBANK.DESC = 'UPDATED DESCRIPTION' WHERE (KEY =
16)")

But this won't work:
run_sql("UPDATE DOCBANK SET DOCBANK.TITLE = 'NEW TITLE', DOCBANK.DESC = 'UPDATED
DESCRIPTION' WHERE (KEY = 16)")

Again, no error message, just the first field updates, and not the second. 
I've used SQL before in some php apps, and I'm PRETTY sure that my sql is
correct, but I could be wrong. I just wanted to make sure there wasn't something
I had missed in the documentation about EUSQL.