Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Lookup from a view
Message
De
13/01/2005 16:36:51
 
 
À
13/01/2005 16:24:56
Information générale
Forum:
ASP.NET
Catégorie:
Bases de données
Divers
Thread ID:
00976908
Message ID:
00976954
Vues:
24
>Generally, I use the DataAdapter to fill a dataset/datatable. You can use "myTable.Rows.Count" to get the # of rows.
>
>Normally, I only use views if I want to further whittle down/filter the contents of a datatable.

I just can't make this work.
    Public Shared oData As DataView

        oData = New DataView

        ' Get all records from Message.dbf
        oData = Framework.VFPSQLAdapterDataView("SELECT UPPER(Key) AS Key,UPPER(Module) AS Module,French,English FROM Message", toForm.lcStartupDirectory)

        ' As we are reading the entire messages table into a view, we have to create a primary key
        ' in order to accelerate the search.
        oData.PrimaryKey = New DataColumn() {oData.Columns("Key"), oData.Columns("Module")}
The oData.PrimaryKey gives an error at development time. It says PrimaryKey is not a member of a view.
Michel Fournier
Level Extreme Inc.
Designer, architect, owner of the Level Extreme Platform
Subscribe to the site at https://www.levelextreme.com/Home/DataEntry?Activator=55&NoStore=303
Subscription benefits https://www.levelextreme.com/Home/ViewPage?Activator=7&ID=52
Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform