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

Поиск
Список
Период
Сортировка
От Constantin Teodorescu
Тема Re: [INTERFACES] Forms too complex or to large in pgaccess?
Дата
Msg-id 387F9D2B.FDEDA351@flex.ro
обсуждение исходный текст
Ответ на Forms too complex or to large in pgaccess?  (David Conners <davidthewise@earthlink.net>)
Список 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@flex.ro) a small database dump with your example
(table, forms).
I'll try to locate it and find a sollution

Teo


В списке pgsql-interfaces по дате отправления:

Предыдущее
От: David Conners
Дата:
Сообщение: Forms too complex or to large in pgaccess?
Следующее
От: Assaf Arkin
Дата:
Сообщение: Re: [INTERFACES] JDBC 2.0 Standard Extensions for PostgreSQL