Resent-From: POSTGRES mailing list <postman@postgres.Berkeley.EDU>
Resent-Message-Id: <199501261933.LAA20533@nobozo.CS.Berkeley.EDU>
Sender: owner-postman@postgres.Berkeley.EDU
From: "Steve Martin" <smartin@e-Commerce.Com>
Message-Id: <9501261341.ZM22026@viper>
Date: Thu, 26 Jan 1995 13:41:08 -0500
To: postgres@postgres.Berkeley.EDU
Subject: Problem with pgbrowse
Mime-Version: 1.0
Content-Type: text/plain; charset=us-ascii
Resent-To: postgres-redist@postgres.Berkeley.EDU
Resent-Date: Thu, 26 Jan 95 11:33:18 -0800
Resent-XMts: smtp


Hi I was wondering if anyone could help me with a problem I'm having with
pgbrowse. I select a class and the Class: window comes up with the fields
listed in reverse order from how they are ordered in the database. If i select
query, the query window comes up with the fields reversed as well. If I use the
query window to append a new record into the database, the fields are used in
the proper order.

For example, suppose the I created a table with fields name, address and
phone in that order. The query window looks something like:

phone   = [           ]
address = [           ]
name    = [           ]

which is the reverse order. Now if I fill in some values as shown below:

phone   = [555-1234   ]
address = [hooterville]
name    = [Steve      ]

the append command that is form looks like:

append person (
	name="555-1234",
	address="hooterville",
	phone="Steve")

Can you suggest what might be wrong? I'm using v3.1b on a sun under sunos 4.1.3
and postgres 4.2.

						Thanks
						   Steve

-- 
Stephen Martin
smartin@e-Commerce.COM
e-Commerce, Inc., 1030 Kamato Road, Suite 201 
Mississauga, Ontario, Canada   L4W 4B6        

==============================================================================
   To add/remove yourself to/from the POSTGRES mailing list: send mail with 
   the subject line ADD or DEL to "postgres-request@postgres.Berkeley.EDU".
   If this fails, send mail to "post_questions@postgres.Berkeley.EDU" and
   a human will deal with it.  DO NOT post to the "postgres" mailing list.
==============================================================================
              URL: http://s2k-ftp.CS.Berkeley.EDU:8000/postgres/