Thread Rating:
  • 0 Vote(s) - 0 Average
  • 1
  • 2
  • 3
  • 4
  • 5
SQL WHETHER clause with date
#1
Gintaras,

Let me first congratulate you regarding - among numerous other - for the SQL interface.

Regarding the Database Help, could you please give an additional example of the WHERE clause, if the column implied is a date, or more precisely a short date of the type 17-04-2014.

Many thanks.
#2
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]
#3
Thank you very much!


Forum Jump:


Users browsing this thread: 1 Guest(s)