Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
VFPOLEDB and Parameters
Message
De
30/06/2004 16:58:55
 
 
À
29/06/2004 22:24:11
Eugenio Casal
Futura Tecnologia Informação Consult Ltd
São Paulo, Brésil
Information générale
Forum:
ASP.NET
Catégorie:
ADO.NET
Divers
Thread ID:
00918644
Message ID:
00919373
Vues:
7
Thanks to all of you for your replies. I found my problem and it was ME!

In my data service I was creating a new command object but did not duplicate the parameters collection. DUH!

>Hi Dan,
>
>I tried your code and for me it worked fine.
>Are you using the latest version of the VFP Ole DB Provider?
>
>>I'm using the VFPOLEDB provider and I am creating a command object like this:
>>
>>
>>OleDbCommand objCmd = new OleDbCommand("select * from customers where CustomerID = ?");
>>objCmd.Parameters.Add("CustomerID", "ALFKI");
>>
>>
>>When I execute this command I am getting an OleDbException that says:
>>
>>
>>No value given for one or more required parameters.
>>
>>
>>How do I use the parameter collection to pass parementers to commands?
Thanks,
Dan Jurden
djurden@outlook.com
Précédent
Répondre
Fil
Voir

Click here to load this message in the networking platform