My approach is also backend independent, i do dot use stored procs. Statements syntax is stored in tables instead of hardcoded in programs. This makes the whole system much more scalable and maintainable.

>
>
>I see what you are saying. You are correct that using stored procedures will be more efficient and faster. However, COMCodebook was written to support multiple backends, Oracle, VFP, and SQL Server out of the box. Each product has diffent symtax and support for stored procedures, so Flash opted to take a more generic approach.