jordan@cs.columbia.edu (Jordan Hayes) (03/29/89)
In the SYSTYPES table, there are two indicators of the type of an object: columns "type" and "usertype" ... you can get the "type" value using dbcoltype(), but there's no function for the "usertype" column. I looked in the DBPROCESS structure and found the DBCOLINFO structure, and tracked down a field called coludtype, and sure as anything, it has what i'm looking for. Except sometimes. It seems that when the current SELECT explicitly names the columns i'm looking for (as in "select bar from foo_t where id = 12"), the value is the one I would expect. When it's not explicit (as in "select * from foo_t where id = 12"), I get back "correct" answers, but not the ones I was expecting. Inspecting the SYSCOLUMNS table by hand shows the answers i'm looking for, but the value in the DBCOLINFO is not what you find in SYSCOLUMNS. Am I mistaken in believing that if dbcoltype gets filled in from the "type" column of SYSCOLUMNS, so dbcoludtype would as well? Is this a bug? Jordan Hayes Citibank, NA