ANY guide to Lazarus Database Programming
lazarus / 16-Databases

----------------------------------------------------------------------
IAM · 2010-07-30 18:42

Is there any guide to Lazarus Database Programming like the "guide to
Delphi Database (ADO) Programming" in this link

http://delphi.about.com/od/database/a/adodelphi.htm

?


How to access MS-Access DB? and How to do the basic operations such as
insertion, deletion, searching, editing, ....etc

----------------------------------------------------------------------
clauslack · 2010-07-30 23:38

Check
http://wiki.lazarus.freepascal.org/ODBCConn

In control Panel ODBC-> User DSN , add Access database


Code: [Select]procedure TForm1.Button1Click(Sender: TObject);
begin
   with ODBCConnection1 do begin
      Connected:= False;
      DatabaseName:='farmacia';
      UserName:='';  //for MS SQL Server fill user and password
      Password:='';
      Connected:= True;
   end;
   with SQLQuery1 do begin
      close;sql.clear;
      sql.add('select * from medimentos');
   end;
   if SQLTransaction1.Active then SQLTransaction1.Commit;
   SQLTransaction1.StartTransaction;
   SQLQuery1.open;
end;                                

Check
http://wiki.lazarus.freepascal.org/Databases

here an Database example with Firebird and SQLDb

http://www.lazarus.freepascal.org/index.php/topic,7246.msg34315.html#m
sg34315

----------------------------------------------------------------------
IAM · 2010-08-01 00:52

Quote from: clauslack on July 31, 2010, 01:38:05 amCheck
http://wiki.lazarus.freepascal.org/ODBCConn

In control Panel ODBC-> User DSN , add Access database


Code: [Select]procedure TForm1.Button1Click(Sender: TObject);
begin
   with ODBCConnection1 do begin
      Connected:= False;
      DatabaseName:='farmacia';
      UserName:='';  //for MS SQL Server fill user and password
      Password:='';
      Connected:= True;
   end;
   with SQLQuery1 do begin
      close;sql.clear;
      sql.add('select * from medimentos');
   end;
   if SQLTransaction1.Active then SQLTransaction1.Commit;
   SQLTransaction1.StartTransaction;
   SQLQuery1.open;
end;                                

Check
http://wiki.lazarus.freepascal.org/Databases

here an Database example with Firebird and SQLDb

http://www.lazarus.freepascal.org/index.php/topic,7246.msg34315.html#m
sg34315


very useful

Thanx clauslack

----------------------------------------------------------------------
itsols · 2010-10-09 10:05

None of the wiki sites referred to above seem to work. Is there some
error on the server?

----------------------------------------------------------------------
xenblaise · 2010-10-18 00:08

Try to read from that post.
http://forum.lazarus.freepascal.org/index.php/topic,10811.0.html

----------------------------------------------------------------------
xenblaise · 2010-10-18 11:22

Lazarus for Ms Access
http://wiki.lazarus.freepascal.org/MS_Access