Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Parameterization of a query
Message
De
12/09/2010 16:33:16
James Blackburn
Qualty Design Systems, Inc.
Kuna, Idaho, États-Unis
 
 
À
12/09/2010 16:19:47
Information générale
Forum:
ASP.NET
Catégorie:
Bases de données
Versions des environnements
Environment:
VB 9.0
OS:
Windows 7
Network:
Windows 2003 Server
Database:
MS SQL Server
Application:
Web
Divers
Thread ID:
01480890
Message ID:
01480895
Vues:
44
FYI. Unless @ has a meaning in .net it has no importance in Sql Anywhere. Unlike Sql Server, you don't have to start a variable with an @ sign.

>>Not sure at all, but what if:
>>
>>loODBCDataParameter = New OdbcParameter()
>>loODBCDataParameter.ParameterName = "@Last_Date" -- put the @ ate the beginning of the parameter name?
>>
>>
>>And BTW why I think you should have a question mark somewhere where the parameters should be placed?
>>
>>"Select Last_Date From RO Where Last_Date > ?"
>>
>>(again not sure :-))))))))))))
>
>Wow, this is surely it. The following works:
>
>
>                    loCommand.CommandText = "Select Last_Date From RO Where Last_Date>?"
>                    loODBCDataParameter.ParameterName = "@Last_Date"
>
>
>Thanks
Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform