Welcome, Guest
Username: Password: Remember me
Components and Libraries for Database Development, discussions, problems and suggestions
  • Page:
  • 1

TOPIC:

MySQL 5.0 Troubles on windows 11 years 5 months ago #4070

  • gulyone
  • gulyone's Avatar Topic Author
  • Offline
  • Junior Member
  • Junior Member
  • Posts: 99
  • Thank you received: 5
Hi ,

there is a little problem I found , it's maybe useful for you to know :

On CT 4.20 I have a form with a table linked on a datasource that displays the content of a MySQL 5.0.96 data table. It works Great , at build time and at compile time. I copied the libmysql.dll version 5.0.96 to the bin32 folder AND to the compile folder.

I am on Windows 7 64bits, using lazarus32 from CT 4.20, all went Ok !

then I 1st updated to CT 4.30...

Opening my project , the table on the form displayed empty , I checked connection in my data module, connection= TRUE, SQLTransaction = ACTIVE , i checked SQluery , got a fatal error "cannot use with no select SQL statement !" , opened it , the SQL statement was there as on CT 4.20 "select * from `users`;"

then I removed CT totally , cleaned windows registry, reinstalled CT 4.30 from new full download and... I got exactly the same issue !

finally I downloaded again a CT 4.20 and installed it

All works FINE , no missing select SQL statement

any idea ?

Regards

Please Log in or Create an account to join the conversation.

Last edit: by gulyone.

MySQL 5.0 Troubles on windows 11 years 5 months ago #4071

  • Marius
  • Marius's Avatar
  • Offline
  • Junior Member
  • Junior Member
  • Posts: 24
  • Thank you received: 1
The problem has been reported in another thread.
www.pilotlogic.com/sitejoom/index.php/fo...tabase-desktop-error
Thanks.

Please Log in or Create an account to join the conversation.

Last edit: by Marius.

MySQL 5.0 Troubles on windows 11 years 5 months ago #4072

  • gulyone
  • gulyone's Avatar Topic Author
  • Offline
  • Junior Member
  • Junior Member
  • Posts: 99
  • Thank you received: 5
huh , not really ! even if it maybe relies.

I ain't talking about external tools , I'm talking about issues using SQLquery component INSIDE the IDE , and the thread you mentioned said the external tool works ok with MySQL 5.0. I said it doesn't INSIDE the IDE. Very Different !

Please Log in or Create an account to join the conversation.

Last edit: by gulyone.

MySQL 5.0 Troubles on windows 11 years 5 months ago #4074

  • Sternas Stefanos
  • Sternas Stefanos's Avatar
  • Offline
  • Moderator
  • Moderator
  • Ex Pilot, M.Sc, Ph.D
  • Posts: 4535
  • Thank you received: 1114
Please read here

we want your help...
PilotLogic Architect and Core Programmer

Please Log in or Create an account to join the conversation.

  • Page:
  • 1