I have linked into out financial database which is a progress database. All has been working fine except for working with dates.
I quite simply want to select all the rows where the date is greater than a specified date.
I have tried the following and none work
SELECT * FROM chart
WHERE DateUpd > "08/10/2002"
SELECT * FROM chart
WHERE DateUpd > '08/10/2002'
SELECT * FROM chart
WHERE DateUpd > "08/10/02"
SELECT * FROM chart
WHERE DateUpd > '08/10/02'
I am linking to the database from SQL server using the Merant Progress Dirver. I get the folowing error each time I try to run the query.
Server: Msg 7321, Level 16, State 2, Line 1
An error occurred while preparing a query for execution against OLE DB provider 'MSDASQL'.
To execute the SQL I am using the OPENQUERY method
i.e.
SELECT * FROM OPENQUERY(DATABASE1,'SELECT * FROM table1
WHERE DateUpd > "08/10/2002"')
Any help here would be greatly appriciated
Thanks,
Luke
I quite simply want to select all the rows where the date is greater than a specified date.
I have tried the following and none work
SELECT * FROM chart
WHERE DateUpd > "08/10/2002"
SELECT * FROM chart
WHERE DateUpd > '08/10/2002'
SELECT * FROM chart
WHERE DateUpd > "08/10/02"
SELECT * FROM chart
WHERE DateUpd > '08/10/02'
I am linking to the database from SQL server using the Merant Progress Dirver. I get the folowing error each time I try to run the query.
Server: Msg 7321, Level 16, State 2, Line 1
An error occurred while preparing a query for execution against OLE DB provider 'MSDASQL'.
To execute the SQL I am using the OPENQUERY method
i.e.
SELECT * FROM OPENQUERY(DATABASE1,'SELECT * FROM table1
WHERE DateUpd > "08/10/2002"')
Any help here would be greatly appriciated
Thanks,
Luke