>
>Thank you. I modified it also to upsize data to a PostgreSQL database also.
>
>I have a column in a dbf file named TIMESTAMP .
>I modified your CREATE TABLE generation code to include double quotes around
>field names
>

\\"<<laFlds[i,1]>>" <<laFBTypes[lnFieldTypeRange]>>

>
>but this still causes error. How to fix it ?
>(This error does not occur in PostgreSQL ).

The trouble with columns with reserved Firebird names is that must be enclosed in double quotes in DDL and DML statements, so, if you use double quotes on DML, modify the code to use them in DML statements (with cursor adapter is easy, by changing UpdateNameList).
Also, the ODBC driver has QuotedIdentifier option, that controls the addition of double quotes to column names.

>
>Also, why you don't use VFP tag nimes as index names but create index names
>like table_1 , table_2 etc.

Was exacly like this, but I had troubles with the index name length (limited to 31 chars) - see lcIndexName variable

>
>Are duplicate index names allowed if Firebird like in VFP ?

No, they are unique entries in RDB$INDICES system table

>Conversion problems prevent me from using Firebird. I need:
>
>1. Return logical data type column from Firebird data.

The 2.0 version has the boolean data type, but I wouldn't bet that will be visible as LOGICAL.
I've changed all my logical columns to smallint, is and will be more compatible with other backends, but need s code to be changed.

>2. Return empty DATE field from Firebird date column.
>

As there empty dates are not supported, the NULL for these columns is the only way.

>Is there any solution other that write all conversions every time
>manually in VFP code ?
>
>I looked into VFP 9 Cursoradpater but it seems that this dosn't allow to specify those conversions.

I've tried this and works with empty dates (convert to NULL), if date columns are specified with ConversionFunc

PROCEDURE emptyDate2null
LPARAMETERS dDate
LOCAL vRetVal
IF dDate == {}
	vRetVal = null
ELSE 
	vRetVal = dDate
ENDIF 
RETURN vRetVal

>
>PostgreSQL returns empty dates nicely.

The version 8 is out and has a native WIN32 version. You can use it if is more suitable for your needs.

>Where I can get Firebird SQL language documentation? I havent find it in firebird.org and ibphoenix sites.
>

I believe that at http://firebird.sourceforge.net you will find links, faqs, etc.

>I installed Compriere with Fyracle some months ago. However the following problems prevented me to look into Compriere:
>
>1. There is no sample data. Is it possible to load sample data to Compriere-Fyracle ?
>2. I cannot add any data in Compriere, an error message occurs every tame for every table.
>3. There is no documentation available.

I'm not familiar with Compiere, but they have some new version here:
http://www.janus-software.com/fyracle_demo.html