SQL2GMS.gms : Runs SQL2GMS interactively

Description

This model offers the user first a menu of options using the ASK tool, which
includes to open the SQL2GMS documentation and to run "sql2gms" interactively.

Keywords: SQL2GMS, data exchange, GAMS language features, ASK


Category : GAMS Data Utilities library


Main file : SQL2GMS.gms   includes :  SQL2GMS.gms

$title Runs SQL2GMS interactively (SQL2GMS,SEQ=053)

$onText
This model offers the user first a menu of options using the ASK tool, which
includes to open the SQL2GMS documentation and to run "sql2gms" interactively.

Keywords: SQL2GMS, data exchange, GAMS language features, ASK
$offText

$callTool win32.msappavail Access
$if errorlevel 1 $abort.noError "No Access available"

Scalar task / 0 /;

$onEcho > ask.opt
T=radiobuttons
M=SQL2GMS SQL database->GAMS import facility
D=Show Documentation (offline)|Run SQL2GMS interactively
E=1|2
R=task = %s;
O=task.inc
$offEcho

$call =ask @ask.opt
$ifE errorLevel<>0 $abort Error running ASK!
$include task.inc

if(task=1,
   executeTool 'win32.shellExecute "%gams.sysdir%\docs\T_SQL2GMS.html"';
elseIf task=2,
   execute 'sql2gms';
);