I get a blank Select Error message... please help

[richard9]

I am getting a message when retrieving in Pb, its fine in the dev db, just since updating the live db, i get the message "Datawindow Error : Select Error:" and thats it. I cant find any errors in the code or data, and the sql runs fine in Oracle. Has anyone any suggestions ? thanks

 

[mbalent]

Put a messagebox in the sqlpreview event of the datawindow and check the syntax of the sql statement issued by PB to the database (its the sqlsyntax parameter in the event).

Matt

"Nature forges everything on the anvil of time