Re: [fpc-pascal] Database access in console program

2011-11-09 Thread Koenraad Lelong
On 09-11-11 18:02, michael.vancann...@wisa.be wrote: ... This should be: MyTable.Append; MyTable.FieldByname('Field1').AsString:='Value1'; MyTable.FieldByname('Field2').AsString:='Value2'; MyTable.Post; MyTable.Applyupdates; Thanks, That worked. And I remember using this before. Thanks,

Re: [fpc-pascal] Database access in console program

2011-11-09 Thread michael . vancanneyt
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.

[fpc-pascal] Database access in console program

2011-11-09 Thread Koenraad Lelong
Hi, I don't know if it's the right place to ask, maybe it's for the lazarus list. Anyway, I'm trying to make a console-application that writes data to a Firebird database. With Lazarus I created a console application. I seem to be able to connect and open the table, but I can't insert data.