SQL WHETHER clause with date

[Gintaras]

Macro Macro2496

Code:

Copy      Help

Database db.Open(db.CsAccess("$documents$\db1.mdb"))
ARRAY(str) a; int r c
db.QueryArr("SELECT D FROM tab WHERE D >= #2014-01-01#" a)
for r 0 a.len(2)
,out "-- Record %i --" r+1
,for c 0 a.len(1)
,,out a[c r]