I'm using MySQL 5.1.30 (WinXP) and user defined variables don't seem to be
working properly if the Select statement is sorted.
Here is a simple example:
CREATE TABLE `tmp` (
`Purch_Date` date DEFAULT NULL,
`Product` char(10) DEFAULT NULL
) ENGINE=MyISAM DEFAULT CHARS
He's using Delphi according to his first post. You might wanna use a
TClientDataSet if you're not doing so already. It provides a bit more
flexibility and won't keep the select query open for longer than is
necessary.
Have fun!
Walter
OlinData: Professional services for MySQL
Support * Consultin
On Sun, 18 Jan 2009 16:26:58 -0600, mos wrote:
> Walter,
> I just re-ran the program this time using my old 5.0 my.ini file
> (which worked fine with MySQL 5.0) with MySQL 5.1.30 and the same problem
> occurs, the Next statement loses connection to the MySQL 5.1 server after
> a
> whil
At 01:51 PM 1/18/2009, Walter Heck wrote:
Well, you could diff the old and the new conf and see if any of the
changes point you in the right direction. You could even post the diff
here so we can help you think :)
Walter
Walter,
I just re-ran the program this time using my old 5.0 my.in
Well, you could diff the old and the new conf and see if any of the
changes point you in the right direction. You could even post the diff
here so we can help you think :)
Walter
OlinData: Professional services for MySQL
Support * Consulting * Administration
http://www.olindata.com
On Sun, Jan
At 10:49 AM 1/18/2009, you wrote:
Have you compared my.cnf files? Is the system you installed it on the
same? I mean, did you reinstall the OS or anything? If not, we can
rule that out :)
I uninstalled MySQL 5.01 and installed MySQL 5.1 on the same machine
without re-installing XP Pro.
With 5.
At 10:19 AM 1/18/2009, you wrote:
On Sun, Jan 18, 2009 at 2:13 AM, mos wrote:
> I updated from MySQL 5.01 to 5.1 a few days ago. My Delphi application runs
> on XP with 3GB ram.
>
> I have a query #1 that executes a simple Select statement that fetches 5000
> rows from a single table sorted by d
Have you compared my.cnf files? Is the system you installed it on the
same? I mean, did you reinstall the OS or anything? If not, we can
rule that out :)
Walter
OlinData: Professional services for MySQL
Support * Consulting * Administration
On Sun, Jan 18, 2009 at 5:19 PM, Baron Schwartz wrot
On Sun, Jan 18, 2009 at 2:13 AM, mos wrote:
> I updated from MySQL 5.01 to 5.1 a few days ago. My Delphi application runs
> on XP with 3GB ram.
>
> I have a query #1 that executes a simple Select statement that fetches 5000
> rows from a single table sorted by date. (no joins)
>
> Inside a loop if
