SELECT statment in 4.1

Hi,

why in jBase 4.1 in SELECT statement for = operation I HAVE to include
the value in quotes, but for >= or <= it's not necesary ?

For ex:
SELECT FBNK.STMT.VAL.ENTRY WITH (VALUE.DATE >= 20050401 AND VALUE.DATE
LE 20050601) AND (ACCOUNT.NUMBER = 32678)
gives me error: Parse Error: 32678

but

SELECT FBNK.STMT.VAL.ENTRY WITH (VALUE.DATE >= 20050401 AND VALUE.DATE
<= 20050601) AND (ACCOUNT.NUMBER = '32678')

runs OK ?
_________________
NJOY LIFE TO THE FULLEST

The SELECT statement in jBASE4.1 is not much flexible as in jBASE4.0.

But in terms of performance 4.1 is best compared to lower versions.

Some points for better performance.

1. While giving condition always give the field name.
2. Always cover the field value with single/double quotes.
3. Use appropriate brackets.

Still many more are there.
_________________
M A L A I

Hi,

One more new to add.

SELECT MY.FILE WITH @ID LIKE ...HELLO...

id equal to

SELECT MY.FILE WITH @ID EQ [HELLO]

Can any one try and find, is there any performance improvement?
_________________
King Arthur

Hi

Using EQ [HELLO] is more faster than LK ...HELLO...
_________________
M A L A I

your select statement needs to have the quotes and a typical statement can be
SELECT FBNK.WHATEVER WITH CATEGORY EQ '01' 03' '04' '05'
_________________
takoor