Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Urgent help needed with local view
Message
 
À
23/07/2004 12:00:21
Elyse Pomerantz
Dynamic Data Concepts, Inc.
Brooklyn, New York, États-Unis
Information générale
Forum:
Visual FoxPro
Catégorie:
Base de données, Tables, Vues, Index et syntaxe SQL
Divers
Thread ID:
00927385
Message ID:
00927439
Vues:
25
>I have one form that uses a local view. It had been working fine, but now I'm having a problem and I'm not sure if it's related to our recent upgrade to VFP8. I am using an updateable, local view. In the DataEnvironment, the Buffering is set to Optimistic Row Buffering. In the Load event I have =CURSORSETPROP("SendUpdates",.T.,"myview")
>In my code I replace the values in a few of the fields of the current record and then when I try to leave the record (by doing a SUM or just a SKIP) the system freezes. On my status bar I see a message "Record not available...please wait." I'm the only one using the file. What's happening?

I suspect you haven't properly defined a keyfield for this view. Since you're not setting SendUpdates to .T. until you open the view, it sounds like you didn't set things up on the "Update Criteria" page. Did you define this view through the View Designer or in code? In either case, you can set the SendUpdates, plus all the other criteria at the time you define the view.

And about that Keyfield...it's important that the field or fields you identify as the key correspond to a single record in the source table. Otherwise, it will try to update multiple records.
Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform