Hi
The equivalent of DATE is the same in Firebird
DATETIME = TIMESTAMP
But keep in mind that empty dates and datetimes are not allowed, you need to have null for these or some default value ( I have 1900-01-01 )

For logical fields you can create a domain based on SMALLINT
This is what I've done

CREATE DOMAIN LOGICAL AS SMALLINT DEFAULT 0 CHECK (VALUE IN (0,1))

I believe that, with CursorAdapter, you can use some conversion functions and get a VFP logical column.

I have a small utility that can be used to trasfer tables, data and column based indices, I'll send you if you want.


>
>How to create VFP logical and date fields in remote views using Firebird SQL server ?