>I have to set up a remote view with a parameterized datetime field...
>
>Question 1 - After selecting the paydate (datetime) field in the selection criteria and selecting equals.... what do I type in for the EXAMPLE... I can't seem to get this right without getting an error (column not found - or else incorrect month).
>
>Question 2 - For a datetime range (between a lower date and an ending date), what would the example be?
>
>Thanks for the help....
>
>Tommy
Tommy,
I don't use Oracle but it should be same as in SQL server :
SQLExec(handle,"select * from myTable"+;
" where myDate = ?thisform.txtPayDate.Value",'Result')
SQLExec(handle,"select * from myTable"+;
" where myDate between "+;
"?thisform.txtStartDate.Value and ?thisform.txtEndDate.Value", 'Result')
Cetin