elliot@alfred.UUCP (Elliot Dierksen) (12/16/89)
I discovered what I believe to be a bug in Informix-SQL today. It seems that
when you have a preapred update statement, and your execute that statement
more than once, the element in the sqlca structure that is supposed (!!!) to
contain the number of rows processed gets a little messed up.
I had a prepared update statement as follows
update table_name set field_name = ? where rowid = ?
Imagine my surprise when I was told 2 rows updated!!! This doesn't seem to
happen when some other SQL statement gets run in the mean time. Even setting
the sqlca element to 0 doesn't correct the problem... Any hints/suggestions
out there??
P.S. I happen to like Informix products a lot, how about being able to
define structure/record types that aren't database files in the next
release... Please???
--
Elliot Dierksen Home: {peora,ucf-cs,uunet}!tarpit!alfred!elliot
Work: {att,codas}!candi!ralph!ebd
"What's another word for Thesaurus??" -- Steven Wright