>The DBF() function allows you to reference the *source* of the cursor (the
actual temporary file to which it points), and issuing a "USE" on this in a
new work area makes it updatable. You ALIAS it to whatever name you wish to
use, and the next command closes the initial read-only instance.
>
>>My result set depends upon a variable list as part of the WHERE clause.
>>If I use a view I get the extra browse window, but should be able to
update >the necessary base tables.
>
>I'm not sure what you mean here. If I recall, you were getting a browse
window before because the SELECT statement in your listbox RecordSource
didn't specify a cursor. How exactly is using a view creating a browse window?
>
to add to this:
I use views in many places and don't get browse windows every time I use them
Arnon
Précédent
Suivant
Répondre
Voir le fil de ce thread
Voir le fil de ce thread à partir de ce message seulement
Voir tous les messages de ce thread
Voir tous les messages de ce thread à partir de ce message seulement