Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
No records in Requery() after tableupdate
Message
De
17/11/1998 21:40:01
Larry Long
ProgRes (Programming Resources)
Georgie, États-Unis
 
 
À
15/11/1998 23:30:35
Larry Long
ProgRes (Programming Resources)
Georgie, États-Unis
Information générale
Forum:
Visual FoxPro
Catégorie:
Codage, syntaxe et commandes
Divers
Thread ID:
00157379
Message ID:
00158605
Vues:
19
>>>>>
>>>>>SELECT Thisview && parameterized view w/several records (buffering =5)
>>>>>DELETE
>>>>>IF TableUpdate(1,.f.,'thisview')
>>>>>   REQUERY('thisview')
>>>>>ENDIF
>>>>>*requery('thisview') &&returns records
>>>>>
>>>>>
>>>
>>>Just a WAG: try to do a Locate or Locate Rest after TableUpdate(). You're still sitting on a deleted record. Don't know why would that affect the requery(), but I've seen strange things happening while sitting in the air.
>>
>>Thanx for the suggestion Dragan but no luck... I've tried locate and skip both before and after the tableupdate and get the same results. I've also observed this in VFP6.0.
>>
>>The results are the same in the command window or a running form. The key point to recreate the behavior seems to be that the view is made up of more than one table. The views I've tried were created in the view designer but the sql's seem straight forward enough.
>>
>>Still trying to understand whats going on.
>>
>>Thanx again,
>>Terry
>I have found that under Windows NT you have to execute
>SELECT tablename
>=RLOCK()
>UNLOCK
>after a table update in order to view the "current" information.
Did you issue a "select tablename" or the "select viewname" before trying the rlock()?
L.A.Long
ProgRes
lalong1@charter.net
Précédent
Répondre
Fil
Voir

Click here to load this message in the networking platform