Re: Getting the DATA TYPE from syscolumns: An article with sample code attached

In article <47k5cc$2jc6@news.gate.net>, tschaefe@gate.net says... >I hope these programs are of benefit to you. I look forward to your comments >and suggestions for improvement. Maybe you'll optimize the code into something >better and share it here. Keep in mind while not perfect, this does offer you >an alternative to using the 4GL. It appears that this code doesn't handle synonymns; what does Informix 7.x do with synonyms? Informix 5.x has two cases: where syssyntable.btabid points to a different table in the same database, and then there's the more complicated case where the table exists on a different database, or a different server entirely. -- William Harris william@carsinfo.com CARS Information Systems 4000 Executive Park Drive Cincinnati, OH (USA) 45241