>>I regret never taking the time to learn remote views.
Instead I used SQL Passthrough with stored procedures doing all the queries and updates- not nearly so elegant.
However, it turned out to have been a good call years later when I converted some of these apps to .NET and used those same SP's.
Fair enough! One of my old habits in the early RV days was to create a parameterized view and then watch the generated SQL, because RVs generate injection-proof SQL for any backend so you can use that as a great skeleton for your passthrough. Particularly useful for Oracle and it's horrid dates... Then other tools came along.
Will you be coming to SW Fox?
"... They ne'er cared for us
yet: suffer us to famish, and their store-houses
crammed with grain; make edicts for usury, to
support usurers; repeal daily any wholesome act
established against the rich, and provide more
piercing statutes daily, to chain up and restrain
the poor. If the wars eat us not up, they will; and
there's all the love they bear us."
-- Shakespeare: Coriolanus, Act 1, scene 1
