Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations gkittelson on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Passing variable into SQL statement...HELP

Status
Not open for further replies.

Bodjan

Programmer
Jul 2, 2003
2
US
Does anyone know the syntax to put variable from the textbox into SQL statement.
For Example:

MOVE ""SELECT * FROM St WHERE SajAcct =" & TEXTVALUE TO ST.

I have tried so many different things but I can't seem to be able to get it to pass this variable.

Any help is greatly appreciated.
Thanks again..
 
01 SQL.
04 FILLER PIC X(31)
VALUE "SELECT * FROM ST WHERE SajAcct=".
04 TEXTVALUE PIC X(??).

MOVE THE VALUE TO TEXTVALUE THEN EXECUTE.
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top