How to select Visual FoxPro logical field from ASP.NET

[megkhp]

I'm writing an ASP.NET application that connecting to Visual FoxPro database, I want to select a logical field "IsActive" equals to ".T." from the "Customer.dbf", I've tried the following but they don't work:

"SELECT * Customer WHERE IsActive=.T."
"SELECT * Customer WHERE IsActive=TRUE"
"SELECT * Customer WHERE IsActive='TRUE'"

Does anyone know the solution? Thanks!

 

[rgbean]

Try:

SELECT * [red]FROM[/red] Customer WHERE IsActive

A logical value doesn't need an additional comparison, although the first example should work with the [red]FROM[/red] added.

Rick

 

[ToddWW]

I have to use the following when calling a logical field through ADO.

SELECT Table.Field FROM Table WHERE LogicalField = 1

Using 1 for True and 0 for false.

ToddWW