Character Problem

[Henry Olive 5]

Good Day

Delphi10,  FB-3, SQLDataset, DataSetProvider, CDS, DataSource
 

MasterTable TNAME Field.Value = 'A.Cap-'  // There is - at the end

When I insert a new record into the DetailTable my code is like below

 

DetailTable.FieldByName('TNAME').asString := MasterTable.FieldByName('TNAME').asString;

 

After Post & ApplyUpdate when i check releated record in the Database i see TNAME value

in DetailTable is 'A.Cap'  // No - at the end,  There should have been 'A.Cap-'   

but in Database,  MasterTable TNAME value = 'A.Cap-' // there is - at the end which is correct

 

What is wrong ?

Thank You

 

 

 

 

 

 

[Henry Olive 5]

The problem is SOLVED
The Field's size in SQLDataset was 5 (should have been 8 )
I change the Field's size to 8 and problem solved 

I'm really very very sorry i firstly should have checked that size property

I apologize to everyone

THANK YOU

[Ian Branch 121]

No need to apologise, we have all done something like that in our lifetimes.....