Field of types ftString not persistent

[matthijsj]

I have a form with a BufDataSet, a dbGrid and a datasource connecting them. When I try to enter data in a field of type ftString, the entered data is not persistent. The data is removed when I move to the next field. What do I do wrong?

[matthijsj]

I entered the following code:

Code: Pascal  [Select][+][-]

1. procedure TForm1.Button1Click(Sender: TObject);
2. begin
3.   BufDataset1.Insert;
4.   BufDataset1.FieldByName('Number').Value := 1000;
5.   BufDataset1.FieldByName('Naam').Value := 'EenWaarde';
6.   BufDataset1.Post;
7. end;  
8.  

However the field "Naam' does not save the data.

[dseligo]

Post example project which shows your problem.

Also provide (https://wiki.freepascal.org/Forum):
- the name of your operating system
- the version of your operating system
- the version of your Free Pascal Compiler
- the version of your Lazarus IDE

[Thaddy]

Het naam veld moet een shortstring zijn. string[255]
The name field should be a shortstring type with a value to the maximum you expect.
Otherwise you store a pointer...

[wp]

I don't see any problem with the code that you posted for TBufdataset. See attached sample project.

[Zvoni]

And shouldn't he use "AsInteger", "AsString" instead of "Value"?

[rvk]

And shouldn't he use "AsInteger", "AsString" instead of "Value"?

Value is a variant, so it will accept a string and convert it back to the correct fieldtype.

But we haven't seen anything of the rest of the code and defined fields.
(Although pushing a string into a ftInteger field via a variant will result in an exception.)

[matthijsj]

Size should be given when fieldtype is ftString.

[Richard Marriott]

I assume you set up the table in the IDE, so go back to the field definitions property and make sure that the definition for 'Namm" contains a size parameter (as matthijsj suggests).
The other suggestions should all work. Value is a variant that contents the input to the field definition type. The only other thing I can think of is to try 'Append" rather than "Insert" in your code.