Re: [INTERFACES] Forms too complex or to large in pgaccess?

From: Constantin Teodorescu <teo(at)flex(dot)ro>
To: David Conners <davidthewise(at)earthlink(dot)net>, PostgreSQL Interfaces <pgsql-interfaces(at)postgresql(dot)org>
Subject: Re: [INTERFACES] Forms too complex or to large in pgaccess?
Date: 2000-01-14 22:03:23
Message-ID: 387F9D2B.FDEDA351@flex.ro
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-interfaces

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(at)flex(dot)ro) a small database dump with your example
(table, forms).
I'll try to locate it and find a sollution

Teo

In response to

Browse pgsql-interfaces by date

  From Date Subject
Next Message Robert Hiltibidal 2000-01-14 22:04:00 Special Characters
Previous Message David Conners 2000-01-14 21:29:37 Forms too complex or to large in pgaccess?