Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Upsizing DBF files
Message
From
22/01/2005 17:37:35
 
 
To
20/01/2005 04:13:20
Dorin Vasilescu
ALL Trans Romania
Arad, Romania
General information
Forum:
Visual FoxPro
Category:
Client/server
Miscellaneous
Thread ID:
00977631
Message ID:
00979688
Views:
12
>>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
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform