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,

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, plea

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 manual

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! >

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 = ib