Re: [Lazarus] Make table with TDataset structure

2015-06-25 Thread aradeonas
Thank you very much Michael.Now I learned how to do this.hope this help others too.Maybe renaming it to CreateSQLFromTableStructure or something like this help to find easier in the future needs of others. Ara -- http://www.fastmail.com - Does exactly what it says on the tin -- __

Re: [Lazarus] Make table with TDataset structure

2015-06-25 Thread Michael Van Canneyt
On Mon, 22 Jun 2015, aradeonas wrote: Vary good. Please let me know when it ready. I committed the example, it's called 'createsql'. It's about 200 lines of code. It should work with all supported database types. Examples: home: >./createsql -h Usage: /home/michael/FPC/trunk/packages/fcl-d

Re: [Lazarus] Make table with TDataset structure

2015-06-22 Thread aradeonas
Vary good. Please let me know when it ready. Regards, Ara -- http://www.fastmail.com - Send your email first class -- ___ 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-22 Thread Michael Van Canneyt
On Mon, 22 Jun 2015, aradeonas wrote: Easy solution,Thank you very much Marc. But I was strugling to how use TFPDDSQLEngine as Michael said,it implements all we need but how use it for a current table for making insert,update,generate sql code is a question for me that maybe Michael can tell u

Re: [Lazarus] Make table with TDataset structure

2015-06-22 Thread aradeonas
Easy solution,Thank you very much Marc. But I was strugling to how use TFPDDSQLEngine as Michael said,it implements all we need but how use it for a current table for making insert,update,generate sql code is a question for me that maybe Michael can tell us. Regards, Ara -- http://www.fastmail.

Re: [Lazarus] Make table with TDataset structure

2015-06-22 Thread Marc Santhoff
On Mo, 2015-06-22 at 04:11 -0700, aradeonas wrote: > Thank you Marc,very interesting point but now Im talking about INSERT > SQL COMMAND. Sorry, I read too fast over your mail. > I want to make insert sql command for a table ,for example : > INSERT INTO table1(Filed1,Filed2) VALUES(:Filed1,:Filed

Re: [Lazarus] Make table with TDataset structure

2015-06-22 Thread aradeonas
Thank you Marc,very interesting point but now Im talking about INSERT SQL COMMAND. I want to make insert sql command for a table ,for example : INSERT INTO table1(Filed1,Filed2) VALUES(:Filed1,:Filed2); I know its possible because Lazarus data desktop do this but I count find out how and I thought

Re: [Lazarus] Make table with TDataset structure

2015-06-21 Thread Marc Santhoff
On So, 2015-06-21 at 14:01 -0700, aradeonas wrote: > Yes I went with TSQLQuery but problem is how to get insert query > automatically. So for example for Table1 without writing insert code I > get insert SQL code. > In lazarus database desktop tool,app do that but I can find out how to > to do like

Re: [Lazarus] Make table with TDataset structure

2015-06-21 Thread aradeonas
Yes I went with TSQLQuery but problem is how to get insert query automatically. So for example for Table1 without writing insert code I get insert SQL code. In lazarus database desktop tool,app do that but I can find out how to to do like that. Regards, Ara -- http://www.fastmail.com - Send you

Re: [Lazarus] Make table with TDataset structure

2015-06-20 Thread Marc Santhoff
On Sa, 2015-06-20 at 06:36 -0700, aradeonas wrote: > No,I explained it badly. I mean working on Lazarus Data Desktop source > didnt help to do what I want otherwise its a very good app,if I didnt go > wrong you write the code more than 7 years ago and its clean,codes like > this show me how to writ

Re: [Lazarus] Make table with TDataset structure

2015-06-20 Thread aradeonas
No,I explained it badly. I mean working on Lazarus Data Desktop source didnt help to do what I want otherwise its a very good app,if I didnt go wrong you write the code more than 7 years ago and its clean,codes like this show me how to write code professionally. I want to do what this app done in a

Re: [Lazarus] Make table with TDataset structure

2015-06-20 Thread Michael Van Canneyt
On Sat, 20 Jun 2015, aradeonas wrote: Its been hours I'm struggling with this case that I want to make create sql from a sqlite table. I have db and table name and I want to make a create sql. work on Lazarus Data Desktop didnt help me so I have to ask. What exactly did not work ? I opened

Re: [Lazarus] Make table with TDataset structure

2015-06-20 Thread aradeonas
Its been hours I'm struggling with this case that I want to make create sql from a sqlite table. I have db and table name and I want to make a create sql. work on Lazarus Data Desktop didnt help me so I have to ask. Regards, Ara -- http://www.fastmail.com - Access all of your messages and folde

Re: [Lazarus] Make table with TDataset structure

2015-06-11 Thread aradeonas
Thank you I found it,its name is fpdddiff.pp . I will work on it. Regards, Ara -- http://www.fastmail.com - Or how I learned to stop worrying and love email again -- ___ Lazarus mailing list Lazarus@lists.lazarus.freepascal

Re: [Lazarus] Make table with TDataset structure

2015-06-10 Thread Michael Van Canneyt
On Wed, 10 Jun 2015, aradeonas wrote: Thank you,I'm working on it but it seems there isn't any alter table option,am I right? There is a differ, in fpddiff.pp I don't think it generates SQL (yet) Michael. -- ___ Lazarus mailing list Lazarus@lists

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.laza

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 auto

[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 TDatase