Italiano - English

Categories: Database

See also:

Standard deviation numerically stable calculation for SQL

17-06-2014 37315 5

Despite of Standard Deviation is one of most relevant parameter of descriptive statistics, it isn't available as common aggregation function for some SQL server. Here is described how to calculate and use standard deviation in a single select query. Finally a better and numerically stable sql procedure is shown.

OpenERP 7.0

17-05-2013 17712

General Notes on OpenERP 7.0

Firebird: Tree data mangement

05-01-2011 18236

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

Firebird: A safe trigger for autoinc fields

17-12-2010 12298 2

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.

PkBdeToSql: Paradox databases to SQL Converter

14-01-2010 23319 5

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