#include "WorkingDialog.h"
void SgeSetStatement(pSgeWorkCallData p, char*statement);
SgeSetStatement
sets the SQL statement to be executed by the database server for an allocated pSgeWorkCallData
structure. If p
is NULL, no action is taken. Use of this function overrides the Stored Procedure name and SQL fragments set with SgeVaSetFrags
.
/*** generic ad hoc code ***/
/*** Server name is in textField1 ***/
/*** Database name is in textField2 ***/
/*** All columns of data will end up in scrolledList1 ***/
/*** Statement to execute is in scrolledText1 ***/
pSgeWorkCallData pSgeWCD;
char *db, *server;
db = strdup(SaGetText(UxGetWidget(textField2)));
server = strdup(SaGetText(UxGetWidget(textField1)));
pSgeWCD = getSgeWorkCallData(UxWidget,
-1,
db,
server,
"D_AUTHORS_INFO", NO_WP);
free(db);
free(server);
SgeSetCallDetail(pSgeWCD, TO_CACHE,
(XtPointer)0x0,
WIDGET_INDEX, UxGetWidget(scrolledList1),
(XtPointer)0x0,
NO_QUEUE_FILE);
SgeSetColBind(pSgeWCD, UxGetWidget(scrolledList1), 1, 0,
0,
(XtPointer)0x0,
(XtPointer)0x0);
SgeSetAdHocFlag(pSgeWCD);
SgeSetStatement(pSgeWCD,
SaGetText(UxGetWidget(scrolledText1)));
DoWorkProc(pSgeWCD, PROCESSBRSREQUEST_DSQL);