Pass through from informix

[Guest]

Hi there,

How can i link the criteria in a pass-through query to a form?

This query works fine if i replace A and B with the proper dates.

SELECT currency, fdate, rate
FROM tRates
WHERE fdate between A and B

I need to link A and B with the fields date1 and date2 in getrates form.

Should i go for VB code only, and forget about the query? In this case
what's the script for a pass through?

I'm using Access 2002 to get values from an informix database.

Thanks,
Cabaco

 

[Duane Hookom]

You can set a reference to MS DAO and use code like:

Dim strSQL as String
strSQL = "SELECT currency..." & _
" FROM tRates " & _
"WHERE fdate Between " & Me.txtStart & " And " & Me.txtEnd
'not sure what the delimiter for dates is in informix...
Currentdb.QueryDefs("qsptYours").SQL = strSQL

 

[Guest]

Thanks Duane, that solves it.
Finally a good night sleep...
Cabaco