I am a SQL Server database developer who's migrating an Access database to SQL
Server 2005. I'm using InfoPath (I'm a novice) to replace the Access forms. I'm using a SQL Server endpoint as the web service and only want to use stored procedures for
querying and submitting. Since I'm not a programmer, I'm trying to avoid coding.
However, in using rules and filtering I have 2 questions that aren't really
explained in any reference books or articles that I've looked at:

1. What does "@" mean, e.g., when using it in a filter? To me it means a SQL Server
input/ouput parameter or a variable. For example, it's used in Figure 6-10 on page 93 and in Figure 7-3 on page 105. How do I know when and how to use it?

2. Are there any good references on the definition and the use of InfoPath
functions? I've only found one Microsoft reference, but would like to find others:

http://office.microsoft.com/en-us/in...330391033.aspx

Thank you for the help.

Hi aaqqqa:
In response to your question, I would not use the word "filter" for the "@"-sign. A filter defines the amount of data returned by a query. In the examples, on pages 93, 105 the "@"-sign in front of the variable in this case Discount represents the variable in the database. In this case, Discount is the defined column in the tblOrderItems Detail which is the child-table to tblOrders (Master-Detail relationship). In Figure 6-8, page 92 the bolded row represents variables in the table, except the Item Total. Page 93 is illustrating how to create a business rule for an item in the database.

There are 3 Appendices in the WROX Book: Professional InfoPath 2003.

Hope this helps.

__________________
Disclaimer: The above comments are solely the opinion of one person and not to be construed as a directive or an incentive to commit fraudulent acts.

Thank you, peace95. That's helps a lot. I hadn't looked at the Professional book.