Re: Filter equivalent for Access bound form

Hi,

After using ethereal and making changes for a while, I came to the conclusion 
that there is apprently a problem with Access Databases in 2000 format used 
under Access 2003. After converting my database into the native 2003 format 
(not compatible with Access 2000, though) I don't have any more problems, and 
the application is much more responsive, by the way.

Filters in bound forms work fine, and don't suffer any performance penalty... 
And the recordset remains updatable, which is great for a RAD tool like Access.

I hope this helps.

Philippe Lang

-----Message d'origine-----
De : pgsql-odbc-owner@xxxxxxxxxxxxxx [mailto:pgsql-odbc-owner@xxxxxxxxxxxxxx] 
De la part de David P. Lurie
Envoyé : jeudi, 5. août 2004 17:47
À : pgsql-odbc@xxxxxxxxxxxxxx
Objet : [ODBC] Filter equivalent for Access bound form

Access 2003
pg 7.4.3

What is the recommended approach to get the equivalent of a filter for an 
Access bound form?

The filter property of a bound form seems to be the equivalent of an Access 
client-side query of SELECT * FROM form.recordsource WHERE form.filter. That 
would have a performance penalty.

I change the SQL of pass-through queries dynamically at runtime to use as 
record sources for reports. That wouldn't work for forms, as not updatable.

Is the best approach to use an updatable view as the record source, then change 
the view definition at runtime as with a passthrough query?

Would need a unique view name for multi-user reasons, perhaps including part of 
a timestamp string or sequence. The original view's insert, update and delete 
rules should still have valid syntax except for the new view name, as only the 
WHERE clause and view name are changed. The rules could be updated with VBA 
code at the same time as the view change.

Thanks,

David P. Lurie




---------------------------(end of broadcast)---------------------------
TIP 6: Have you searched our list archives?

               http://archives.postgresql.org



---------------------------(end of broadcast)---------------------------
TIP 3: if posting/reading through Usenet, please send an appropriate
      subscribe-nomail command to majordomo@xxxxxxxxxxxxxx so that your
      message can get through to the mailing list cleanly