Hi all,
I'm trying to run a sql statement using ODBC through a VBA.  The Database on
the 400 has a Numeric field defined 8.0p(used as a date field).
i've created a SQL statement that lets me select records from the file,
however, when i try to condition the select based on the date field i get
cryptic errors.

ideally i'm trying to select the data based on the current date.  However,
since i couldn't get that to work, i thought i would just try DATEFIELD > 0,
that doesn't work either.

Here is my select statement.
  SQLstr = "create view DISPATCH_V as select * from UFDB,UFDBS,UCSRFD where
PZBSB = P1BSB and P1MTR = PWMTR and PZBSB > 0"

can someone tell me what i might be doing wrong.
also if i want to change the sql to PZBSB = Curdate(where curdate is a
variable) is there anything special about doing that.

Thanks

Mike


As an Amazon Associate we earn from qualifying purchases.

This thread ...

Follow-Ups:

Follow On AppleNews
Return to Archive home page | Return to MIDRANGE.COM home page

This mailing list archive is Copyright 1997-2022 by midrange.com and David Gibbs as a compilation work. Use of the archive is restricted to research of a business or technical nature. Any other uses are prohibited. Full details are available on our policy page. If you have questions about this, please contact [javascript protected email address].

Operating expenses for this site are earned using the Amazon Associate program and Google Adsense.