Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
TableUpdate?
Message
Information générale
Forum:
Visual FoxPro
Catégorie:
Base de données, Tables, Vues, Index et syntaxe SQL
Titre:
Divers
Thread ID:
00246889
Message ID:
00246977
Vues:
26
Douglas,
First, SQLs DO work on the data that is on the disk. However, your tableupdate() command should be saving changes to disk.

1. Do you ReQuery() the list after making the new array?

2. Have you checked the new array to see if the data is there? In other words are you losing the edited data when you do the SQL or when updating the list?

Walk through the process with debug checking the edited data at each point. You'll probably have a better grasp of the problem then.

HTH
Barbara

>Hello,
>
>I am encountering a problem with data buffering.
>
>I have a listbox control whose source is an array that is created from a SQL statement (I am using two fields from a table).
>
>With data buffering turned on, I allow a user to add a new record to a table or to edit an existing record. If the user adds a new record, I save the values in some text controls and then issue an INSERT INTO command which adds the new data to the buffered table. I then issue a TABLEUPDATE() command which commits the data. If I then re-issue my SQL-SELECT to update the array for the list box, everything is okay. The listbox reflects the new data.
>
>However, if the user just edits one of the fields the list box does not get updated! Basically, if in edit mode, I just issue a REPLACE command and then a TABLEUPDATE() to commit the changes. If I view the table prior to re-issue of the SQL command, I can see that the modified data is now in the table. However, it appears that the SQL statement is only working on some already stored data and not the actual table. I tried re-dimensioning the array to nothing and then running the sql command, but still the same results. Do I need to actually close the table and re-open it to get this to work?
>
>Thanks for any help...douglas
Barbara Paltiel, Paltiel Inc.
Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform