Command object parameters

[TerryAtFlex]

I am using CR9 with MSSQL2000. I want to use a command object, and I want to add parameters to it. My query looks like this:

Select Count(*) From Broker Where Broker.State = [{prmState}]

prmState is the parameter I want to supply at runtime. The documentation is very sparse on the subject. Can anyone help me to use the Modify Command window?

Thanks

Terry At Flex

 

[vidru]

I don't have 9.0, but I'm pretty sure that your statement should look like this:

Select MyCount = Count(*) From Broker Where Broker.State = {?prmState}

-dave

 

[TerryAtFlex]

Almost works.

Now my query is as below:

Select Count(*) From Broker Where Broker.State = {?prmState}

I add a parameter to the right named prmState of type string, give it a default value of MI, and when I press the OK I get the Enter Parameter Values dialogue. When I press OK on this window, I get an error, Failed to open a rowset.
Source: MS OLE DB Provider for SQL Server
The description: Invalid Column Name 'MI'

Any ideas?

Thanks, btw, for your reply!

Terry

 

[TerryAtFlex]

Select Count(*) From Broker Where Broker.State = '{?prmState}'

did the trick!!

Thanks for pointing me in the right direction. This is a big deal for me!