Because the previous server end CodeThese are all stored procedures used (Oracle or MSSQLServer ). Now we are working on supporting desktop applications (ACCESS ). Because the table structure is the same, you just want to take the previous Code and use it in access without modification. However, access has limited support for stored procedures. I found someone has implemented this idea. His approach is to dynamically convert the stored procedure into corresponding SQL statements. So we use "tailism. According to his method, the effect is really good. Saves a lot of repetitive work. Recent projects are tight. Wait for a while and share with you the recent project process as some problems encountered and solutions to the problems.
Related connections are:
Http://www.codeproject.com/dotnet/ELAB.asp
Http://adefwebserver.com/dal/Blogs/tabid/162/ctl/ViewEntry/EntryID/20/mid/547/Default.aspx
