OpenEuphoria

Re: EUSQL variables in statement

• Posted by Matt Lewis <matthewwalkerlewis at yahoo.com> Nov 01, 2004
• 682 views

sixs wrote:
> 
> 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)

Sorry, I'm not sure what you mean here.  But I can tell you that you can't
use a parameter to specify a table or a field name.  Perhaps if you told
me more about what your code was trying to do, I could offer better 
advice.

Matt Lewis