IDispatch error #3127
Database
1
Posts
1
Posters
0
Views
1
Watching
-
I am using ADO and have the following queries in my database Query: GetPW SELECT [PW].[Number], [PW].[Status] FROM PW WHERE [PW].[id]=CCID; Query: GetPR SELECT [PR].[Number], [PR].[Status] FROM PR WHERE [PR].[id]=CCID; Query: GetPWPR PARAMETERS CCID Long; SELECT * FROM GetPW LEFT JOIN GetPR ON [GetPW].[Number]=[GetPR].[Number] ORDER BY [GetPW].[Number]; When I execute query "GetPWPR" from within access, It works fine. (ie Prompts for CCID input value and returns records from PR and PW as expected) However when I execute using ADO::Execute command it fails with the error "IDispatch error #3127" (DB_E_NOTABLE) Any clues ? Thanks