Information générale
Catégorie:
Base de données, Tables, Vues, Index et syntaxe SQL
I have data sitting in a Access database .., Just for development where I plan to upscale to SQL server.
My problem is I have two tables:Table_A, Table_B
I have two views View1 = Table_A
and View2 = Join of A+B
update View1 set flag = m.chrtime where lockid = "JO" and actiontime < m.thistime
tableupdate(1)
*set step on
select View2
requery()
Now I have async processing flagged in the connection and its a local data session to the form, I used fox to create the views I didnt code them myself.
If I uncomment the set step on it works ... assume the second view is firing before the fitst saves back and the set step on allows it to happen
Should I build the views myself ?
- James
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