>>Well I have just ordered Kylix 2 enterprize. If Borland continues at this pace of every 6 months a new version - they will lose me. I just can't afford the price to keep current.
>
>Borland is certainly following the MS model of calling bug fixes an 'upgrade', giving it a new version number, and then charging for it. You might want to try Kylix Open Edition using the GPL CLX toolset. You can bypass the nag screen with a -s switch.
>
>
>> At the borland site they are offering postgres drivers for dbExpress. Look's like I will have to re-learn how to connect to postgres.
>
>Isn't that driver only available for the Developer Edition?
>
>>It took forever to learn the first time. I still do not have a tool to print reports. But it appears that FastReports will work with Kylix (even though at the moment I can only preview reports but not print).
>>
>>And Postgres is not FoxPro. It does not have an easy way to add fields (columns) or drop fields.
>
>You can "CREATE TABLE AS", using an existing table and selecting all but the fields you wish to drop. You havn't damaged the existing table either, if something goes wrong.

I forgot to add:

Mimick ALTER TABLE table DROP [ COLUMN ] column { RESTRICT | CASCADE }

With:

CREATE TABLE temp AS SELECT did, city FROM distributors;
DROP TABLE distributors;
CREATE TABLE distributors (
did DECIMAL(3) DEFAULT 1,
name VARCHAR(40) NOT NULL
);
INSERT INTO distributors SELECT * FROM temp;
DROP TABLE temp;




>
>>I also have not figured out how to scan as in foxpro. But I guess all of that will come.
>
>Scan? As ind "SCAN ... ENDSCAN"?
>That depends on your odbc connection, unless you us psql directly.
>
>
>>
>>Also, I can't believe how much money I am spending on a free product.
>
>You are not spending much on Linux. If you use an ISO or share a CD you don't spend anything! You are spending money on commerical 3rd party products. It isn't any different in the WinXX world.
>
>If you are familiar with C++ and you want a state-of-the-art GUI RAD tool then you should check out the latest release of KDevelop. It is GPL (read 'free').
>It awesome! I love it. It includes tabulated documentation for both C++ and the QT toolset, plus a documentation generator for your own app.