Re: [fpc-pascal] Looking for a Firebird book?

2008-04-09 Thread Bee
I do think that every method, technique must remain a mean, not a goal. +1 :) -Bee- has Bee.ography at: http://beeography.wordpress.com ___ fpc-pascal maillist - fpc-pascal@lists.freepascal.org http://lists.freepascal.org/mailman/listinfo/fpc-pasc

Re: [fpc-pascal] Constant parameters and double types

2008-04-09 Thread Luiz Americo Pereira Camara
Luiz Americo Pereira Camara wrote: I'm evaluating the effect of passing function parameters by value or by reference. Like stated in the documentation, passing as reference (const) or by value types with size equal to pointer size like Integer has no difference in the code output (they are pa

Re: [fpc-pascal] Serial unit for Linux and Windows

2008-04-09 Thread Tomas Hajny
On Thu, April 10, 2008 01:11, Stephano wrote: . . > 4- Windows SerOpen function (based on CreateFile) returns an > INVALID_HANDLE_VALUE if the device could not be found. How to unify for > both Linux & Windows? Is it safe to return instead -1 (as in the Linux > case)? . . If I read the Windows

Re: [fpc-pascal] Succ() and Pred() operations

2008-04-09 Thread Tomas Hajny
On Wed, April 9, 2008 23:55, Ricardo Viégas wrote: Hi Ricardo, > I have installed FPC 2.2.0 [2007/09/09] a few days ago on my > WinXP-Pro-SP2, and I'm just taking a Web Tutorial on the language. > when I come to "User defined variable types", I decided to make the > following test: > > Program

Re: [fpc-pascal] "Building-Block" Design - or putting it all together ; -)

2008-04-09 Thread Paul Nicholls
- Original Message - From: "MPDJ" <[EMAIL PROTECTED]> To: "FPC-Pascal users discussions" Sent: Wednesday, April 09, 2008 10:56 PM Subject: [fpc-pascal] "Building-Block" Design - or putting it all together ;-) I've been following this list for sometime, but I'm not a professional cod

[fpc-pascal] Serial unit for Linux and Windows

2008-04-09 Thread Stephano
I am planning to improve, if possible, the serial units for both Linux and Windows, but have a few questions before I proceed any further: 1- I guess the unit rtl\win\wininc\struct.inc has 2 bugs: a- bm_DCB_fRtsControl = $3000. It should be $2000. b- bm_DCB_fDtrControl = $30. It

[fpc-pascal] Succ() and Pred() operations

2008-04-09 Thread Ricardo Viégas
Hi there! I have installed FPC 2.2.0 [2007/09/09] a few days ago on my WinXP-Pro-SP2, and I'm just taking a Web Tutorial on the language. when I come to "User defined variable types", I decided to make the following test: Program Test (Output); Type Vars = (var0, var1); Var x : Vars; Begin x

Re: [fpc-pascal] Looking for a Firebird book?

2008-04-09 Thread afpTeam
>On 09/04/2008, Michael Van Canneyt <[EMAIL PROTECTED]> wrote: My point of view is that a database is for storage, not for logic... From: "Graeme Geldenhuys Wednesday, April 09, 2008 3:35 PM A very logical assumption. ;-) And one I fully agree with. Use the correct tool for the job, hence t

Re: [fpc-pascal] Looking for a Firebird book?

2008-04-09 Thread Inoussa OUEDRAOGO
Hi, 2008/4/9, Graeme Geldenhuys <[EMAIL PROTECTED]>: > On 09/04/2008, Bee <[EMAIL PROTECTED]> wrote: > > > > I used to think that way too. But, based on my personal experience, in > > certain conditions and requirements, implementing logic in database is > > inevitable. That's why many databa

Re: [fpc-pascal] Looking for a Firebird book?

2008-04-09 Thread Graeme Geldenhuys
On 09/04/2008, Bee <[EMAIL PROTECTED]> wrote: > > I used to think that way too. But, based on my personal experience, in > certain conditions and requirements, implementing logic in database is > inevitable. That's why many databases support server side logic though it's > implemented in various w

Re: [fpc-pascal] Looking for a Firebird book?

2008-04-09 Thread Graeme Geldenhuys
On 09/04/2008, Michael Van Canneyt <[EMAIL PROTECTED]> wrote: > My point of view is that a database is for storage, not for logic... A very logical assumption. ;-) And one I fully agree with. Use the correct tool for the job, hence the reason we don't use stored procedures either. Regards, -

Re: [fpc-pascal] Looking for a Firebird book?

2008-04-09 Thread Bee
My point of view is that a database is for storage, not for logic... I used to think that way too. But, based on my personal experience, in certain conditions and requirements, implementing logic in database is inevitable. That's why many databases support server side logic though it's implem

Re: [fpc-pascal] Looking for a Firebird book?

2008-04-09 Thread Michael Van Canneyt
On Wed, 9 Apr 2008, Matt Emson wrote: > Michael Van Canneyt wrote: > > On Wed, 9 Apr 2008, Marco van de Voort wrote: > > > > > > > IIRC Mass insertion could bring down the db (slow to an effective DOS to > > > other users) unless you commit the transaction every 1 items or so. > > >

Re: [fpc-pascal] Looking for a Firebird book?

2008-04-09 Thread Matt Emson
Michael Van Canneyt wrote: On Wed, 9 Apr 2008, Marco van de Voort wrote: IIRC Mass insertion could bring down the db (slow to an effective DOS to other users) unless you commit the transaction every 1 items or so. Not in my experience: over 600.000 records inserted in 1 transactio

Re: [fpc-pascal] Looking for a Firebird book?

2008-04-09 Thread Michael Van Canneyt
On Wed, 9 Apr 2008, Marco van de Voort wrote: > > On Wed, 9 Apr 2008, Matt Emson wrote: > > > > The only negative thing I can say about Firebird is that it can produce > > a corrupt backup file. > > IIRC Mass insertion could bring down the db (slow to an effective DOS to > other users) unless

Re: [fpc-pascal] Looking for a Firebird book?

2008-04-09 Thread Inoussa OUEDRAOGO
2008/4/9, Michael Van Canneyt <[EMAIL PROTECTED]>: > I do it like that too, because the security model of any RDBM is ridiculous, > firebird is no exception. > > Security must be specified at a functional level, never at the table level. Absolutely. And security model at the RDBM level prevents

Re: [fpc-pascal] Looking for a Firebird book?

2008-04-09 Thread Joost van der Sluis
Op woensdag 09-04-2008 om 09:02 uur [tijdzone +0200], schreef Graeme Geldenhuys: > Hi, > > Anybody know of a Firebird book I can purchase? Language needs to be in > English. > > I'm looking for something that covers the SQL syntax, DB tuning and > importantly, security. > > The latter is one ma

[fpc-pascal] "Building-Block" Design - or putting it all together ; -)

2008-04-09 Thread MPDJ
I've been following this list for sometime, but I'm not a professional coder like most of you guys here so forgive me if this is obvious or long-winded.. I've been writing small apps for many years, but am now working on by far my largest yet and I'm having trouble working out the best way to

Re: [fpc-pascal] Looking for a Firebird book?

2008-04-09 Thread Graeme Geldenhuys
Damien Gerard wrote: However needs are not the same so I wanted to know when it would be a good choice to use Firebird if someone asks me. Considering we are still using MS Access (1) which currently handles 20-40 connections - any upgrade to a 'real' database server is a big plus for us deve

Re: [fpc-pascal] Looking for a Firebird book?

2008-04-09 Thread Matt Emson
Marco van de Voort wrote: On Wed, 9 Apr 2008, Matt Emson wrote: The only negative thing I can say about Firebird is that it can produce a corrupt backup file. IIRC Mass insertion could bring down the db (slow to an effective DOS to other users) unless you commit the transaction every 1000

RE: [fpc-pascal] Looking for a Firebird book?

2008-04-09 Thread Codebue Fabio - P-Soft
Take a look to a new Firebird 2.1 next month and probably you will change your idea about it... UDF: FreeAdHocUDF, a lot of internal SQL function... and if you wanna a good book www.ibphoenix.com Helen Borrie book... a MUST! Codebue Fabio .-. _ \ __| _||

Re: [fpc-pascal] Looking for a Firebird book?

2008-04-09 Thread Matt Emson
Michael Van Canneyt wrote: Strange that you say this. We have firebird databases in production at more than a thousand sites, ranging from simple desktop installations to sites with more than 500 simultaneous users. Firebird didn't fail on us once. Interbase 7.1 and 7.5 were very bad. Interbas

Re: [fpc-pascal] Looking for a Firebird book?

2008-04-09 Thread Marco van de Voort
> On Wed, 9 Apr 2008, Matt Emson wrote: > > The only negative thing I can say about Firebird is that it can produce > a corrupt backup file. IIRC Mass insertion could bring down the db (slow to an effective DOS to other users) unless you commit the transaction every 1 items or so. ___

Re: [fpc-pascal] help: converting windows API to linux

2008-04-09 Thread Marco van de Voort
> > You should rewrite the whole unit in a cross-platform manner. > > Is it possible? There is no general rule. Sometimes you'd have to rewrite significant parts, sometimes it is substituting a few calls. First try to define what abstract functionality you exactly use, instead of what you use on

Re: [fpc-pascal] help: converting windows API to linux

2008-04-09 Thread Graeme Geldenhuys
Bee wrote: You should rewrite the whole unit in a cross-platform manner. Is it possible? I read somewhere that the behavior API of Windows is Yes it's possible, but nobody said it would be easy. :-) I've done this a few times before. IBM's website had some good documentation on porting Wi

Re: [fpc-pascal] Looking for a Firebird book?

2008-04-09 Thread Graeme Geldenhuys
Matt Emson wrote: Yes. I've seen that in a number of IB/FB apps. It is fairly common. But, Excellent! also common to create a non SYSDBA user too for that purpose. Be careful Yes, we do not use the SYSDBA account in our applications. Each DB has it's own 'owner' account. Regards, -

Re: [fpc-pascal] Looking for a Firebird book?

2008-04-09 Thread Graeme Geldenhuys
Michael Van Canneyt wrote: I do it like that too, because the security model of any RDBM is ridiculous, firebird is no exception. Security must be specified at a functional level, never at the table level. I'm glad we are not the only ones that think like that. :-) I tried once at the tab

Re: [fpc-pascal] Looking for a Firebird book?

2008-04-09 Thread Graeme Geldenhuys
Matt Emson wrote: The bigger issue with Firebird was that it was so unstable (but then, so is Interbase) and required a lot of fiddling to stop it misbehaving We have not detected any stability issues with Firebird in the last three years that we used it. It's a simply deploy and forget RDM

Re: [fpc-pascal] Looking for a Firebird book?

2008-04-09 Thread Matt Emson
Graeme Geldenhuys wrote: ... At the moment we simply hard-code a firebird username and password in the application to create the connection, then access our own 'users' table to manage access to our application. Is that how everybody else does it with Firebird? Yes. I've seen that in a number o

Re: [fpc-pascal] Looking for a Firebird book?

2008-04-09 Thread Michael Van Canneyt
On Wed, 9 Apr 2008, Matt Emson wrote: > Graeme Geldenhuys wrote: > > Any documentation for Interbase 5.5 or 6.0 should be fairly helpful. > > TBH, the way Firebird did security last time I looked, was pretty similar to > the way SQL Server does it if you don't use integrated security. Adding u

Re: [fpc-pascal] Looking for a Firebird book?

2008-04-09 Thread Matt Emson
Graeme Geldenhuys wrote: Any documentation for Interbase 5.5 or 6.0 should be fairly helpful. TBH, the way Firebird did security last time I looked, was pretty similar to the way SQL Server does it if you don't use integrated security. Adding users was hell, but adding grants etc was pretty si

Re: [fpc-pascal] Looking for a Firebird book?

2008-04-09 Thread Damien Gerard
Le Apr 9, 2008 à 10:47 AM, Graeme Geldenhuys a écrit : On 09/04/2008, Damien Gerard <[EMAIL PROTECTED]> wrote: Does their documentation not suitable to you ? From MSSQL To Firefird http://www.firebirdsql.org/manual/migration-mssql.html I did find that, but it doesn't cover security access f

Re: [fpc-pascal] Looking for a Firebird book?

2008-04-09 Thread Michael Van Canneyt
On Wed, 9 Apr 2008, Graeme Geldenhuys wrote: > On 09/04/2008, Damien Gerard <[EMAIL PROTECTED]> wrote: > > > > Does their documentation not suitable to you ? > > > > From MSSQL To Firefird > > http://www.firebirdsql.org/manual/migration-mssql.html > > I did find that, but it doesn't cover se

Re: [fpc-pascal] help: converting windows API to linux

2008-04-09 Thread Michael Van Canneyt
On Wed, 9 Apr 2008, Bee wrote: > > You should rewrite the whole unit in a cross-platform manner. > > Is it possible? I read somewhere that the behavior API of Windows is pretty > much different to API of Linux (and other uni*x platform). Maybe I'll end up > writing a specific unit for each plat

Re: [fpc-pascal] Looking for a Firebird book?

2008-04-09 Thread Graeme Geldenhuys
On 09/04/2008, Damien Gerard <[EMAIL PROTECTED]> wrote: > > Does their documentation not suitable to you ? > > From MSSQL To Firefird > http://www.firebirdsql.org/manual/migration-mssql.html I did find that, but it doesn't cover security access from applications to Firebird. eg: * MSSQL has s

Re: [fpc-pascal] help: converting windows API to linux

2008-04-09 Thread Bee
You should rewrite the whole unit in a cross-platform manner. Is it possible? I read somewhere that the behavior API of Windows is pretty much different to API of Linux (and other uni*x platform). Maybe I'll end up writing a specific unit for each platform. :( -Bee- has Bee.ography at: http

Re: [fpc-pascal] Looking for a Firebird book?

2008-04-09 Thread Graeme Geldenhuys
On 09/04/2008, Michael Van Canneyt <[EMAIL PROTECTED]> wrote: > > What's wrong with the firebird book by helen borrie ? > > http://www.ibphoenix.com/ I only found their book section now... :-) Most books are in Portuguese, German (including yours )... I'm trying to find a Table of Contents for t

Re: [fpc-pascal] help: converting windows API to linux

2008-04-09 Thread Michael Van Canneyt
On Wed, 9 Apr 2008, Bee wrote: > Hi all, > > I've been trying to convert a Delphi unit to FPC. The problem is the unit > utilizes lots of low level windows APIs, such as: VirtualProtect, CreateEvent, > CloseHandle, etc. Due my lack of linux low level API knowledge, I hope someone > here could s

[fpc-pascal] help: converting windows API to linux

2008-04-09 Thread Bee
Hi all, I've been trying to convert a Delphi unit to FPC. The problem is the unit utilizes lots of low level windows APIs, such as: VirtualProtect, CreateEvent, CloseHandle, etc. Due my lack of linux low level API knowledge, I hope someone here could show me where to find a complete guide abo

Re: [fpc-pascal] Looking for a Firebird book?

2008-04-09 Thread Michael Van Canneyt
On Wed, 9 Apr 2008, Graeme Geldenhuys wrote: > Hi, > > Anybody know of a Firebird book I can purchase? Language needs to be in > English. > > I'm looking for something that covers the SQL syntax, DB tuning and > importantly, security. > > The latter is one major issue I have with Firebird. I

Re: [fpc-pascal] Looking for a Firebird book?

2008-04-09 Thread Damien Gerard
Le Apr 9, 2008 à 9:02 AM, Graeme Geldenhuys a écrit : Hi, Anybody know of a Firebird book I can purchase? Language needs to be in English. I'm looking for something that covers the SQL syntax, DB tuning and importantly, security. The latter is one major issue I have with Firebird. It's sec

[fpc-pascal] Looking for a Firebird book?

2008-04-09 Thread Graeme Geldenhuys
Hi, Anybody know of a Firebird book I can purchase? Language needs to be in English. I'm looking for something that covers the SQL syntax, DB tuning and importantly, security. The latter is one major issue I have with Firebird. It's security model is very different to MS SQL Server, and I'm stru