Sign in Join

Live chat for Free Pascal, Lazarus, Delphi and every Pascal programmer.

Mailing lists / fpc-devel / 2008-11

SqlDB's TSQLScript backport request

5 messages · 2 people ·

Reply by email Subscribe to this list Your subscription

Read-only archive. Use j and k to move between messages.

Michael Van Canneyt
to Graeme Geldenhuys
Graeme Geldenhuys wrote 5 lines
Hi, Is there any chance that the TSQLScript.CommentsInSQL and TSQLScript.UseCommit properties could be backported from 2.3.1 to 2.2.3?

Yes. We decided to make a 2.2.4, and this will be in it.

Michael.

Reply by email

Graeme Geldenhuys
to Michael Van Canneyt
Michael Van Canneyt wrote 6 lines
> > Is there any chance that the TSQLScript.CommentsInSQL and > TSQLScript.UseCommit properties could be backported from 2.3.1 to > 2.2.3? Yes. We decided to make a 2.2.4, and this will be in it.

Ah, thanks Michael.

BTW: That component is a lifesaver! It makes setup and configuration of database applications a breeze. :-)

Regards,
- Graeme -

_______________________________________________
fpGUI - a cross-platform Free Pascal GUI toolkit
http://opensoft.homeip.net/fpgui/

Reply by email

Michael Van Canneyt
to Graeme Geldenhuys
Graeme Geldenhuys wrote 13 lines
On Wed, Nov 12, 2008 at 10:28 AM, Michael Van Canneyt wrote: >> >> Is there any chance that the TSQLScript.CommentsInSQL and >> TSQLScript.UseCommit properties could be backported from 2.3.1 to >> 2.2.3? > > Yes. We decided to make a 2.2.4, and this will be in it. Ah, thanks Michael. BTW: That component is a lifesaver! It makes setup and configuration of database applications a breeze. :-)

I know, that's what I use it for.
I developed it years ago. It's been in use for almost 10 years now. The only thing that was done is make it SQLDB-aware.

Currently it works as follows:
- Create Data dictionary with DB desktop.
- The FCL-DB Codegen units are used to create a unit that recreates the data dictionary in memory.
- When a new database is needed, another fcl-db codegen unit cretes the script.
- TSQLScript is run with this script to create the database.

Michael.

Reply by email

Graeme Geldenhuys
to Michael Van Canneyt
Michael Van Canneyt wrote 13 lines
> BTW: That component is a lifesaver! It makes setup and configuration > of database applications a breeze. :-) I know, that's what I use it for. I developed it years ago. It's been in use for almost 10 years now. The only thing that was done is make it SQLDB-aware. Currently it works as follows: - Create Data dictionary with DB desktop. - The FCL-DB Codegen units are used to create a unit that recreates the data dictionary in memory. - When a new database is needed, another fcl-db codegen unit cretes the script.

We don't use Laz Data Desktop for this yet. We currently use a tool called DB Dezign. It allows visual database design and generates the Create and Drop scripts for any of the supported DB backends. The scripts it generates is very neat. An awesome tool!

- TSQLScript is run with this script to create the database.

Yup. I've always had issues trying to use bash script and isql to create a blank database. TSQLScript makes this all childs play.

Regards,
- Graeme -

_______________________________________________
fpGUI - a cross-platform Free Pascal GUI toolkit
http://opensoft.homeip.net/fpgui/

Reply by email