tibdataset.fieldbyname('').Asstring

Cristina

Delphi Developer

Sat, 14 Feb 2004 10:26:16 GMT

tibdataset.fieldbyname('').Asstring

Hi, i don't know if i'm doing this very good.

I'm reading a data from a string field with a TIBDataSet in this form:

Label.Caption:=TIBDataSet.FieldByName('NAME').AsString;

and i receive "PETER " and i expect to receive
"PETER"

any sugestion?

Thank you

Team

Delphi Developer

Sat, 14 Feb 2004 10:28:28 GMT

Re:tibdataset.fieldbyname('').Asstring

Your underlying data type is a CHAR and not a VarChar. Set the TField's
FixedChar to false or use AsTrimString.

Quote

Cristina wrote:

> Hi, i don't know if i'm doing this very good.

> I'm reading a data from a string field with a TIBDataSet in this form:

> Label.Caption:=TIBDataSet.FieldByName('NAME').AsString;

> and i receive "PETER " and i expect to receive
> "PETER"

> any sugestion?

> Thank you

--
Jeff Overcash (TeamB) I don't think there are any Russians
(Please do not email And there ain't no Yanks
me directly unless Just corporate criminals
asked. Thank You) Playing with tanks. (Michael Been)

Other Threads

1. table1.fieldbyname('memo').asstring

2. TIBSQL stayed prepared and FieldByName('FieldX').AsString

3. Choosing Dataset['FieldName'] or Dataset.FieldByName('FieldName').AsString

4. With BDE 5.0 TStringField.AsString returns '??????????????????????????????'

5. Table1.FieldByName('x').DisplayFormat runtime problem.

6. copytoclipboard from fieldbyname('memo')

7. FieldByName('blahblah').Value for different field types

8. tfield vs 'fieldbyname'

9. MEMORY LEAK BUG: FieldByName (AsString) for fieldtype: ftMemo;

10. TIBQuery.ParamByName('field').AsString:='' becomes NULL on server?