Something happen with the length of SQL property in a TOracleDataSet

[Ferk0]

Hi
I have a problem with the TOracleQuery component,
when I set a very long SQL statement
(Like the one attached to this mail)
the component works very well only at the beginning,
but after some time it failed,
the SQL statement is 4600 characters long and when I was debugging it,
it says that the SQL statement exceds 1024 characters,
ok but if that is true so how could I run it with the full statement?
and what we can do to run a long SQL statement as long as this?

thank you a lot.

sql statement:

select b.Folio,
a.FECEMI Fecha,
substr(
case when (a.indcom='0' and a.auto_a< 4 and b.comprometido_C0 ) then 'dinero comprometido en compra no concluida sin autorizaci

 

[Marco Kalter]

You can run SQL statements of any size. What exactly is the error message when it fails?

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