Icon View Thread

The following is the text of the current message along with any replies.
Messages 1 to 3 of 3 total
Thread ftFixedChar, ftString
Thu, Feb 22 2007 8:37 AMPermanent Link

Thad
I wanted to create a utility that would iterate through a directory of DBISAM tables, read the structure of the table, its indexes, etc, and then create create table sql off of the table
structures. Some of the tables have the fixedcharacter as the type, and there is a type ftFixedChar, but when I check the table.fields[i].datatype for the fixedchar, it says its a ftString. If I
created sql off of this, and made the field type in the sql based off of what came in, the ftString, it would not be what the field type actually is in the table, if I recreated it with that sql I
created based on the structure of the table.fields.datatypes (size, etc) Does anyone know why it doesn't show the datatype as ftFixecChar, instead of ftString?
Thu, Feb 22 2007 10:12 AMPermanent Link

Roy Lambert

NLH Associates

Team Elevate Team Elevate

Thad


The best thing to do is look at the reverse engineer source in DBSys which does exactly what you're trying to do.

Roy Lambert
Fri, Feb 23 2007 1:10 PMPermanent Link

Thad
Roy Lambert <roy.lambert@skynet.co.uk> wrote:

Thad


The best thing to do is look at the reverse engineer source in DBSys which does exactly what you're trying to do.

Roy Lambert


You know what, I actually found in the help where it said that off of the fielddefs there is a property for FixecChar, but the whole problem all along was that I was iterating off of the
table.fields collection, and not the fielddefs collection. It did it correctly off of the fielddefs collection. But I shoudl still check out the code you're talking about, thanks.
Image