Jump to content

Query data


johnp
 Share

Recommended Posts

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.

Link to comment
Share on other sites

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

Link to comment
Share on other sites

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.

Guest
Reply to this topic...

×   Pasted as rich text.   Paste as plain text instead

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

 Share

×
×
  • Create New...