Pb with parameters in a QUery

Hi,

In "TableAdapter Query Configuration Wizard" I try to create a Query with a parameter like :

Select field1, field2, field3 from MyTable where Field1 = @Field1

And it sends me an error :Unable to parse query text

Can you help me for this pb.

Thanks

[279 byte] By [phc] at [2008-2-15]

# 1

When using field and table names that might conflict with reserved words or keywords you should enclose those names in square brackets:

"Select [field1], [field2], [field3] from MyTable where [Field1] = @Field1"

DMan1 at 2007-9-8 >

Visual Studio Express Editions Hot Topic