Information générale
Catégorie:
Visual FoxPro et .NET
Titre:
Parameterised access to VFP data
Does anyone know how to add parameter/s to an ADODataSetCommand object in
order to access VFP data ?
I',m using VS.Net beta 1 (Beta 2 hasn't yet reached the faraway shores of
Scotland yet <g>) and VFP 6 data in a dbc.
I can easily bring in all the rows from my table but I can't seem to add any
parameters without getting errors.
When I configure the DataSetCommand - I get a warning message 'The selected
database provider does not support parameter enumeration. Please use the
parameters editor to set the parameters in the property browser'.
I've tried using the parameters editor and adding the parameters
programmatically via ADODataSetCommand.Select.Parameters.Add().
Whatever I do I keep getting an error - 'One or more accessor flags were
invalid' and no data is retrieved.
Note : I've managed to access SQL Server and Access data fine - using the
visual and programmatic approach.
Any help gratefully received.
Anna
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