Mysql console program
lazarus / 16-Databases

----------------------------------------------------------------------
codeb · 2008-03-26 14:27

I need to build some console program like from
http://lazarus-ccr.sourceforge.net/index.php?wiki=LazarusDatabase
With  that program I try check some data in mysql tables.
I have Lazarus v.0.9.24 beta and I try to make little program to
connect to mysql a read data.

Program start like that :
Code: [Select]
program Project1;

{$mode objfpc}{$H+}

uses mysql50conn,mysql;

const
  host : Pchar= 'localhost';
  user : Pchar= 'myusername';
  passwd: Pchar = 'mypassword';
count,num : longint;
 code : integer;
 sock : PMYSQL;
 qmysql : TMYSQL;
 qbuf : string [160];
 rowbuf : MYSQL_ROW;
 dummy, dummy1, dummy2, dummy3, dummyquery, dumquery : string;
 recbuf : PMYSQL_RES;
 alloc : PMYSQL;
 Query : Pchar;    
....


but I can't compile I get error :
project1.lpr(11,17) Error: Identifier not found "PMYSQL"

After that I add some unit to uses statment sqldb,db, mysql50dyn and
then I pass that error but there are one more:
project1.lpr(15,17) Error: Identifier not found "TMYSQL"
After that I try to add mysql and all other unit but nothing I get
same error.

Please some information , sample source or little semple hot to read
data from mysql with this Lazarus version.


PS Sorry on bad english

----------------------------------------------------------------------
Leledumbo · 2008-03-27 05:10

Hold ctrl then click on PMYSQL or TMYSQL. If it can show you where the
type is declared, then you might need to set project requirement via
Project Inspector.

----------------------------------------------------------------------
windy · 2008-05-18 21:55

Hi
I am also wanting to add mysql support to a conole program (i.e no
forms (for no x windows linux))
I have used succesfully the mysql components in a full application
(i.e with the components on a form)
but is the a tutorial or code examples for how to add and link and
work with those components via code only?
(i.e by creating them manualy, and setting them manualy)
or maybe I  just need to jump in and try?
thanks!
Brian

----------------------------------------------------------------------
windy · 2008-05-21 05:56

Hi
I got it working
by using the format
mycomponent:=tmycomponent.create(nil);