Remote database access: How?

[Trevor DeVore]

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