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