Buy Support
Incidents |
If you can't find your answer
in the FREE PUBLIC QDeveloper Forum, require URGENT Priority Support, or you need to send us
private or confidential information: |
Click Here
|
If you can't
login and post questions or you are having trouble viewing forum posts:
Click Here
|
Callback
Support |
If you live in USA, UK, Canada, Australia or New
Zealand, you can leave us details on your question and request us to call you back and discuss
them with you personally (charges apply). |
Click Here
|
Buy Support
Incidents |
If you can't find your answer
in the FREE PUBLIC QDeveloper Forum, require URGENT Priority Support, or you need to send us
private or confidential information: |
Click Here
|
|
Query Syntax |
Author |
Message |
|
Posted : 2009-01-16 07:54:57 |
I am writing an application that connects to a qodbc via the proxy dbtcp. The biggest issue that I am trying to over come is not the connection, but trying to query against the server.
Right now, what I am trying to accomplish is getting a data set returned that holds all tables for a particular company file. Normally I would use something like this show tables and I would have a list of all the tables that I need to work with. However it appears that this is not a valid sql satement when connected to qodbc.
The second issue that I am having is trying to limit the number of returns I would get back from a particular query. Normally I would something like this. Top 10 select * from xtable or select * from xtable limit 10.
Is there any kind of reference material I can look at to find the valid syntax for both of these types of queries? |
|
|
|
Tom |
|
Group | : Administrator |
Posts | : 5510 |
Joined | : 2006-02-17 |
|
Profile |
|
Posted : 2009-01-16 10:12:49 |
|
|
|
|