<!DOCTYPE html PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
<html>
<head>
<meta content="text/html;charset=us-ascii" http-equiv="Content-Type">
</head>
<body bgcolor="#ffffff" text="#000000">
Tom Lisjac wrote:
<blockquote
cite="mid:980261260811202350j731cb870v91789dcc46124ef3@mail.gmail.com"
type="cite">
<pre wrap="">Hi Eric,
</pre>
<blockquote type="cite">
<pre wrap="">I have followed source advice but can't connect.
Can anyone help and/or is there a manual?
</pre>
</blockquote>
<pre wrap=""><!---->
</pre>
<blockquote type="cite">
<pre wrap="">Error: invalid compiler: file
There must be something in my source looking for a compiler in the wrong
place :-(
</pre>
</blockquote>
<pre wrap=""><!---->
The errors you're getting in the tutorial example are from some hard
coded paths in the database_try.lpi project file. It's not a problem
with your system. Since Lazarus has changed since the example was
written, it might be easier to start your project with the sqldb
components.
To install sqldb, go to "Package->Open package file", select and
install the lazarus/components/sqldb/sqldblaz.lpk package. After
Lazarus recompiles, you should see a "SQLdb" tab. Drop a Mysql50
(TMySQL50Connection) on a new form. In the object inspector for this
component, enter the hostname (probably localhost), a database (test
or mysql as an example or a database you've already created) and the
username and password for the database or the "root" you set when
installing mysql. At this point, establishing a successful mysql
connection is being able to set the Connected property to true without
an error.
</pre>
</blockquote>
Thanks heaps for the help. I Get this far and changing "Connected" to
"True" <br>
gives the error<br>
"Cannot load MySQL library "libmysqlclient.so. Please check your
installation."<br>
<br>
The SQLdb Tab is there with 9 Icons including postgreSQL & Firebird!<br>
<br>
Eric March<br>
<br>
<br>
<br>
<blockquote
cite="mid:980261260811202350j731cb870v91789dcc46124ef3@mail.gmail.com"
type="cite">
<pre wrap="">The next step is to add TSQLTransaction and TSQLQuery (a TDataset
descendent) to your form and point them to TMySQL50Connection.
TSQLQuery is used to pass DDL or DML sql statements to the database
and return DML result sets. Put your sql statements in the SQL
stringlist and use the ExecSQL method to execute DDL statements or the
open method to return a DML result set. Adding a TDatasource to the
form and pointing it at the TSQLQuery will allow you to use the data
aware components to display the query results.
Marco Cantu has posted a pdf extract from "Essential Delphi" that
provides a good sql overview:
<a class="moz-txt-link-freetext" href="http://www.marcocantu.com/edelphi/EssentialSQL_md6.pdf">http://www.marcocantu.com/edelphi/EssentialSQL_md6.pdf</a>
Hopefully this will get you started. There books and examples on the
net about using TDatasets and the data aware components.
-Tom
_______________________________________________
Lazarus mailing list
<a class="moz-txt-link-abbreviated" href="mailto:Lazarus@lazarus.freepascal.org">Lazarus@lazarus.freepascal.org</a>
<a class="moz-txt-link-freetext" href="http://www.lazarus.freepascal.org/mailman/listinfo/lazarus">http://www.lazarus.freepascal.org/mailman/listinfo/lazarus</a>
</pre>
</blockquote>
<br>
</body>
</html>