Hi Michael

Thanks for the reply. Basically, I am trying to build the same exact database that I built in FoxPro, but in SQL Server.

I built quite a few parameterized views in FoxPro, and was trying to do the same in SQL. How do you accomplish that if you can't construct Pviews?

Are you familiar with the Visaul Interdev Database Tools? You can create Parameterized Queries with those tools. Have you seen that?

What I have done is created a connection to my SQL Server Database and called up the database in Visual Interdev. I have been using Visual Interdevs interface to build the tables, indexes, set relations, triggers, etc. etc.

It has worked out real nice. The Visual Interdev Data Tools also comes with a query designer, which works real nice as well. I got confused trying to build views though, which is why I posted my question the other day. When I tried to write a SQL statement, just as I had done in FoxPro, to create a pview, it wouldn't accept it.

However, if I went to my program manager (in Visual Interdev), to the "global" icon (node) and selected "create a data command", the query designer popped up and I could create a pview. The concern I had was that the "view" was stored in the program manager tree, under the global node as a SQL COMMAND. It wasn't stored in the data view (where all my table are) under the view node. That was a little confusing to me.

If you aren't familiar with the VD tools, this is probably confusing to you and you have no idea what I am babbling about!! I am sure you probably just write code in SQL server to get the app to dance. Unfortunately, I am not at that level yet. Someday!

Anyway, if you have any thoughts on what I have written, please feel free to write back. Actually, I have no idea what I just was rambling on about!!!

Thanks again

Jason