Everett Ward Systems Technical Support Bulletin #1

Everett Ward Systems Technical Support

Bulletin #: 1
Date : 11/11/98
Product : ObjGen 1.1 for Visual Basic
Subject : Formatting issues with SQL bit fields and Access Yes/No fields using ADO

Status: Fixed in ObjGen 1.1 Release A

The data formatting function SQLFormatBitVal( ) which is generated as one the default application utility functions expects string data returned by the Visual Basic data access libraries to be either a 'T' or 'F' (stored by the database as either a 1 or 0 respectively). This behavior is true for all versions of DAO and RDO used by Visual Basic 5.0 and 6.0.

However, we have found that both ADO 1.X and 2.X returns the full strings 'True' & 'False' for data stored as 1 and 0 respectively if the column is defined as a bit data type or as a Yes/No field in Microsoft Access. This results in code generated by ObjGen to improperly evaluate a value of 'False' as a value of 'True'. Applications generated by ObjGen 1.1 that use DAO or RDO are not affected by this problem.

We recommend that you replace the standard code for SQLFormatBitVal( ) in modData.bas for all applications generated by ObjGen 1.1, with the following code:

We expect to release a product update for ObjGen 1.1 in late November 1998 that addresses this issue. The update will be free of charge to all registered users of ObjGen versions 1.0 & 1.1.

Please send all questions and inquiries via e-mail to information@ewsystems.com