Tim,

Assuming that you want to use VFP as the third tier because of the speed of VFP and your familiarity with it, I suspect that you will meet disappointment with your plans.

I say this because there is no practical way to pass a record set back-forth between tier-2 and tier-3 using VFP. Yes, some suggest that you can use ADO for that, but that will *not* be nearly as fast as native VFP and you are not likely anywhere near as familiar with ADO as you are with VFP. As an aside I seem to recollect a few threads recently asking 'how to use ADO for . . .using VFP' and the answers seemed to be along the lines of 'you cannot yet. . .'.

One way or the other you will find that you have to (using native VFP in tier-3) do a lot of parsing of long string fields or step through array elements (you can now pass arrays with VFP 6). Either technique is sensitive to table field layouts, requiring a programming change whenever any field is added or removed from a participating table.

Have fun with it,

Jim N


>I am developing a 3-tier application with a VFP DBC as the data source, VB as the middle tier, and ASP as the presentation layer. The database tables use many coded values. My question is where do I put the decoded values?
>
>I can create code tables in the DBC and have my data layer pass up the decoded values to the business logic layer. Or, I can pass up the coded value from the data layer and let the business logic decode it.
>
>Right now, I am only displaying info from the database, but later we will allow updates. I would think I should create decode tables. Does anyone have any thoughts?