![]() | ![]() Products ![]() ![]() ![]() ![]() |
Home » Technical Support » DBISAM Technical Support » Support Forums » DBISAM General » View Thread |
Messages 1 to 3 of 3 total |
![]() |
Thu, Feb 22 2007 8:37 AM | Permanent 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 AM | Permanent Link |
Roy Lambert NLH Associates ![]() | 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 PM | Permanent 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. |
This web page was last updated on Wednesday, August 14, 2024 at 07:31 PM | Privacy Policy![]() © 2024 Elevate Software, Inc. All Rights Reserved Questions or comments ? ![]() |