Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
SQL command reading in DELETED record
Message
 
 
Information générale
Forum:
Visual FoxPro
Catégorie:
Base de données, Tables, Vues, Index et syntaxe SQL
Versions des environnements
Visual FoxPro:
VFP 9 SP2
OS:
Vista
Network:
Windows XP
Database:
Visual FoxPro
Divers
Thread ID:
01296850
Message ID:
01296906
Vues:
8
>My SQL is in a grid form. A Second maintenance form is called based on the current selected record in my grid. Changes are made in the second form & saved . Then I return to my 1st grid form.
>
>There is a command button on my first from to delete records.
>
>Once a user has made changes using the second form, and I return to the grid form, any records I try to delete are ignored by my SQL command.
>
>Hope this makes sense.. phew

It sounds like your second form changes the SET DELETED (and may be other) settings.

Try
messagebox(set('deleted')) before calling your form and after.
If it's not broken, fix it until it is.


My Blog
Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform