Substitution variable work on 3.4.6.4 but not work on 4.0.1.0

[eliasyac]

I have a SQL :

select
:column
from :from
where
:usl1
order by rder

variale hav value but
in SQLEditor and run mode have oracle error
SubstitutedSQL show
"select
:column
from :from
where
:usl1
order by rder"

it worked on 3.4.6.4
I'm using Delphi 7 Ent

 

[Marco Kalter]

Works fine for me. Can you send me a testcase to reproduce this?

 

[eliasyac]

table is:

create table test1
(
n1 number,
n2 number,
n3 number,
v1 varchar2(255),
v2 varchar2(255),
v3 varchar2(255),
*** varchar2(255)
)

select is:

select
t.***
:column
from test1 t

:column - ,t.n1

if *** - english text it`s work
if *** - russian text it`s not work and SubstitutedSQL show:

select
t.***,
:colut.n1m test1 t
-----------

 

[eliasyac]

if in
orale.pas
function FindVariables(const SQL: string; IncludeDuplicates: Boolean): TStringList;

comment string:
if s > #255 then Inc(wcCount);

all work

 

[Marco Kalter]

I see. This will be fixed in 4.0.2.