>I am trying to talk to an Access backend. I know that the data that I am trying to use as a filter criteria is an Access datetime type and I know that I have to use "access-speak", but I don't know how to do this.
>
>Example: arcview is the ODBC connection to the Access database and Agent_Details_001 is the Access table. I store the date that I want to extract in this.startdate.
>
>CREATE SQL VIEW Temp_Agent_details CONNECTION arcview AS ;
> SELECT *;
> FROM Agent_Details_001 ;
> WHERE TTOD(temp_agent_details.datetime) = ?this.startdate
>
>
>How can I make this work?
>
>Thanks for your help.
Edward,
CREATE SQL VIEW Temp_Agent_details CONNECTION arcview AS ;
SELECT *;
FROM Agent_Details_001 ;
WHERE Agent_Details_001.datetime = ?this.startdate
However I think this would be better (not based on an object's existence) - thinking you need to create this once :
CREATE SQL VIEW Temp_Agent_details CONNECTION arcview AS ;
SELECT *;
FROM Agent_Details_001 ;
WHERE Agent_Details_001.datetime = ?dStartDate
Then you could use it like this :
dStartDate = {^2003/02/25}
use myDBC!Temp_Agent_details
dStartDate = {^2003/01/14}
requery('Temp_Agent_details')
Cetin