Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Upsizing DBF files
Message
De
22/01/2005 17:37:35
 
 
À
20/01/2005 04:13:20
Dorin Vasilescu
ALL Trans Romania
Arad, Roumanie
Information générale
Forum:
Visual FoxPro
Catégorie:
Client/serveur
Divers
Thread ID:
00977631
Message ID:
00979688
Vues:
13
>>Can you send me upsizing code by e-mail .
>I've sent it.

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 ).

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

Are duplicate index names allowed if Firebird like in VFP ?

>Logical columns are mapped to Firebird SMALLINT type and empty dates are converted to {1900-01-01}

Conversion problems prevent me from using Firebird. I need:

1. Return logical data type column from Firebird data.
2. Return empty DATE field from Firebird date column.

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.

PostgreSQL returns empty dates nicely.
Logical data type returning problem exists in PostgreSQL also. However, PostgreSQL has bit and boolean data types so it may be possible to fix ODBC driver source code to convert them properly.

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

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.
Andrus
Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform