[Top] [Prev] [Next] [Bottom] [Contents]

SgeSetStatement

 Sets the SQL statement to be executed by the database server.

Synopsis

#include "WorkingDialog.h"
void SgeSetStatement(pSgeWorkCallData p, char*statement);

Arguments

p
An allocated pSgeWorkCallData structure.
statement
SQL statement to be executed by the Database server.

Return Values

 None.

Description

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.

Example

/*** 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);

See Also

[Top] [Prev] [Next] [Bottom] [Contents]

info@bluestone.com
Copyright © 1997, Bluestone. All rights reserved.