Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Inserting date into sql or firebird;What is .t. value in
Message
From
18/09/2005 06:20:19
Dorin Vasilescu
ALL Trans Romania
Arad, Romania
 
 
To
17/09/2005 08:07:43
General information
Forum:
Visual FoxPro
Category:
Client/server
Miscellaneous
Thread ID:
01050571
Message ID:
01050692
Views:
9
Hi

>VFP: {01/01/2005}
>MSSQL: '01/01/2005' ?
>FIREBIRD: ?

'2005-01-01', or '2005/01/01' . Firebird will automatically cast to date type.

>or logical 'true' representation such as
>VFP: .t.
>MSSQL: ?
>FIREBIRD:?

Firebird hasn't boolean type (will be in 2.0 verion, currently in beta
You can use SMALLINT type with CHECK IN(0,1)
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform