limits on sql select wildcard?

Post Reply
linda.a.kennedy
Posts: 19
Joined: Wed Dec 31, 2008 2:17 pm

limits on sql select wildcard?

Post by linda.a.kennedy »

I have an sql "select * from table" where the table has 245 variables in it. It only get the first 100 or so. I tried using <apicp qmaxset 245> before the sql but still can't read all of the variables. Is that the wrong apicp option or am I missing something?

Thanks
User avatar
mark
Site Admin
Posts: 5513
Joined: Tue Apr 25, 2000 6:56 pm

limits on sql select wildcard?

Post by mark »

I assume you're referring to table columns. apicp is unrelated. You should be able to select all of them.
What version of texis?
Are you getting any warning or error messages?
User avatar
mark
Site Admin
Posts: 5513
Joined: Tue Apr 25, 2000 6:56 pm

limits on sql select wildcard?

Post by mark »

If you have an ancient version like 5 or before there's a limit of 100 fields selectable at a time. To get the rest you'd have to do another select.
"select f1,...,f100 from table where key=$val"
"select f101,...,f200 from table where key=$val"
"select f201,...,f245 from table where key=$val"
linda.a.kennedy
Posts: 19
Joined: Wed Dec 31, 2008 2:17 pm

limits on sql select wildcard?

Post by linda.a.kennedy »

We are using Version 5.00.1086121238 and I didn't get any warnings or errors.

Thanks for the info. I'll just break it up into multiple select statements.
Post Reply