Re: [Lazarus] Handy script for Firebird users

2008-05-01 Thread Graeme Geldenhuys
2008/4/30 mramirez <[EMAIL PROTECTED]>: > > Not everyone has the time to a SQL query in each table & verify that all > values, for an integer field are either 0 o 1, or varchar(1) with "f" and > "t". Just for interest sake and completeness You don't have to do such checks, the database does

Re: [Lazarus] Handy script for Firebird users

2008-04-30 Thread Joost van der Sluis
Op woensdag 30-04-2008 om 13:13 uur [tijdzone +0200], schreef Graeme Geldenhuys: > Joost van der Sluis wrote: > > And you didn't write it in Pascal because ? > > > > Joost > > Because the deployment PC's will not have FPC on them. > Ummm... Then again, it takes all the parameters it needs for

Re: [Lazarus] Handy script for Firebird users

2008-04-30 Thread Lee Jenkins
Graeme Geldenhuys wrote: > 2008/4/30 Tom York <[EMAIL PROTECTED]>: >> a few Linux servers, I can certainly see the benefit without question. > > Thank you! :) > >> Graeme, what is the largest FB concurrent user install you have >> running? My largest desktop application is 15 users. Can't

Re: [Lazarus] Handy script for Firebird users

2008-04-30 Thread Graeme Geldenhuys
2008/4/30 Tom York <[EMAIL PROTECTED]>: > a few Linux servers, I can certainly see the benefit without question. Thank you! :) > Graeme, what is the largest FB concurrent user install you have > running? My largest desktop application is 15 users. Can't tell you We have on average 30 conc

Re: [Lazarus] Handy script for Firebird users

2008-04-30 Thread Leonardo M. Ramé
This is off topic of course, but... You can use Generators (Sequences in other systems) joined to a trigger instead of AutoIncrement. You can simulate Boolean fields by creating a Domain. Leonardo M. Ramé http://leonardorame.blogspot.com Tom York escribió: > The only things I do not like about

Re: [Lazarus] Handy script for Firebird users

2008-04-30 Thread Tom York
Graeme, For what it is worth, I think it is COOL!Having deployed FB on quite a few Linux servers, I can certainly see the benefit without question. Graeme, what is the largest FB concurrent user install you have running? My largest desktop application is 15 users. Can't tell you the cou

Re: [Lazarus] Handy script for Firebird users

2008-04-30 Thread Michael Van Canneyt
On Wed, 30 Apr 2008, Graeme Geldenhuys wrote: > Joost van der Sluis wrote: > > And you didn't write it in Pascal because ? > > > > Joost > > Because the deployment PC's will not have FPC on them. > Ummm... Then again, it takes all the parameters it needs for > customization. Also, if I ma

Re: [Lazarus] Handy script for Firebird users

2008-04-30 Thread Henry Vermaak
2008/4/30 Graeme Geldenhuys <[EMAIL PROTECTED]>: > Joost van der Sluis wrote: > > And you didn't write it in Pascal because ? > > > > Joost > > Because the deployment PC's will not have FPC on them. > Ummm... Then again, it takes all the parameters it needs for > customization. Also, if I

Re: [Lazarus] Handy script for Firebird users

2008-04-30 Thread Graeme Geldenhuys
Joost van der Sluis wrote: > And you didn't write it in Pascal because ? > > Joost Because the deployment PC's will not have FPC on them. Ummm... Then again, it takes all the parameters it needs for customization. Also, if I make it a console app, it will be cross-platform to. :) How to yo

Re: [Lazarus] Handy script for Firebird users

2008-04-30 Thread Joost van der Sluis
And you didn't write it in Pascal because ? Joost Op woensdag 30-04-2008 om 11:28 uur [tijdzone +0200], schreef Graeme Geldenhuys: > Hi, > > I created a script (Unix/Linux only at the moment) called 'mkdb' for use > with our application deployment. We use the Firebird RDBMS and thought > t

[Lazarus] Handy script for Firebird users

2008-04-30 Thread Graeme Geldenhuys
Hi, I created a script (Unix/Linux only at the moment) called 'mkdb' for use with our application deployment. We use the Firebird RDBMS and thought this might come in handy for others as well. It creates a Firebird database, creates the tables. Optionally it creates Views, applies table righ