When a TEDBQuery is passed to a function as a TComponent, you do an
TEDBQuery(AQuery).ExecSQL and then TEDBQuery(AQuery).FlushBuffers it
causes a "Cannot perform this operation on a closed dataset" error.
Why would that be?

Michae,

<<When a TEDBQuery is passed to a function as a TComponent, you do an
TEDBQuery(AQuery).ExecSQL and then TEDBQuery(AQuery).FlushBuffers it
causes a "Cannot perform this operation on a closed dataset" error.
Why would that be?>>

I don't have the reply, but my feeling is that Tim is busy with some other issues.  Hope it's not some urgent family issues.

Michael,

<< When a TEDBQuery is passed to a function as a TComponent, you do an
TEDBQuery(AQuery).ExecSQL and then TEDBQuery(AQuery).FlushBuffers it causes
a "Cannot perform this operation on a closed dataset" error. Why would that
be? >>

Does the SQL that you're executing return a result set ?  And if so, then is
the TEDBQuery component still active at the point that you execute the
FlushBuffers method ?

--
Tim Young
Elevate Software
www.elevatesoft.com

Abdulaziz,

<< I don't have the reply, but my feeling is that Tim is busy with some
other issues.  Hope it's not some urgent family issues. >>

Yes, I was at the hospital for about 5 hours today.  Things are up and down
with my dad, but he's still fighting.

--
Tim Young
Elevate Software
www.elevatesoft.com

Tim,

<<Yes, I was at the hospital for about 5 hours today.  Things are up and down
with my dad, but he's still fighting.>>

It happened to me once with my father.  The only thing that I can help is to ask you to "Keep close to your father"  and I am sure everybody will
understand.

Abdulaziz,

<< It happened to me once with my father.  The only thing that I can help is
to ask you to "Keep close to your father"  and I am sure everybody will
understand. >>

Thanks.  That's exactly what I'm doing.

--
Tim Young
Elevate Software
www.elevatesoft.com

On Fri, 16 Nov 2007 18:13:29 -0500, "Tim Young [Elevate Software]"
<timyoung@elevatesoft.com> wrote:

>Michael,
>
><< When a TEDBQuery is passed to a function as a TComponent, you do an
>TEDBQuery(AQuery).ExecSQL and then TEDBQuery(AQuery).FlushBuffers it causes
>a "Cannot perform this operation on a closed dataset" error. Why would that
>be? >>
>
>Does the SQL that you're executing return a result set ?  And if so, then is
>the TEDBQuery component still active at the point that you execute the
>FlushBuffers method ?

No I'm just executing (INSERT or APPEND).

Michael,

<< No I'm just executing (INSERT or APPEND). >>

You can only use FlushBuffers on an active dataset, which there isn't in
your case because the INSERT doesn't return a result set.  You accomplish
the same thing, you should use this script instead:

START TRANSACTION WITH <TableName>;
INSERT INTO <TableName> .....;
COMMIT FLUSH;

--
Tim Young
Elevate Software
www.elevatesoft.com

Michael,

Crap, wrong newsgroup - the script that I gave you is DBISAM.  What you want
to do is use the TEDBScript component and this script:

SCRIPT
BEGIN
  START TRANSACTION ON TABLES <TableName>;
  EXECUTE IMMEDIATE 'INSERT INTO <TableName> .....';
  COMMIT FLUSH;
END

--
Tim Young
Elevate Software
www.elevatesoft.com

On Mon, 19 Nov 2007 14:56:08 -0500, "Tim Young [Elevate Software]"
<timyoung@elevatesoft.com> wrote:

>Michael,
>
>Crap, wrong newsgroup - the script that I gave you is DBISAM.  What you want
>to do is use the TEDBScript component and this script:
>
>SCRIPT
>BEGIN
>   START TRANSACTION ON TABLES <TableName>;
>   EXECUTE IMMEDIATE 'INSERT INTO <TableName> .....';
>   COMMIT FLUSH;
>END

That's extremely inconvenient. It would be so much nicer to have a
single call like FlushBuffers for execute queries as well.