Cannot insert in the logical fields using SQL

[countdrak]

I am trying using a coldfusion page to insert values into my Foxpro DB.

I have three types of data
Numeric
Character
Logical

I can see F and T in my logical fields in my foxpro table. But for some reason I cant insert 'F' and 'T' using SQL INSERT statment. I tried everything '.T.' '.F.' , 'True','False'.

Nothing works. I just need to insert F and T in the logical fields. How would I write a SQL Statment. Thanks.

 

[Stella740pl]

Did you try to drop the apostrophies around the .t. and .f. or .T. and .F, and use just that, the letter delimited by dots? Should do it.

 

[bborissov]

You could try to insert:
(1=0) for .f.
(1=1) for .t.
But if you post the whole statement here it will be easier to answer

Borislav Borissov
VFP9 SP1, SQL Server 2000/2005.

 

[countdrak]

INSERT INTO EmpInfo(ENUM,CATACALTYP,WAITDATEA,WAITDATEB)
VALUES(210,'C','T','T')

This is what I was trying. The last two fields are type Logical. And the first field is numeric and second a character.

Thank you guys.

 

[jimstarr]

As Stella says:

INSERT INTO ....... VALUES(210,'C',.T.,.T.)

Jim

 

[Mike Lewis]

I think Jim's right. Just insert .T. and .F.. VFP will take care of the translation.

Mike

__________________________________
Mike Lewis (Edinburgh, Scotland)

My Visual FoxPro site: www.ml-consult.co.uk

 

[countdrak]

IT worked thanks!