preCharge Forums - View Single Post

Minakshi · 07-10-2006

Hi,
Pls try this:

StrSql = "SELECT * FROM [" & Screen & "] WHERE (CPN="&(COORDID)&") AND (CNUM="&(CNUMQS)

bec

"SELECT * FROM [" ----- First string
& Screen & -------variable
"] WHERE (CPN=" -------Second string
&(COORDID)& -------variable
") AND (CNUM=" -------Third string
&(CNUMQS) ------last variable ---- (imp *****not a string)

07-10-2006	#2 (permalink)
Minakshi Junior Member Join Date: Jul 2006 Age: 39 Posts: 8	Hi, Pls try this: StrSql = "SELECT * FROM [" & Screen & "] WHERE (CPN="&(COORDID)&") AND (CNUM="&(CNUMQS) bec "SELECT * FROM [" ----- First string & Screen & -------variable "] WHERE (CPN=" -------Second string &(COORDID)& -------variable ") AND (CNUM=" -------Third string &(CNUMQS) ------last variable ---- (imp *****not a string)