I am using Delphi with the Pervasive PDAC to access a Btrieve database (originally a Btrieve 6 database with updated ddf files for Pervasive 7) with SQL 2000i. Boolean data files show up as string fields of length 1 in Delphi which are hard to work with in data aware controls. For example database check boxes won't recognize any string I use for True values and attempting to retrieve or set data from or to the Boolean field wants to use 2 bytes of data. Has anyone found a good way to work with these fields in Delphi?
Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations Chris Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Pervasive boolean fields in PDAC
- Thread starter Fleabit
- Start date
You may have to use an intermediate control - I've never used delphi but have used VB and the way I'd do it would be something like having an invisible text box that would have the value from pervasive - I would then set the checkbox to true or false depending on the value of the textbox and if I were to change the value of the checkbox I'd have some code in there to ensure that the value of the invisible textbox changes accordingly. Not pretty I grant you...
Best of luck,
Tom
Best of luck,
Tom
- Status
Similar threads
- Locked
- Question