WinBatch Tech Support Home

Database Search

If you can't find the information using the categories below, post a question over in our WinBatch Tech Support Forum.

TechHome

ODBC
plus

Can't find the information you are looking for here? Then leave a message over on our WinBatch Tech Support Forum.

qGetData 50 columns limit

Keywords:  qGetData 50 column limit 

Question:

I have a query result of more than 50 columns. How can I do that, since qGetData is limited to 50 ?

Answer:

Not that I know of. Perhaps two different queries?

Question:

...but is there a reason for the 50 columns limit ?

Answer:

The WinBatch ODBC extender requires excessive memory to keep track of this information. The original design goal was to have a quick and dirty scheme to access ODBC information in a database, so 50 items seemed list more than sufficient at the time -- under the theory that if someone need to do real ODBC work then a real database program should be used.



Article ID:   W14539
Filename:   qGetData 50 columns limit.txt
File Created: 2017:07:28:13:58:33
Last Updated: 2001:01:09:16:00:38