Lazarus Database Tutorial/SampleListing

From Free Pascal wiki
Jump to: navigation, search
kirkpatc@anglican:~/FreePascal/fpc/packages/base/mysql> ./trydb
 
Enter Hostname: localhost
Enter Username: kirkpatc
Enter Password: ****
Allocating Space...
Connecting to MySQL...Done.
Connection data:
Mysql_port      : 3306
Mysql_unix_port : /var/lib/mysql/mysql.sock
Host info       : Localhost via UNIX socket
Server info     : Uptime: 11505  Threads: 1  Questions: 11  Slow queries: 0  Opens: 7   Flush tables: 1  Open tables: 1  Queries per second avg: 0.001
Client info     : 4.0.15
Selecting Database testdb...
Enter SQL Query: select * from FPdev
Executing query : select * from FPdev...
Number of records returned  : 8
Number of fields per record : 3
(Id: 1, Name: Michael Van Canneyt, Email : Michael...tfdec1.fys.kuleuven.ac.be)
(Id: 2, Name: Florian Klaempfl, Email : ba2395...fen.baynet.de)
(Id: 3, Name: Carl-Eric Codere, Email : codc01...gel.usherb.ca)
(Id: 4, Name: Daniel Mantione, Email : d.s.p.mantione...twi.tudelft.nl)
(Id: 5, Name: Pierre Muller, Email : muller...europe.u-strasbg.fr)
(Id: 6, Name: Jonas Maebe, Email : jmaebe...mail.dma.be)
(Id: 7, Name: Peter Vreman, Email : pfv...worldonline.nl)
(Id: 8, Name: Gerry Dubois, Email : gerry...webworks.ml.org)
Enter SQL Query: select id, username from FPdev where id<6
Executing query : select id, username from FPdev where id<6...
Number of records returned  : 5
Number of fields per record : 2
(Id: 1, Name: Michael Van Canneyt, Email : )
(Id: 2, Name: Florian Klaempfl, Email : )
(Id: 3, Name: Carl-Eric Codere, Email : )
(Id: 4, Name: Daniel Mantione, Email : )
(Id: 5, Name: Pierre Muller, Email : )
Enter SQL Query: quit
Executing query : quit...