This document shown two different way for server side managment of Data Tree with Firebird. First method uses Recursive Common Table Expression. Second method uses Recursive Stored Procedure
This document shown how to use Firebird Recursive Common Table Expression to managing trees
This document shown how to use Firebird Recursive Stored Procedure to walking trees
As you know, Firebird doesn’t have Autoinc fields but you can use triggers and sequences (generators) in order to obtain Autoinc features. On the web you can find many example about this.
Unfortunately I can’t find examples where triggered field (autoinc field) could receive a NOT NULL value, as is in data import from script. Following common examples, when the triggered field receives a value, the generator isn’t incremented so you may have “key violation” on future inserts.
In this document is shown a safe trigger example that can be used also when the triggered filed could receive a value.
Free Portable convertor from BDE / Paradox database to sql text file.
It dumps BDE full database or selected tables to sql file using LocalSQL dialects. Is very usefull to put paradox tables under version control but it cab be used with to migrate BDE database to new sql DB also