$ fpc testdb
Free Pascal Compiler version 1.0.6 [2002/08/10] for i386 Copyright (c) 1993-2002 by Florian Klaempfl
Target OS: Linux for i386
Compiling testdb.pas
Assembling qtest
Linking testdb
testdb.o(.text+0xaa): In function `program_init':
: undefined reference to `mysql_connect'
testdb.pas(84,3) Error: Error while linking
Closing script ppas.sh

What have I done wrong here ? ...
Yes I have installed the appropiate libmysqlclient-dev (from debian).

cheers
James

How on earth do I do that :P ?

cheers
James

It is not the correct version of mysql. Please check what the mysql_version unit reports as a version, and what the version is of the installed mysql.

Michael.

Simple:

program ver;
uses mysql_version;
begin
  Writeln(MYSQL_SERVER_VERSION);
end.

and
cat /usr/include/mysql/mysql_version.h

Should tell you what is installed.

Michael.

Okay I didn't know such a unit existed :)

Here's the info you wanted...

cheers
James

$ fpc test
Free Pascal Compiler version 1.0.6 [2002/08/10] for i386 Copyright (c) 1993-2002 by Florian Klaempfl
Target OS: Linux for i386
Compiling test.pas
Assembling ver
Linking test
8 Lines compiled, 1.0 sec

Sun Jun 15 01:05:14
~
$ ./test
3.21.28-gamma

Sun Jun 15 01:05:15
~
$ mutt
Mailbox is unchanged.

Sun Jun 15 01:05:27
~
$ cat /usr/include/mysql/mysql_version.h
/* Copyright Abandoned 1996, 1999, 2001 MySQL AB
This file is public domain and comes with NO WARRANTY of any kind */

/* Version numbers for protocol & mysqld */

#ifndef _mysql_version_h
#define _mysql_version_h
#ifdef _CUSTOMCONFIG_
#include <custom_conf.h>
#else
#define PROTOCOL_VERSION 10
#define MYSQL_SERVER_VERSION "4.0.13"
#ifndef MYSQL_SERVER_SUFFIX
#define MYSQL_SERVER_SUFFIX ""
#endif
#define FRM_VER 6
#define MYSQL_VERSION_ID 40013
#define MYSQL_PORT 3306
#define MYSQL_UNIX_ADDR "/var/run/mysqld/mysqld.sock" #define MYSQL_CONFIG_NAME "my"

/* mysqld compile time options */
#ifndef MYSQL_CHARSET
#define MYSQL_CHARSET "latin1"
#endif /* MYSQL_CHARSET */
#endif /* _CUSTOMCONFIG_ */
#endif /* _mysql_version_h */

Correction: the info which you need :-)

Seems that you have mysql version 4 installed.
The units we distribute standard work with MySQL 3.23.

There are units for mysql version 4 as well, but you must compile and install them separately. Get the sources of the packages , and look in packages/base/mysql/mysql4

I warn against using mysql with FPC. Their API changes quite often in incompatible ways, which can be masked with C macros but which cannot be masked with Pascal functions.

Try and use firebird instead is my usual advice.

Michael.

Are there known issues with 1.0.6 and it's finding the configuration file? Does it matter whether I compile using the 'fpc' or 'ppc386' command (they differ on my system):

ian]$ more ~amead/fpc.cfg
-gl
-Co
-Cr
ian]$ ls -l `which ppc386`
lrwxrwxrwx 1 root root 25 May 17 08:49 /usr/bin/ppc386 -> /usr/lib/fpc/1.0.6/ppc386*
ian]$ ls -l `which fpc`
-rwxr-xr-x 1 root root 78020 May 23 2002 /usr/bin/fpc* ian]$ ls -l /usr/lib/fpc/1.0.6/ppc386
-rwxr-xr-x 1 root root 897844 May 23 2002 /usr/lib/fpc/1.0.6/ppc386*
ian]$ rpm -qf /usr/bin/fpc
fpc-1.0.6-1
ian]$ rpm -qf /usr/lib/fpc/1.0.6/ppc386
fpc-1.0.6-1

I ask because my programs are not automatically being compiled with the desired options '-Cr -Co -gl'. I can enable range checking in the source file with {$R+}, is there a similar solution for -gl?

-Alan

=====
A Congressman was once asked about his attitude toward whiskey. "If you mean the demon drink that poisons the mind, pollutes the body, desecrates family life, and inflames sinners, then I'm against it. "

"But if you mean the elixir of Christmas cheer, the shield against winter chill, the taxable potion that puts needed funds into public coffers to comfort little crippled children, then I'm for it."

"This is my position, and I will not compromise."

__________________________________
Do you Yahoo!?
SBC Yahoo! DSL - Now only $29.95 per month!
http://sbc.yahoo.com

Hello,

is there an example of how to write an IRC Client with FPC, the isock*.pp examples only show how to read until i get a "QUIT".

thx.

What about sqlite ? Has anyone gotten that to work in any application they've developed.

cheers
James

tuxx wrote

Hello, is there an example of how to write an IRC Client with FPC, the isock*.pp examples only show how to read until i get a "QUIT".

Catch :)

Little irc bot I wrote (very incomplete), do what you will with it :)

cheers
James

/usr/bin/fpc is only a wrapper and does not include any knowledge to compile a file. The only task for it is to call the correct compiler based on the -P setting, when not specified it calls the default compiler. This default compiler can be checked by running

/usr/bin/fpc -PB

The compiler will first try to load ~/.fpc.cfg, when not found it'll look for ~/.ppc386.cfg when not found it looks for /etc/fpc.cfg and finally for /etc/ppc386.cfg

Peter

I don't know of any report. But if you want to give it a try, I just converted the C headers for it, I can send them to you.

Michael.

Please :) I would love them as I have no idea how to convert C headers myself. Need to learn one day...
All I have here is a pascal unit for beos but it either doesn't work, or there's a in sqlite (which I completely doubt). If you want to have a look at that, search for: "sqlite beos pascal" on google.

But yeah, please send them :)

cheers
James

Alan Mead wrote

Are there known issues with 1.0.6 and it's finding the configuration file?

There is one problem that sometimes pops up:
<http://www.freepascal.org/faq.html#cfgfiles>.

Does it matter whether I compile using the 'fpc' or 'ppc386' command (they differ on my system):

It shouldn't.

I ask because my programs are not automatically being compiled with the desired options '-Cr -Co -gl'.

Check whether there isn't a (.)ppc386.cfg somewhere left on your system from a previous version.

I can enable range checking in the source file with {$R+}, is there a similar solution for -gl?

No.

Jonas

That's not enough, because debug info must be turned on as well. But that can be done with {$d+}, so you're right, it can be done.

Jonas

Just put in the uses clause the unit LineInfo the first one.

Las personas se dividen en tres grupos, los que saben contar y los que no. There are three groups of people, who can count, and who cannot.