Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
USE myview NODATA... and VFP ask for parameters???
Message
 
À
05/01/2000 21:09:42
Information générale
Forum:
Visual FoxPro
Catégorie:
Base de données, Tables, Vues, Index et syntaxe SQL
Divers
Thread ID:
00313345
Message ID:
00313713
Vues:
41
Erik,

I've never tried it, but I can see a use for a multi-table view being updatable in one table and having aggregate results displayed a the child table.

Cheers,

Andrew

>>Dear friends,
>>
>>I create remote views (most of them has parameters) by code. Then, i open the view with
>>USE myview NODATA
>>
>>and define the updatable fields with DBSETPROP(..., "FIELD", ...).
>>Ok!
>>
>>But, i'm getting a message to insert the parameter (after creating the view), at views that has SUM or GROUP BY functions.
>>Any idea to avoid this?
>>
>>Thanks,
>>
>>Ricardo
>
>Both SUM and GROUP BY aggregate the results of many records into one record- how can a view like this be updatable? Whhich record should it update?


If we were to introduce Visual FoxBase+, would we be able to work from the dotNet Prompt?


From Top 22 Developer Responses to defects in Software
2. "It’s not a bug, it’s a feature."
1. "I thought I fixed that."


All my FoxTalk and other articles are available on my web site.


Unless specifically identified otherwise, anthing posted here is purely my opinion and may or may not reflect the policies or practices of Microsoft.
Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform