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?
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?
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"