Sign in Join
Wiki copytemporary

Lazarus Database Tutorial/SampleListing

kirkpatc@anglican:~/FreePascal/fpc/packages/base/mysql> ./trydb

pascal
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...

From the Free Pascal wiki, page "Lazarus Database Tutorial/SampleListing", as it stood on 2013-12-26 after a change by Jwdietrich, out of the wiki's dump of 2024-05-26. Copyright stays with the author who wrote it, according to the old wiki's Licensing page. If you have concerns about this material, message the admin.

Revision 1, last changed by WikiArchive .

Talk about this page

Nobody has opened a bench for this page yet. Sign in to open one.