Sender: teo@flex.flex.ro
Message-ID: <387F9D2B.FDEDA351@flex.ro>
Date: Sat, 15 Jan 2000 00:03:23 +0200
From: Constantin Teodorescu <teo@flex.ro>
MIME-Version: 1.0
To: David Conners <davidthewise@earthlink.net>,
	PostgreSQL Interfaces <pgsql-interfaces@postgresql.org>
Subject: Re: [INTERFACES] Forms too complex or to large in pgaccess?
References: <387F9541.512D18A7@earthlink.net>
Content-Type: text/plain; charset=us-ascii
Content-Transfer-Encoding: 7bit

David Conners wrote:
> 
> Hi all,
> 
> I'm using PgAccess v0.98, postgreSQL 6.5.1, tcl 8.0.3-20 on a RedHat
> 5.2 machine.
> 
> Is there a limit on how large a form pgaccess can create?

Yes, the 8K record limit!
 
> I've created a form that displays records selected from three associated
> tables. While adding buttons to which would update the tables with
> information changed by the user, I reached a point at which I could not
> save the form.  When I tried, a column the length of my screen is
> displayed, showing what looks like a stack dump of the failed attempt to
> write the form.  At this point PgAccess no longer responds.

:-( . Yes I know! Seems that I have to redesign the form storage!

> WHen I try to start PgAccess again, I encounter various problems, It
> won't start and complains about abnormal termination, or it starts but
> one or more of my forms are missing.

Seems that it crashes the pga_forms.

> To recover, I replace the associated pga_forms file with a good backup
> copy.
> 
> The two UPDATE statements I'm trying to add total 1787 bytes.
> 
> I can add one, or the other can save the form.
> I can't find a way to include both and have the save succeed.
> 
> ANy help or advise is appreciated.  I didn't want to burden the group
> with big attachments, but if anyone would like to look at the forms
> and such, I'd be more than happy to send them.

Send me directly (teo@flex.ro) a small database dump with your example
(table, forms).
I'll try to locate it and find a sollution

Teo