Re: [lazarus] MySql 4.1 Database Questions

[Roberto Padovani]

2007/11/29, el stamatakos [EMAIL PROTECTED]:

  Hi,
   I finally got passed the

  Project Raised exception class 'EInOutError with message:
 Can not load MySQL library libmysqlclient.so. Please check your
 installation. Indeed I had to create a symbolik link.


a symbolic link in the project folder is just fine, but probably the
system should be configured so that the path to libmysqlclient is int
the list of default paths to search dynamic libraries in

R#

_
 To unsubscribe: mail [EMAIL PROTECTED] with
unsubscribe as the Subject
   archives at http://www.lazarus.freepascal.org/mailarchives

RE: [lazarus] MySql 4.1 Database Questions

[el stamatakos]

Hi,
 I finally got passed the 
 
Project Raised exception class 'EInOutError with message:Can not load MySQL 
library libmysqlclient.so. Please check yourinstallation. Indeed I had to 
create a symbolik link.
 
***I have another problem
 
1) I have an MDI application and when I clicked on a menu it would open another 
form. Now it does not any idea how I can fix this.
 
2) I want to be able to do something like
 
SQLQuery1.SQLSelect('SELECT * from process ORDER BY processDisplayOrder');
 
Any ideas.
 
Thanks to all.
 
Best
 
Lefti
 
 Date: Wed, 28 Nov 2007 22:18:09 -0500 From: [EMAIL PROTECTED] To: 
 lazarus@miraclec.com Subject: Re: [lazarus] MySql 4.1 Database Questions  
 el stamatakos wrote:Hi All,  I am making some progress with 
 Lazarus. It is a great tool and hope  to learn it well. I have a problem 
 when trying to connect to MySQL  4.1. I used some of the code from the 
 tutorial essentially and I  have the following code
 MySQLConnection1.HostName := HostEdit.Text;  MySQLConnection1.UserName := 
 UserEdit.Text;  MySQLConnection1.Password := PasswdEdit.Text;  
 MySQLConnection1.DatabaseName :='mysql';  MySQLConnection1.Open;I 
 stepped through each of the MySQL commands from HostName to Open  to find 
 out the problem. I encountered a problem when I tried to do  
 MySQLConnection1.Open; and got the following errorProject Raised 
 exception class 'EInOutError with message:  Can not load MySQL library 
 libmysqlclient.so. Please check your  installation.I added the 
 MYSQL41Connection, TSQLQuery, TSQLTransaction from the  SQLdb tab in 
 Lazarus. If I look at the Project Inspector, I see  SQLDBLaz (=1.0) as a 
 Required Package.I haven't worked with MySQL in years and then only 
 little, but the client  library for mysql obviously can't be found/loaded. 
 I've only worked in linux a  bit, but I remember having a similar problem 
 with a firebirdsql client app.  Someone walked me through creating a symlink 
 to the actual .so file from the  application's directory if I remember 
 correctly.  Someone with more experience than I will pipe in I'm sure, but 
 just a thought in  the meantime.  --  Warm Regards,  Lee  My wife is 
 better at Guitar Hero than I am and it's really irritating.  
 _ To 
 unsubscribe: mail [EMAIL PROTECTED] with unsubscribe as the Subject 
 archives at http://www.lazarus.freepascal.org/mailarchives

Re: [lazarus] MySql 4.1 Database Questions

[John]

el stamatakos wrote:

   
1) I have an MDI application and when I clicked on a menu it would open
another form. Now it does not any idea how I can fix this.

Can you give a little more information ?

2) I want to be able to do something like

SQLQuery1.SQLSelect('SELECT * from process ORDER BY
processDisplayOrder');

  

Very roughly, at run time, you add the query text to SQLQuery1.SQL

SQLQuery1.SQL.clear;
SQLQuery1.SQL.add('SELECT * from process ORDER BY processDisplayOrder');

and set it active

SQLQuery1.active = true;

OR you can do this at design time in the object inspector, if the
query does not change.

WARNING:

I've been trying to work out how to use SVN, and all my up to date
lazaruses are broken (!), so I cannot check that this is exactly right
- hope it points you in the right direction.

cheers,
John Sunderland



_
 To unsubscribe: mail [EMAIL PROTECTED] with
"unsubscribe" as the Subject
   archives at http://www.lazarus.freepascal.org/mailarchives