Re: problem with max

2002-04-26 Thread Jean Bernard
hello in delphi the type for max(date) if tstring. the only problem is there is no CAST in mysql 3.23.49 bye - Original Message - From: Johnny Withers [EMAIL PROTECTED] To: 'Jean Bernard' [EMAIL PROTECTED] Sent: Thursday, April 25, 2002 2:46 PM Subject: RE: problem with max I'm

problem with max

2002-04-24 Thread Jean Bernard
i write a program using MyIsam,and i want uses Innodb. the query: select max(date_comp) as mdate from pieces on MyIsam mdate is a date. on InnoDB mdate is string. win2000 delphi6 zeosdbo it's normal? - Before posting,

error with create table

2002-02-12 Thread Jean Bernard
Hi i have this error with create table (Innodb) Error: 1005 - Can't create table '.\pdx\factures.frm' (errno: 150) ? Thank's MySQL 3.23.47 win32 - Before posting, please check: http://www.mysql.com/manual.php (the

error starting mysql

2001-11-01 Thread Jean Bernard
i have installed MySQL on W2000 my my.ini is : [mysqld] basedir=C:/MySQL #bind-address=192.168.0.1 datadir=C:/MySQL/data #language=C:/MySQL/share/your language directory #slow query log#= #tmpdir#= #port=3306 #set-variable=key_buffer=16M innodb_data_home_dir = c:/IbData innodb_data_file_path =

Re: error starting mysql

2001-11-01 Thread Jean Bernard
i log administrator i have created the directory c:\ibdata\ibdata1 same error.. Regards, Jean - Original Message - From: Heikki Tuuri [EMAIL PROTECTED] To: [EMAIL PROTECTED]; [EMAIL PROTECTED] Sent: Thursday, November 01, 2001 10:59 AM Subject: Re: error starting mysql Hi! I looked