Hi
>
>Can you send me upsizing code by e-mail .
I've sent it.
Logical columns are mapped to Firebird SMALLINT type and empty dates are converted to {1900-01-01}
>I also find a firebird_api.zip file in UT which allows to call backup, restore and repair functions from VFP.
>Is this reasonable to use it ?
I am using it :)
I think so, but not only for backup/restore/repair.
Can be used to manage users, shutdown/online database or shadow, set write mode/properties, start sweep (the equivalent of PACK or PostgreSql VACUUM), get reports about databases/server log, etc.
>
>Are there any Firebird-VFP samples, tips or newsgrups ?
>
I don't know about something like this. Firebird is better known in Delphi,PHP,.NET, Java and Compiere ERP (recently ported to Firebird) worlds. I visit "firebird-support" group from yahoo or
www.ibphoenix.com if I want to search in knowkedge base.
This is for NET platform developers
http://www.dotnetfirebird.org/I know that Python developers like it too (
www.dabodev.com)
>I try to use remote views. For empty dates, I got error from tableupdate().
>How to force the conversion of empty dates in a generic way so that
>tableupdate works ?
I have default values for them {^1900-01-01}
>
>Does PostgreSQL have the same empty date limit problem ?
I believe that it has.
>How to add a Firebird SQL server setup into VFP application installation package created by Installshield Express shipped with VFP ?
You can add standard Firebird installer with some /SILENT switches. Better ask in firebird-support forum.
>
>Is it possible to copy firebird server dlls to VFP application directory and
Firebird has an embedded engine version, consisting in a single DLL that can be used either as client library for connections to remote computers or local server engine for connections to local databases (running in the same process as VFP).
>have VFP code to set up Firebird server and client in local computer at first run ?
If you use firebird API wrapper, you can change sysdba password, add users, create new databases, etc.
