How to select Visual FoxPro logical field from ASP.NET

[megkhp]

Hi!

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!

 

[DaZZleD]

try
SELECT * Customer WHERE IsActive=1

--------------------------
"two wrongs don't make a right, but three lefts do" - the unknown sage

 

[dragonwell]

It might be either 0 or -1. I can't remember which is on and which is off.