Content-Type: text/plain;
  charset="iso-8859-1"
From: "John L. Turner" <jlt@wvinter.net>
Reply-To: jlt@wvinter.net
Organization: JCI Inc.
To: "C. Maj" <cmaj@freedomcorpse.info>,
	Brett Schwarz <brett_schwarz@yahoo.com>,
	"Iavor Raytchev" <pobox@verysmall.org>,
	pgsql-interfaces <pgsql-interfaces@postgresql.org>
Subject: PSIC Customers Form
Date: Wed, 5 Mar 2003 14:36:08 -0500
User-Agent: KMail/1.4.3
References: <Pine.LNX.4.44.0210261606330.7890-100000@freebird.stanley.cup>
In-Reply-To: <Pine.LNX.4.44.0210261606330.7890-100000@freebird.stanley.cup>
MIME-Version: 1.0
Content-Transfer-Encoding: quoted-printable
Message-Id: <200303051436.08717.jlt@wvinter.net>

Hello Chris et.al.
RE: http://www.pgaccess.org/index.php?action=3Dsave&page=3DPSICToDoList

I have uploaded to my Web site:

http://home.ntelos.net/~JLT

LOOK ON LAST LINE ON THAT LONG PAGE !

A package:
	psic_psql.tar.gz
=09
The file is 584,325 KB so, I think that is too much to attach here.

This contains the Data, and schema and a revised psic.tcl and customer.tcl
To allow anyone that wants to help, to do so.

The idea is that I have finally converted all the Access97 tables and Data
to postgresql.

To created the database,
run setup_psic.sh from the directrory where
all the files are expanded into.
_________________

Test with psic.tcl
The only menu item that opens a working Customers form ( customers.tcl )
is:  Data In  | Customers Source
( read that as the psic.tcl "sources" the script customers.tcl )

PLEASE note the CVS pgaccess /extra  customers.tcl will not work, as the ca=
se=20
of the fields, and tables are now changed.


In doing so, have revised the table and field names to lower case=20

Have included a lot of false data, that will allow folks to play with a rea=
l=20
database of in use data. e.g there are ~14,500 customers, ~2,000 Products

I am leaving in the morning for a 2 week trip to the west coast, will look =
for=20
grips when I return.

At this time, I still can not get the widgets to do what I need with in
pgaccess, so no attempts have been made to package this thing in pgaccess.

With best regards to the whole pgaccess team, I still am trying to
get this PSIC project to work with postgresql, either in or out of pgaccess.
--=20
John Turner
JCI Inc.
http://home.ntelos.net/~JLT
"Just because you do not know the answer
does not mean that someone else does"
Stephen J. Gould, {rip}