last character lost

[stefanoaltissimo]

Hello,

i have a problem using TOeracleQuery
I am using delphi 7 in windows 7 32 bit

The problem i have is that it seems that for every field fullfilled, my program loose the last character. For example if
i have a field like this

emplName NVARCHAR2(8) not null

and in PL/SQL Developer i edit and see a value like this

'12345678'

with a code similar to this

QryLookUp := TOracleQuery.Create(Application);
QryLookUp.Session := DBSt3k;

QryLookUp.SQL.Text := 'select * from employees';
QryLookUp.Execute;

trnOut := QryLookUp.Field('emplName');

i get a field value like this

'1234567'

the '8' is missed!

Where is the problem?

Thank you for help

Stefano Altissimo

 

[Marco Kalter]

Can you send me a little demo project to reproduce this?

 

[stefanoaltissimo]

Yes Marco, i will do that asap, even if the code i am doing to prepare, basically, it will be like the code i wrote in my post.

Regards

 

[stefanoaltissimo]

Hello Marco, i also sent you an e-mail to ask you some help regarding this issue. I already sent you a little example to let you to replicate the situation.

Thank you again.

Stefano Altissimo
ddway s.r.l.

 

[stefanoaltissimo]

Hello Marco,

i notice the same issue using
TOracleDataset.Lookup

If i try to read fulfilled fields, i loose the last character

for example a Oracle field 8 bytes long filled with '12345678', with
xxx := DSetComments.Lookup('COMMENT_NO', 1, 'COMMENTS')
is returned as
xxx = '1234567'

The field is regularly showed by Developer

Grazie...

Stefano Altissimo DDWay srl

 

[stefanoaltissimo]

Hello Marco,

the next step is that we have to give up to DOA.
I do not know if this is a DOA's bug or something related to our way to work, but in any case its a issue that we must solve, in a way or another. We only are asking for some advice after we tried everything, we also tried to pass from Delphi 7 to Delphi XE3 and we see always the same issue:

this normal statement
xxx := DSetComments.Lookup('COMMENT_NO', 1, 'COMMENTS')
loose the last character in a fullfilled nvarcahr(xx)

probably its a banal setting issue, but we tried everything, probably its a obvious and giant thing (we hope so), but it always slide away from our eyes, everything is possible but please, try to tell us something we could try.

Thank you.

Stefano Altissimo DDWay srl

 

[stefanoaltissimo]

Hello Marco,

just to tell you (and eventually other interested people) that the problem disappears using Delphi XE3 but its present in Delphi 7. I did not notice it at early tests because i was not running the program in debug mode so probably the environment did not recompile the program.
In any case the problem in Delphi 7/DOA for Delphi 7 is always alive and kicking.

Thank you,

Stefano Altissimo
DDWay srl