johnp Posted January 1, 2013 Posted January 1, 2013 For some reason I am not able to display any query results on a grid or db labels even using simple strings such as SELECT * FROM ORDERS. I am able to connect my data sources to tables and get data from any table, but not a query. I do not get any error from trying to run my queries, just no results. Is there something special that need to be done with queries? John BTY Happy New Year to all. May 2013 be a good year for you. Quote
mierlp Posted January 1, 2013 Posted January 1, 2013 Hi John Well...for tables and queries it's basicly the same. I don't know which components you are using but often you need a Connection component where you can enter the: - usernamae - password - database - host A query component is connected to the connection component A datasource component has a link to a dataset (query component) First make the connection component ACTIVE Second maken the query componant ACTIVE Right click on a query component and use the Field Editor to add the database fields so you can choose them in a dbgrid. Regards Peter Quote
johnp Posted January 3, 2013 Author Posted January 3, 2013 Thanks for your reply. I overlooked something very simple and had my query pointing to the wrong table. The error was on my part. John Quote
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.