SELECT STATEMENT WITH WHERE ACTIONS

dear coders,
how to make this line working?

// note : edtitemcode is some other value like '4041218'
xval = edtitemcode
sSqlText is string = "SELECT ST_ITEM.ITEM_CODE FROM ST_ITEM WHERE ST_ITEM. ITEM_CODE =@xval"

my question is : how to make a SELECT statement using a WHERE to the variable, like xval.

help please.

regards
mikz

Hi Mitchell,

Try This

xval = edtitemcode

sSqlText is string = "SELECT ST_ITEM.ITEM_CODE FROM ST_ITEM WHERE ST_ITEM. ITEM_CODE = "+xval

That should work.

The + adds the variable into the string. You can add other items as well e.g
= "+xval+" OR ST_ITEM. ITEM_CODE =""+yval

(you get the idea)

Mike
www.fbs-ltd.co.uk

thanks a lot mike,
it works now with the one you suggest :

sSqlText is string ="SELECT ST_ITEM.ITEM_CODE FROM ST_ITEM WHERE ST_ITEM. ITEM_CODE = "+xval

hayyyyyyyyyyy


thanks again

god bless u.

Just note, if you're searching a string, the last part:
ITEM_CODE = "+xval
Should be:-
ITEM_CODE = '"+xval + "'"