ANY guide to Lazarus Database Programming

[IAM]

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]

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#msg34315

[IAM]

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#msg34315

very useful

Thanx clauslack

[itsols]

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

[xenblaise]

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

[xenblaise]

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