Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
CursorAdap & Logical Fields
Message
From
05/05/2004 01:43:04
Dorin Vasilescu
ALL Trans Romania
Arad, Romania
 
General information
Forum:
Visual FoxPro
Category:
Other
Miscellaneous
Thread ID:
00900858
Message ID:
00901084
Views:
22
The same with me, but regarding Firebird database.
I converted logical from .T./.F. to 0/1 and that was all. Because I was using mostly checkboxes to edit those fields, was somehow easy.

>The database is DB2 on an AS/400 and it has a smallint (-32,000 to 32,000 range Integer) but no BIT or Logical type.
>
>
>>
>>I am working on a conversion to a backend database where I have to store 0/1 to represent .F./.T.
>>

>>
>>Stored field data type ?
>>If MS SQL -> use BIT data type
>>
>>Backend Name ?
>>
>>If MS SQL
>>in SELECT command use
>>CONVERT(BIT,Backendfield)
>>or
>>CAST Backendfield AS BIT
Previous
Reply
Map
View

Click here to load this message in the networking platform