Database Criteria Not Working

[CoreyBryant]

When I go to choose Database Results & my table (only one in the database that I am using), the connection is verified (no problems). In Step 2, I choose Custom Query. I think this is somewhere my problem lies. In Step 3, the criteria button is grayed out. I have tried a lot of different ways to correct this - but nothing seems to work. The table is mvc & the field that I want the people to query is zip. Thanks!!

 

[LukeDouglas]

Corey,

Sorry to be a bummer but Microsoft has this firmly coded so you can't set criteria with custom SQL statements. All criteria has to be in your SQL statement. The only thing you might be able to set is Defaults depending on what you have in your SQL statement.

I can tell you this, I have had great difficulty in getting multi-table SQL statements to work in FP. I like FP for it's ability to design web pages but it's database integration has a lot to be desired. If they could make it more DB friendly, I'm sure it would explode as a product, or at least it would with me.

Luke