SQL delete (OpenInsight 32-Bit) [Revelation On-Line Wiki]

OpenInsight 32-Bit, Jim Vaughan, j Vaughan

Join The Works program to have access to the most current content, and to be able to ask questions and get answers from Revelation staff and the Revelation community

At 06 APR 2002 08:29:00PM Jim Vaughan wrote:

Running the following code:

SCRIPT=DELETE FROM Run WHERE PCN '12345'

FLAG=QRYMETHOD(HQRY, QRY_EXECUTE$, SCRIPT)

* no records are deleted from the SQL database

FLAG=QRYMETHOD(HQRY, QRY_GETERROR$, "", "", "", "", ERROR_TEXT)

* and ERROR_TEXT is set to

* "The connection has an uncanceled statement"

Any ideas? I am doing something wrong?

At 07 APR 2002 12:09AM j Vaughan wrote:

Got it.

I had not cancled the prior SQL call.

View this thread on the Works forum...