pg.ddx.io pgsql-interfaces@postgresql.org mailing list archive
help / color / mirror / Atom feedRe: [pgaccess] hard limit of results reached
2+ messages / 2 participants
[nested] [flat]
* Re: [pgaccess] hard limit of results reached
@ 2000-05-01 07:46 Constantin Teodorescu <teo@flex.ro>
0 siblings, 1 reply; 2+ messages in thread
From: Constantin Teodorescu @ 2000-05-01 07:46 UTC (permalink / raw)
To: Klaus Herrmann <klaus.herrmann@gmx.net>; +Cc: pgsql-interfaces@hub.org
Klaus Herrmann wrote:
>
> Hi Folks!
> I have a *serious* problem with pgaccess. if i do a lot of queryies, i
> get this message "hard limit of results is reached..." and i have to
> restart pgaccess. this sucks, especially because i programmed some forms
> which have pretty complex and many queries. is there a chance to avoid
> this (maybe i'm just programming so bad? but this occures with the demo
> forms too), any programming tips, suggestions etc.?
> thanks in advance!
> regards,
That is a known bug!
The latest PgAccess 0.98.6 has solved it!
In file forms.tcl (directory /usr/local/pgaccess/lib)
at line 793 you should add :
pg_result \$res -clear
at the end of the open proc definition.
The right procedure should be defined as follows:
namespace eval ::DataControl($base.$name) "proc open {} {
global CurrentDB DataControlVar
variable tuples
catch {unset tuples}
set wn \[focus\] ; setCursor CLOCK
set res \[wpg_exec \$CurrentDB \"\$DataControlVar($base.$name,sql)\"\]
pg_result \$res -assign tuples
set fl {}
foreach fd \[pg_result \$res -lAttributes\] {lappend fl \[lindex \$fd
0\]}
set DataControlVar($base.$name,fields) \$fl
set DataControlVar($base.$name,recno) 0
set DataControlVar($base.$name,nrecs) \[pg_result \$res -numTuples\]
setCursor NORMAL
pg_result \$res -clear
}"
Just let me know if you succeeded and everything is ok!
Teo
^ permalink raw reply [nested|flat] 2+ messages in thread
* Re: [pgaccess] hard limit of results reached
@ 2000-05-01 09:34 Klaus Herrmann <Klaus.Herrmann@gmx.net>
parent: Constantin Teodorescu <teo@flex.ro>
0 siblings, 0 replies; 2+ messages in thread
From: Klaus Herrmann @ 2000-05-01 09:34 UTC (permalink / raw)
To: Constantin Teodorescu <teo@flex.ro>; +Cc: pgsql-interfaces@hub.org
> namespace eval ::DataControl($base.$name) "proc open {} {
> global CurrentDB DataControlVar
> variable tuples
> catch {unset tuples}
> set wn \[focus\] ; setCursor CLOCK
> set res \[wpg_exec \$CurrentDB \"\$DataControlVar($base.$name,sql)\"\]
> pg_result \$res -assign tuples
> set fl {}
> foreach fd \[pg_result \$res -lAttributes\] {lappend fl \[lindex \$fd
> 0\]}
> set DataControlVar($base.$name,fields) \$fl
> set DataControlVar($base.$name,recno) 0
> set DataControlVar($base.$name,nrecs) \[pg_result \$res -numTuples\]
> setCursor NORMAL
> pg_result \$res -clear
> }"
>
> Just let me know if you succeeded and everything is ok!
>
yes, it works fine! thank you very much!
time to release 0.98.6 :-)
bye,
Klaus
--
Sent through GMX FreeMail - http://www.gmx.net
^ permalink raw reply [nested|flat] 2+ messages in thread
end of thread, other threads:[~2000-05-01 09:34 UTC | newest]
Thread overview: 2+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2000-05-01 07:46 Re: [pgaccess] hard limit of results reached Constantin Teodorescu <teo@flex.ro>
2000-05-01 09:34 ` Klaus Herrmann <Klaus.Herrmann@gmx.net>
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox