We have a database that we've created to be exclusively accessed via A4D; there is no other user interface.
Part of the data that we need to collect is read-only in a SQL Svr on the LAN. So we need to, for instance, authenticate users via a MS SQL db table, but they will be mostly using the data in 4D. So we have ODBC access to the MS SQL Svr, which we can query from 4D, but my question is the best way to access the queries and data via A4D. Should we write a bunch of 4D wrapper methods that we can call from our qry_selectMany.a4d files (we're using fusebox)? One real bummer about that is using rowsets, which we want to do. I'm not sure I can see how to get the data into a rowset unless I first pull it via ODBC, populate arrays, then push into rowsets. That's a lot of work, ugh. And so then, should the wrappers be written in A4D, mimicing the 4D ODBC commands, and calling the 'Execute 4D Command' from with the A4D method? Or write the wrappers in 4D, calling them as methoids from A4D. I know I could experiment, but if someone has some advice on direction, it could help me jump a few steps. Thanks! Michael Check _______________________________________________ Active4D-dev mailing list [email protected] http://mailman.aparajitaworld.com/mailman/listinfo/active4d-dev Archives: http://mailman.aparajitaworld.com/archive/active4d-dev/
