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
|
|
VB Demo not returning results for some tables |
Author |
Message |
Paul |
|
Group | : Members |
Posts | : 2 |
Joined | : 2007-10-12 |
|
Profile |
|
Posted : 2008-11-25 08:46:26 |
I'm using the VB Demo that ships with QODBC and some tables (like Account, for instance) don't return any records. Many of the other tables return results just fine (including references to Account records). Is there something else I need to do to get access to these records?
The SQL statement I'm using is SELECT * FROM Account.
It returns the Field names across the top, but no records.
Thanks! |
|
|
|
Tom |
|
Group | : Administrator |
Posts | : 5510 |
Joined | : 2006-02-17 |
|
Profile |
|
Posted : 2008-11-25 17:01:35 |
Some users kill queries while they are still running and corrupt their optimized tables. Run:
SELECT * FROM Account VERIFY
to force a rebuild of the optimized table.
|
|
|
|
Paul |
|
Group | : Members |
Posts | : 2 |
Joined | : 2007-10-12 |
|
Profile |
|
Posted : 2008-11-26 07:43:47 |
I tried the query you suggested and it returned the list of field names very quickly, but nothing else. I let it stand for several hours. I had other queries that took a long time, but they would give me an hourglass over the VB Demo window. The Account query looks like it returns an empty set. Might there be some type of permissions problem? |
|
|
|
Tom |
|
Group | : Administrator |
Posts | : 5510 |
Joined | : 2006-02-17 |
|
Profile |
|
Posted : 2008-11-26 20:24:19 |
VB Demo can't display any query that returns over 10,000 rows. You might need to select a smaller subset of data like:
Select * from Account CALLDIRECT where AccountNumber= '1200'
Obivously change '1200' to an account number known to you. |
|
|
|
|