Information générale
Catégorie:
Base de données, Tables, Vues, Index et syntaxe SQL
Titre:
What to use instead of FPW 2.6 INSERT ?
Application scenario: The user works with a queried FoxPro data set, in this case a sequence of raw materials & instructions which compose a specific chemical recipe. Each row (representing an individual raw material or instruction) has numerous associated fields, such as code number, description, amount, etc. The entire recipe is visible & editable by the user. The user may want to modify individual data items on various rows, delete a row, insert or append additional rows, etc.
All of this works just fine in FPW 2.6.
I am now converting this application to Visual FoxPro. Using a buffered view of the network table works great, except for one of the above features. There is no way of directly INSERTing a row, new rows can only be appended. The ability to insert a row (or multiple rows) anywhere in the data set is a necessary function for users of this application.
In FPW 2.6, INSERT (not INSERT-SQL) achieved this. I do not know how to replicate this functionality using buffered table views. Suggestions are welcomed.
Thanks,
Randy W.
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