Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations Chriss Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

error using the Query Builder

Status
Not open for further replies.

henky

Programmer
Jul 20, 2000
56
NL
Hi,

I am not sure if I am doing something wrong or if it is a bug but, I can not seem to parse a SQL querie in the DTS Wizard.

I get the following message.

"Unexpected Error occured.The provider has returned an Error result without an Error message".

The syntax is:
select "Aanw"."Filiaal_nr", "Aanw"."Gebr_kd", "Aanw"."Datum", "Aanw"."Volg_nr", "Aanw"."Status_kd", "Aanw"."Begin_td", "Aanw"."Eind_td", "Aanw"."Ltst_update_ts"
from "Aanw"


Can anyone maybe help with a suggestion?
Thanks
 
Hi,

try and remove the double quotes.

If they are part of the tablenames and fieldnames write them as follows:

select ["Aanw"].["Filiaal_nr"],["......
from ["Aanw"]

Groeten,

Atomic Wedgie


 
Here two screenshots of my situation.

1querybuilder.JPG

2error_message.JPG


I just tried the option AtomicWedgie gave me, but it won't work, even whitout the quotes, it won't work.

Could the empty field create the troubles, near to the db-logo (cilinder)??
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top