>>
http://weblogs.asp.net/fbouma/archive/2003/11/18/38178.aspx>Thanks very much for posting this blog reference. Interesting stuff.
>
>For clarification : in the SQL World when they talk about Dynamic SQL isn't that a way of saying queries generated by the business layer - i.e. outside of SQL Server - i.e. SPT or Remote views?
That's how I understood it. We aren't the only ones who build SQL commands on the fly. Though I don't see how can the poor things live without textmerge ;).
> If I cam using remote views, am I sending to the backend what SQL Serverheads would consider to be Dynamic SQL ?
Sort of. For the SQL server it does come as a dynamic thing; for VFP, it's pretty much prepared in advance, somewhere in the definition of the view. Looking at a dct file of a views-only dbc, I didn't see any insert or update statements, but I found arrays of fields' update fields (i.e. what's the field to update), so it is at least pre-parsed.
So while the SQL commands VFP is sending to the server for a view are dynamic, they are at least always the same for a given view, only the values change.