SQL*Forms problem with : SYSTEM. variable

Has anyone used the :SYSTEM.LAST_QUERY variable in SQL*FORMS V3.0 ?

I am trying to use save the value of this variable, but encountered the ff: problems.

• if the query is very long (> 500 characters), SQL*FORMS will abend (quit) with a dump of the stacks and registers. This sounds like a buffer overflow problem.
• however, if I shorten the query I don't get this abend. I measured the length of the query at 456. Is that maximum length of :SYSTEM.LAST_QUERY set at 512 characters ? If so, can this be increased ?
• when the query is OK (i.e. - doesn't cause an abend), when I try to save :SYSTEM.LAST_QUERY to a LONG column in a table via an INSERT command, the value of :SYSTEM.LAST_QUERY gets chopped off. It's storing only the first 80 or so characters. But when I save :SYSTEM.LAST_QUERY to a field in the form, I can see the entire query text which is correct.

What I am trying to do here is to save the query so I can generate a report based on the query criteria. The SQL*Forms documentation mentions this as a primary use for :SYSTEM.LAST_QUERY, although it doesn't show how to do it.

Any suggestions regarding this would be greatly appreciated. Thanks. Received on Mon Mar 23 1992 - 21:02:15 CET