Column Name Length problem?

From: "Corey W(dot) Gibbs" <cascadia(at)nventure(dot)com>
To: <pgsql-odbc(at)postgresql(dot)org>
Subject: Column Name Length problem?
Date: 2002-03-03 17:52:16
Message-ID: 000a01c1c2dc$28dc3b80$0300a8c0@Domain
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-odbc

Good Morning Everyone,
I had a perfectly good working application written in VB that tied to a PG database on a Red Hat system with the latest ODBC driver.
After working on the app for awhile, I had to re-write the database layout based on user requests. I made some field names longer and others shorter, and generally "neatened things up". Why does "neatening things up" always break it? :).
Of course, I didn't document the old layout, so I can't compare where things went wrong. (Mental note, save printouts of the database layout)
On Friday, "select * from schedule" in the recordset.open statement would cause a "division by zero" error. In debugging it, I got up to "select id,quote_number,price_required,bid_date,bid_time,project_name from schedule" before I had to leave for the day. On Monday morning I'm going to start debugging the app from that point, but I was wondering if anyone could see anything that I would need to watch out for in the layout below. Or that would cause select * to bomb out.
thanks in advance
corey
Table schedule in database est_track
_________________________________________________________________

Field name Type Array? Allow nulls?
id - a serial field int4 No No
quote_number int4 No Yes
price_required timestamp No Yes
bid_date timestamp No Yes
bid_time timestamp No Yes
project_name text No Yes
location text No Yes
state text No Yes
estimator text No Yes
job_number int4 No Yes
hund_percent_sell float8 No Yes
percent_sell float8 No Yes
bid_amount float8 No Yes
low_bid_amount float8 No Yes
low_bid_percent float8 No Yes
low_bid_bidder text No Yes
addl_bid text No Yes
addl_bid_amount float8 No Yes
spread float8 No Yes
addl_bidder2 text No Yes
addl_bidder2_amount float8 No Yes
addl_bidder3 text No Yes
addl_bidder3_amount float8 No Yes
addl_bidder4 text No Yes
addl_bidder4_amouint float8 No Yes
spread_percent float8 No Yes
low_bid_notes text No Yes
low_bid_spread float8 No Yes
low_bid_spread_percent float8 No Yes
addl_bidder2_notes text No Yes
addl_bidder3_notes text No Yes
addl_bid_notes text No Yes
rebid bool No Yes
rebid_info text No Yes
sales_person text No Yes
date_complete timestamp No Yes
no_tabs_avail bool No Yes
only_bidder bool No Yes
negotiated bool No Yes
no_tabs bool No Yes
dealer_bid bool No Yes
accept_date timestamp No Yes
date_modified timestamp No Yes
plan_deposit bool No Yes
plan_return_date timestamp No Yes

Responses

Browse pgsql-odbc by date

  From Date Subject
Next Message Dave Page 2002-03-03 20:11:42 Re: Multibyte ODBC
Previous Message Zak Greant 2002-03-02 05:15:02 Re: PHP ODBC conflict