OpenEuphoria

EUSQL variables in statement

• Posted by sixs <sixs at ida.net> Nov 01, 2004
• 650 views

Hello,
I want to select different tables and use the same statement.
I would appreciate any help\
Thanks
Jim

This is my code
   ICATID = getText( ECATID )
   trace(1)
   ICATID = ICATID
   set_parameter("HCATID",ICATID)
   ok = select_current( thisdb, ICATID )
   trace(1)
   eraseItems(Combo4)
   IMEID = getNumber( EMEID )
   trace(1)
   IMEID = IMEID
     set_parameter("HMEID",IMEID)
   trace(1)
         sql = "SELECT * FROM " & ICATID&"  WHERE " & ICATID&". [HMEID] 
= "& "[HMEID];"
           sql =  "SELECT * FROM [HCATID] WHERE VAL(MEID) =  [HMEID];"
trace(1)