Re: [Lazarus] Support for MariaDB 10.0

2015-06-10 Thread Josef Schnieder

Thanks for this information.

I take the changes from the trunk and put it into the 2.6.4 source (only 
some lines depedence to  mariadb).

now it works.

Josef

Am 10.06.2015 um 08:53 schrieb Michael Van Canneyt:



On Tue, 9 Jun 2015, Josef Schnieder wrote:


Hi,

I have also problems to connect with TMySQL56Connection. The 
error-message is can not work with the installed MySql client 
version: Expected (5.6) got (10.0.13-MariaDB).

(fpc 2.6.4-2.10, lazarus 1.4.0.0, OpenSuse 13.2)


Well. The code checks if 5.6 or 10.0 is present in the version string 
reported by the client.
So normally it should work, but with trunk only. Not with 2.6.4. So 
you'll have to wait for the upcoming 3.0


Michael.



Josef


Am 09.06.2015 um 07:27 schrieb Michael Van Canneyt:



On Mon, 8 Jun 2015, Koenraad Lelong wrote:


Op 12-05-15 om 10:03 schreef leledumbo:

Any support for MariaDB 10.0 branch?
client library?


TMySQL56Connection can connect to MariaDB perfectly.


Hi,

I have the MariaDB 10.0.13 client-libs. TMySQL56Connection can not 
connect. Any solution ?


What is the error ?

Michael.

--
___
Lazarus mailing list
Lazarus@lists.lazarus.freepascal.org
http://lists.lazarus.freepascal.org/mailman/listinfo/lazarus



--
___
Lazarus mailing list
Lazarus@lists.lazarus.freepascal.org
http://lists.lazarus.freepascal.org/mailman/listinfo/lazarus



--
___
Lazarus mailing list
Lazarus@lists.lazarus.freepascal.org
http://lists.lazarus.freepascal.org/mailman/listinfo/lazarus



--
___
Lazarus mailing list
Lazarus@lists.lazarus.freepascal.org
http://lists.lazarus.freepascal.org/mailman/listinfo/lazarus


[Lazarus] Make table with TDataset structure

2015-06-10 Thread aradeonas
Hi,

I want to make MySQL table from a TDataset structure,is there any ready
to use tool? An example case : We have many SQLite DBs and want to
convert them to MySQL and  other than convert tools we can make TDataset
from SQLite and generate fields automatically and then make DDL MySQL
from TDataset and then run it and in the end insert all the data.

In summery I want to make table create code form Dataset structure.

Regards, Ara

-- 
http://www.fastmail.com - Same, same, but different...

--
___
Lazarus mailing list
Lazarus@lists.lazarus.freepascal.org
http://lists.lazarus.freepascal.org/mailman/listinfo/lazarus


Re: [Lazarus] Make table with TDataset structure

2015-06-10 Thread Michael Van Canneyt



On Wed, 10 Jun 2015, aradeonas wrote:


Hi,
 
I want to make MySQL table from a TDataset structure,is there any ready to use 
tool?
An example case :
We have many SQLite DBs and want to convert them to MySQL and  other than 
convert tools we can make TDataset from SQLite and
generate fields automatically and then make DDL MySQL from TDataset and then 
run it and in the end insert all the data.
 
In summery I want to make table create code form Dataset structure.


You can use the FPC data dictionary routines in fpdatadict:

TDDTableDef has ImportFromDataset 
and then you can use 
TFPDDSQLEngine.CreateCreateSQL 
to create a CREATE TABLE SQL statement.


Michael.--
___
Lazarus mailing list
Lazarus@lists.lazarus.freepascal.org
http://lists.lazarus.freepascal.org/mailman/listinfo/lazarus


Re: [Lazarus] Support for MariaDB 10.0

2015-06-10 Thread Michael Van Canneyt



On Tue, 9 Jun 2015, Josef Schnieder wrote:


Hi,

I have also problems to connect with TMySQL56Connection. The error-message is 
can not work with the installed MySql client version: Expected (5.6) got 
(10.0.13-MariaDB).

(fpc 2.6.4-2.10, lazarus 1.4.0.0, OpenSuse 13.2)


Well. 
The code checks if 5.6 or 10.0 is present in the version string reported by the client.
So normally it should work, but with trunk only. Not with 2.6.4. 
So you'll have to wait for the upcoming 3.0


Michael.



Josef


Am 09.06.2015 um 07:27 schrieb Michael Van Canneyt:



On Mon, 8 Jun 2015, Koenraad Lelong wrote:


Op 12-05-15 om 10:03 schreef leledumbo:

Any support for MariaDB 10.0 branch?
client library?


TMySQL56Connection can connect to MariaDB perfectly.


Hi,

I have the MariaDB 10.0.13 client-libs. TMySQL56Connection can not 
connect. Any solution ?


What is the error ?

Michael.

--
___
Lazarus mailing list
Lazarus@lists.lazarus.freepascal.org
http://lists.lazarus.freepascal.org/mailman/listinfo/lazarus



--
___
Lazarus mailing list
Lazarus@lists.lazarus.freepascal.org
http://lists.lazarus.freepascal.org/mailman/listinfo/lazarus



--
___
Lazarus mailing list
Lazarus@lists.lazarus.freepascal.org
http://lists.lazarus.freepascal.org/mailman/listinfo/lazarus


Re: [Lazarus] Support for MariaDB 10.0

2015-06-10 Thread Petr Hložek
I had the same problem. It's solved - I put updated source code to
dedicated subfolder into source folder of the project -
https://github.com/ok2cqr/cqrlog/tree/master/src/mysql

and added this folder to library path. I will delete this folder after fpc
3.0 will be released.

Petr

2015-06-10 12:25 GMT+02:00 Josef Schnieder m...@josef-schnieder.de:

 Thanks for this information.

 I take the changes from the trunk and put it into the 2.6.4 source (only
 some lines depedence to  mariadb).
 now it works.

 Josef


 Am 10.06.2015 um 08:53 schrieb Michael Van Canneyt:



 On Tue, 9 Jun 2015, Josef Schnieder wrote:

  Hi,

 I have also problems to connect with TMySQL56Connection. The
 error-message is can not work with the installed MySql client version:
 Expected (5.6) got (10.0.13-MariaDB).
 (fpc 2.6.4-2.10, lazarus 1.4.0.0, OpenSuse 13.2)


 Well. The code checks if 5.6 or 10.0 is present in the version string
 reported by the client.
 So normally it should work, but with trunk only. Not with 2.6.4. So
 you'll have to wait for the upcoming 3.0

 Michael.


 Josef


 Am 09.06.2015 um 07:27 schrieb Michael Van Canneyt:



 On Mon, 8 Jun 2015, Koenraad Lelong wrote:

  Op 12-05-15 om 10:03 schreef leledumbo:

 Any support for MariaDB 10.0 branch?
 client library?


 TMySQL56Connection can connect to MariaDB perfectly.

  Hi,

 I have the MariaDB 10.0.13 client-libs. TMySQL56Connection can not
 connect. Any solution ?


 What is the error ?

 Michael.

 --
 ___
 Lazarus mailing list
 Lazarus@lists.lazarus.freepascal.org
 http://lists.lazarus.freepascal.org/mailman/listinfo/lazarus



 --
 ___
 Lazarus mailing list
 Lazarus@lists.lazarus.freepascal.org
 http://lists.lazarus.freepascal.org/mailman/listinfo/lazarus


 --
 ___
 Lazarus mailing list
 Lazarus@lists.lazarus.freepascal.org
 http://lists.lazarus.freepascal.org/mailman/listinfo/lazarus



 --
 ___
 Lazarus mailing list
 Lazarus@lists.lazarus.freepascal.org
 http://lists.lazarus.freepascal.org/mailman/listinfo/lazarus

--
___
Lazarus mailing list
Lazarus@lists.lazarus.freepascal.org
http://lists.lazarus.freepascal.org/mailman/listinfo/lazarus


Re: [Lazarus] change the icon image of my running application

2015-06-10 Thread K. P.
this is one of many google results on the topic
http://stackoverflow.com/questions/17068684/change-application-taskbar-icon-at-run-timeignore-shortcut-icon
when in doubt, always check in the delphi context as well

Date: Wed, 10 Jun 2015 17:58:38 +0100
From: richard.m...@gmail.com
To: lazarus@lists.lazarus.freepascal.org
Subject: [Lazarus] change the icon image of my running application

Hi,

Does anybody know how I can change the image of my running application, like 
Skype does when a new notification has happened?

Effectively, I am wanting to update the running taskbar image by overlaying a 
numerical number to show the number of notifications in my app
Hope that makes sense
Richard

--
___
Lazarus mailing list
Lazarus@lists.lazarus.freepascal.org
http://lists.lazarus.freepascal.org/mailman/listinfo/lazarus
  --
___
Lazarus mailing list
Lazarus@lists.lazarus.freepascal.org
http://lists.lazarus.freepascal.org/mailman/listinfo/lazarus


[Lazarus] change the icon image of my running application

2015-06-10 Thread Richard Mace
Hi,
Does anybody know how I can change the image of my running application,
like Skype does when a new notification has happened?
Effectively, I am wanting to update the running taskbar image by overlaying
a numerical number to show the number of notifications in my app

Hope that makes sense

Richard
--
___
Lazarus mailing list
Lazarus@lists.lazarus.freepascal.org
http://lists.lazarus.freepascal.org/mailman/listinfo/lazarus


Re: [Lazarus] Export of wiki pages to html/chm

2015-06-10 Thread Werner Pamler
Could fix most of these issues by myself and will post a series of 
patches to bugtracker (http://bugs.freepascal.org/view.php?id=28274).


--
___
Lazarus mailing list
Lazarus@lists.lazarus.freepascal.org
http://lists.lazarus.freepascal.org/mailman/listinfo/lazarus


Re: [Lazarus] Make table with TDataset structure

2015-06-10 Thread aradeonas
Thank you,I'm working on it but it seems there isn't any alter table
option,am I right?

Regards,
Ara


-- 
http://www.fastmail.com - Does exactly what it says on the tin


--
___
Lazarus mailing list
Lazarus@lists.lazarus.freepascal.org
http://lists.lazarus.freepascal.org/mailman/listinfo/lazarus