Hi,
is there a way to allow an EXECUTE "QSELECT... " inside a transaction in
a basic program. The HELP BASIC EXECUTE specifies a few verbs that are
allowed inside transaction :
if a SELECT / SSELECT is allowed, cant a QSELECT be allowed aswell? Or
might I be missing something? Any ways to overcome this? Thanks.
Regards,
Brian.
+-----------------------------------------------------------------------
-------+
| The EXECUTE statement fails and the program terminates with a
|
| run-time error message if:
|
|
|
| o dynamic.array or expression in the IN clause evaluates to the
|
| null value.
|
|
|
| o The command expression evaluates to the null value.
|
|
|
| Although you cannot use the EXECUTE statement within a
|
| transaction to execute most UniVerse commands and SQL
|
| statements, you can use EXECUTE to execute the following
|
| UniVerse commands and SQL statements within a transaction:
|
|
|
| CHECK.SUM INSERT SEARCH SSELECT
|
| COUNT LIST SELECT (RetrieVe) STAT
|
| DELETE (SQL) LIST.ITEM SELECT (SQL) SUM
|
| DISPLAY LIST.LABEL SORT UPDATE
|
| ESEARCH RUN SORT.ITEM
|
| GET.LIST SAVE.LIST SORT.LABEL
|
|
|
| More End Help List Commands
|
+---------------------------+ Page Up/Page Down
+------------------------------+
Verb "QSELECT" illegal when a transaction is active.
Rolling back uncommitted transactions begun within this execution
environment.
Important Notice: This email is subject to important restrictions,
qualifications and disclaimers ("the Disclaimer") that must be accessed
and read at the following address or by copying and pasting the following
address into your Internet browser's address bar:
http://www.frstia.co.za/Disclaimer.asp
The Disclaimer is deemed to form part of the content
of this email in terms of Section 11 of the Electronic Communications
and Transactions Act, 25 of 2002. If you cannot access the Disclaimer,
please obtain a copy thereof from us by sending an email to
mailto:[EMAIL PROTECTED]
FirstRand STI Admin (Pty) Ltd is an Authorised Financial Services Provider
-------
u2-users mailing list
u2-users@listserver.u2ug.org
To unsubscribe please visit http://listserver.u2ug.org/
