Re: select * into outfile;mysql-delphi

2003-06-24 Thread Janice Wright
MySQL won't write data to a file if the file already exists. Make sure you've deleted the old file or given MySQL a new filename to write to. Jan -- Janice Wright Ingenta plc [EMAIL PROTECTED] http://www.ingentaselect.com/ Sometime recently Rahmat Hidayat said: > hello my friends.. i have so

Re: select * into outfile;mysql-delphi

2003-06-24 Thread Ivan Cukic
Rahmat> 2. how can i use mysql with delphi?please give me more explanation about it.. and must i have some application for it? Goto google and find "TmySQL delphi component". You will get the examples there too. Ivan --

select * into outfile;mysql-delphi

2003-06-23 Thread Rahmat Hidayat
hello my friends.. i have some problem : 1. when i drop data out into a file, sometimes i have some problem like the file can't be opened(when i save into .xls or .mdb or other) how can i solve this problem? 2. how can i use mysql with delphi?please give me more explanation about it.. and must i

MySQL DELPHI(Kylix) charset translation

2002-12-10 Thread Ing . Miloš Vymazal
Hi, I have problem with charset (MySQL + Delphi). -- SET CHARACTER SET cp1250_latin2; SELECT * FROM en1 WHERE en1 LIKE 'worm'; -- This query works right in PHP and command line (Linux, Windows), but in Delph

Fw: MySQL & Delphi 6

2002-11-21 Thread Patricio Díaz G .
y, November 20, 2002 1:07 AM Subject: RE: MySQL & Delphi 6 You can download winzeos for delphi I use it when connecting to MySQL Try searching it in google R.B.Roa Traffic Management Engineer PhilCom Corporation Tel. No. (Office) (088) 858-1028 (Home) (088) 858-8889 Mobile No. (63) (919-

RE: MySQL & Delphi 6

2002-11-20 Thread RBRoa
: Patricio Díaz G. [SMTP:[EMAIL PROTECTED]] Sent: Thursday, November 21, 2002 8:10 AM To: [EMAIL PROTECTED] Subject:Re: MySQL & Delphi 6 Thanks for anwering to my request. I started to practice with Delphi and Kylix in my free time, first

Re: MySQL & Delphi 6

2002-11-19 Thread Richard
As an alternative, you could try this: http://www.fichtner.net/delphi/mysql.delphi.phtml You need to be familiar with the C API unfortunately, but you end up doing a lot with just a few lines of code. > Can somebody help me with Delphi 6 and MySQL? > I'm using Delphi en a WinXP box and the MyS

RE: MySQL & Delphi 6

2002-11-19 Thread RBRoa
-1028 (Home) (088) 858-8889 Mobile No. (63) (919-3085267) -Original Message- From: Weiwei Wang [SMTP:[EMAIL PROTECTED]] Sent: Wednesday, November 20, 2002 3:13 PM To: [EMAIL PROTECTED] Subject: Re: MySQL & Delphi 6 H

Re: MySQL & Delphi 6

2002-11-19 Thread Veysel Harun Sahin
I think the standart tsqlconnection in delphi6 have some problems. Instead you can use ado or tmysqlconnection from "http://www.productivity.org/projects/mysql/";. Hope it helps. Patricio Díaz G. wrote: Can somebody help me with Delphi 6 and MySQL? I'm using Delphi en a WinXP box and the MySQL

RE: MySQL & Delphi 6

2002-11-19 Thread RBRoa
obile No. (63) (919-3085267) -Original Message- From: Weiwei Wang [SMTP:[EMAIL PROTECTED]] Sent: Wednesday, November 20, 2002 1:29 PM To: [EMAIL PROTECTED] Subject: Re: MySQL & Delphi 6 hi, could you tell me how

RE: MySQL & Delphi 6

2002-11-19 Thread RBRoa
: Patricio Díaz G. [SMTP:[EMAIL PROTECTED]] Sent: Wednesday, November 20, 2002 1:34 PM To: [EMAIL PROTECTED] Subject:MySQL & Delphi 6 Can somebody help me with Delphi 6 and MySQL? I'm using Delphi en a WinXP box and the MySQL server i

MySQL & Delphi 6

2002-11-19 Thread Patricio Díaz G .
Can somebody help me with Delphi 6 and MySQL? I'm using Delphi en a WinXP box and the MySQL server in a Linux box. I am having trouble connecting to the server with the CLX/dbExpress TSQLConnection component. Please, if somebody can help me, let me know and I'll explain the whole situation. Regard

MySQL & Delphi 6

2002-11-19 Thread Patricio Díaz G .
Can somebody help me with Delphi 6 and MySQL? I'm using Delphi en a WinXP box and the MySQL server in a Linux box. I am having trouble connecting to the server with the CLX/dbExpress TSQLConnection component. Please, if somebody can help me, let me know and I'll explain the whole situation. Regard

MYSQL & DELPHI COMPONENTS

2002-09-01 Thread Nick Lazidis
I wonder if someone could tell me if I can use Delphi 6's , ClientDataSet, Query, DataSetProvider, Database and UpdateSQL components with MYSQL or I have to look at an alternative third party library. Does MYSQL supports transactions with InnoDB type tables ? Thanks Nikos ---

Re: MySQL & Delphi

2001-09-02 Thread j.urban
Is it actually truncating data or is the width simply short? If it's the latter, you might want to have a look at the MyODBC settings for the connection. There is an option called something like, "Don't optimize column widths". If this is checked, MyODBC should return the entire column width.

Re: MySQL & Delphi

2001-09-02 Thread Mike
I use D5 and ZEOS without any problems other than it chocked on BLOBS but that was fixed. I also use ASTA http://www.astatech.com/freetools/EvalComps.htm and the ASTA MySQL Server. Works great. Cheers M;) Quote of the day; Programming is like sex: one mistake and you have to support it for the

Re: MySQL & Delphi

2001-09-02 Thread Elizabeth Alderton
ore secure' - whatever that means! They have a mailing list that you can join too, and the Delphi forums know quite a bit about Zeos as well. So support is good. Regards Elizabeth -Original Message- From: Ales Vaupotic <[EMAIL PROTECTED]> To: MySQL list (E-mail) <[EMAIL PR

MySQL & Delphi

2001-09-02 Thread Ales Vaupotic
Hello, I've got a problem with MySQL 3.23.41 on Solaris 8 and Delphi 5 Ent. on Windows 98. I installed the latest MyODBC a week ago and am using ADO components to connect to the server. The connection itself works but when I open the field editor of a table, char(50) is interpreted in Delphi as s