On Jun 8, 2009, at 10:29 AM, Tereza Snyder wrote:
On Jun 8, 2009, at 8:58 AM, Bernard Devlin wrote:
You could connect directly to the SQL server with few security
worries
if your app and the server will run on the same LAN (or if they
connect via some kind of VPN/secure tunnel).
Unfortunately, the app will be downloaded by scattered users logging
in from who-knows-where.
It looks as if my dream of simple direct access to the database is
kaput, so I'll have to construct some kind of online infrastructure
to mediate between my rev app and its data in MySQL.
If you have a Rev CGI and standalone that support arrayDecode/
arrayEncode then your life is easier. You can just make calls to the
Rev CGI that asks for a type of result, the Rev CGI makes the query,
converts the cursor to an array, encodes the array and then returns
it. In the standalone you can just decode the array and you are good
to go.
Converting from cursor to to an MD array is pretty straightforward.
This lesson for the data grid shows how:
Converting a Database Cursor To a Data Grid Array: <http://revolution.screenstepslive.com/spaces/revolution_tools/manuals/datagrid_tips/lessons/4485-Converting-a-Database-Cursor-To-a-Data-Grid-Array
>
Regards,
--
Trevor DeVore
Blue Mango Learning Systems
www.bluemangolearning.com - www.screensteps.comr
_______________________________________________
use-revolution mailing list
[email protected]
Please visit this url to subscribe, unsubscribe and manage your subscription
preferences:
http://lists.runrev.com/mailman/listinfo/use-revolution
