Tips Delphi

RSS Feed Homepage

Articles: 1, 2

Backup in Firebird
2007-07-06 07:22:00
There is nice article in here that explain a lot of things about backup database in Firebird (including command reference). This article is lack of explanation about Firebird new incremental backup (but you can find about this incremental backup on your Firebird 2 release notes). Hope you like it.Fonte: http://firebird-with-delphi.blogspot.com
More About: Backup

Firebird 2.0.1 and ZeosDBO 6.6.1 beta
2007-07-06 07:22:00
Yeah I know it's late to let you know thorough this Blog that Firebird 2.01 and ZeosDBO 6.6.1 beta is released, but if you don't know then I hope this little blog can let you know more.Firebird 2.0.1 is only bug fixed and there is nothing new feature.ZeosDBO 6.6.1 beta is only bug fixed and there is nothing new feature.Fonte: http://firebird-with-delphi.blogspot.com
More About: Beta

Recomended Page Size in Firebird
2007-07-06 07:21:00
If you using Firebird database then the best setting for id set the page size to 4096 and use SQL Dialect 3Fonte: http://firebird-with-delphi.blogspot.com
More About: Page , Size

FB2.0 New Interesting Feature
2007-07-06 07:20:00
Today, I just know after reading my email from firebird-support that show the new feature of FB2.0 the complete article can be found here but that article is not in English :( (If someone here know what language in that site is used, please tell me because I want to translate it using Altavista Babel fish) I just read the example from that article and try it. The one that I like, is the new function on ODS 11 and it can be used like this:select rdb$get_context('SYSTEM', 'NETWORK_PROTOCOL') as protocol , rdb$get_context('SYSTEM', 'CLIENT_ADDRESS') as client_addressfrom rdb$database;In ODS 11 we have the built in UDF rdb$get_context and rdb$set_context you can read more information from the doc directory that come with FB2.0 the file is:"README.context_variables2.txt"Fonte: http://firebird-with-delphi.blogspot.com
More About: Interesting , Feature , Eres

Upgrading Firebird 1.5 to 2.0
2007-07-06 06:34:00
Yeah, last week I try to install the new Firebird 2.0. And it's easy to migrate the old ODS 10.1 (FB 1.5) to ODS 11 (FB2.0) what you need to do is:1. Uninstall Firebird 1.5.3 (if yu wish not to use it again)2. Install the Firebird 2.03. Backup your old database with this new gbak from FB2.04. Restore them back with gbak from FB 2.05. Now you have the new database with ODS 11Hope this little article can help you :)Fonte: http://firebird-with-delphi.blogspot.com

Firebird 2.0 is Out, what about me?
2007-07-06 06:33:00
On 13 November 2006 Firebird 2.0 is launch on the opening of Firebird Conference. I already download it, but I'm still using version 1.5.3 for my real application and just try version 2.0 in my research computer. Why? because I still wait for the version 2.1 =) As you know usually the early version still have a bug or the feature that is not yet complete. But if you are a new Firebird user then you must download this 2.0 and evaluate it. I still wait for the roadmap of the Firebird development that usually out after the Firebird conference to see what feature that I neeed most for my current project. It's happy to see that this community so activeFonte: http://firebird-with-delphi.blogspot.com

ReInstalling Component That Using ZeosDBO 6.6 beta
2007-07-06 06:33:00
Today I try again to ReInstall my components that using ZeosDBO. I want to try this new beta version (version 6.6 beta) so I must clean up my past ZeosDBO 6.1.5. The difficulty that I found when intalling version 6.6 beta is that the seacrh directory and the output directory (from the ZeosDBO.bpg) must be set first (so It's not easy installation for Delphi user that just learn how to install Delphi components), I think they will fix this later for stable version (as they did for 6.1.5 version).The point is this new version has a simple bpl & dcp created. Before version 6.6 there is many bpl & dcp respectively for the "ZComponent ", "ZCore", "ZPlain" and others. But in this 6.6 version the bpl & dcp is only "ZComponentDesign.dcp" and "ZComponentDesign70.bpl" so I must delete the requires dcp for my components and replace with this new dcp. That's all and everythings goes well (of course after I fix the property "RequestLive" with "ReadOnly")Fonte: http://firebird-with-delphi.blogspo...
More About: Beta

Explicit Cursor in Firebird PSQL
2007-07-06 06:30:00
Explicit cursor is a new this in Firebird because it's only available in version 2. We can found this syntax in the release notes on Stored Procedure Language (PSQL) section. The example below is taken from that release notesDECLARE RNAME CHAR(31);DECLARE C CURSOR FOR ( SELECT RDB$RELATION_NAME FROM RDB$RELATIONS );BEGIN OPEN C; WHILE (1 = 1) DO BEGIN FETCH C INTO :RNAME; IF (ROW_COUNT = 0) THEN LEAVE; SUSPEND; END CLOSE C;END Fonte: http://firebird-with-delphi.blogspot.com
More About: Cursor

Implicit Cursor in Firebird PSQL
2007-07-06 06:30:00
Firebird has an implicit cursor, we can found the example in the example database employee.fdb, and we can find in the "DEPT_BUDGET" stored procedure, lets look into the source, the implicit cursor has the syntax:FOR [select statement] into [local variable that hold the value from select]DOBEGIN [your statement]ENDThe local variable is must defined for each of the field that selected and remember the datatype must be the sameFonte: http://firebird-with-delphi.blogspot.com
More About: Cursor