TOracleCommand.Execute

[timboc]

What exactly does it mean if the function returns False?

The documentation states that "The result indicates if the command has been handled.".

I'm guessing that I still have to check the errorcode/errormessage on True or False so I'd like to know what more False means.

Thanks,
Tim

 

[Marco Kalter]

If the command is not recognized as a valid SQL command, it is not processed and returns False. If the result is True, it was executed (either successfully or with an error) and you may want to check the ErrorCode.

------------------
Marco Kalter
Allround Automations

 

[timboc]

It's strange that I'm seeing just the opposite:

.Execute is returning False when my statement was executed. I've yet to get a scenario where it returns True.

-Tim

 

[Marco Kalter]

Hmm, this seems to be a bug. For SQL commands it always returns False. For non-SQL commands (REMARK, QUIT, PAUSE, etc) it returns the expected value.

We'll fix this.

------------------
Marco Kalter
Allround Automations