[fpc-pascal] Database access in console program

[michael.vancanneyt at wisa.be]

On Wed, 9 Nov 2011, Koenraad Lelong wrote:

> Hi,
>
> I don't know if it's the right place to ask, maybe it's for the lazarus list.
>
>
> When I insert values I do :
>
>  myTable.Params.ParamByName('Field1').Value:='Value1';
>  myTable.Params.ParamByName('Field2').Value:='Value2';

This should be:

MyTable.Append;
MyTable.FieldByname('Field1').AsString:='Value1';
MyTable.FieldByname('Field2').AsString:='Value2';
MyTable.Post;
MyTable.Applyupdates;

Michael.