On Wed, Oct 12, 2005 at 08:17:23PM +0100, Oliver Elphick wrote:
> On Wed, Oct 12, 2005 at 12:19:41PM -0600, Michael Fuhr wrote:
> > Could you post the table definitions?
>
> Here it is:
I created the tables you posted (sans foreign key constraints because
you didn't include the referenced tables) and loaded the data from
your previous post into an 8.0.4 server on FreeBSD 4.11-STABLE.
Here's what I got; it looks correct around the columns you report
having trouble with:
\x
SELECT * FROM export_invoice;
-[ RECORD 1 ]-+--------------------------------
invno | 67829
customer | 22058
account | X378
invdate | 2004-02-10
taxpoint | 2004-02-10
discount | 0.000
ordno | 5411
custref | 15498-00
currency | GBP
carriage | 0.00
printed | t
assigned | t
customer_ean |
location_ean |
exchange_rate |
grpid |
postcode |
grn |
orderdate | 2004-02-10
packages | 60
packing | 0.00
other | 0.00
other_desc | 0
insurance | 0.00
pack_desc | Carton
kilos | 570.000
nett | 0.000
dimensions |
terms | CIF-MONTREAL/ACT 30-DAYS
bank |
goods | Chemist's sundries
marks | AMG MEDICAL;5411;MONTREAL;1-60;
port | THAMESPORT
transport | SEA/ALLIANCE
destination | CA
origin | GB
auth | MAIREAD BOYCE, DIRECTOR
copies | 1
--
Michael Fuhr