Hi,
Im trying to do a select of a logical field but nothings works... let's say field1 is my logical field.
I tried these selects...
But none is working... what should be the syntax to select a boolean field when = true
Im trying to do a select of a logical field but nothings works... let's say field1 is my logical field.
I tried these selects...
Code:
SELEC *
FROM MYTABLE
WHERE FIELD1
INTO QMYCURSOR
SELEC *
FROM MYTABLE
WHERE FIELD1 = 1
INTO QMYCURSOR
SELEC *
FROM MYTABLE
WHERE FIELD1 = .T.
INTO QMYCURSOR
SELEC *
FROM MYTABLE
WHERE FIELD1 = TRUE
INTO QMYCURSOR
But none is working... what should be the syntax to select a boolean field when = true