OpenEuphoria

EUSQL select statement

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

Hello Matt,
I want the select statement to be able to select the different tables in 
the database.  I have sevveral  tables., so I could have eight  
statements and have  to select one of the eight statements to execute 
the , but I hoped to have just one statement.
The user will select  the table  and it will be in a edittext field.

The user will choose the table. For instance tablex = table1, table2, etc.
the select statement
"select * from tablex where tablex. keyx = valuex;"
    HCATID = tablex   ; MEID and HMEID = keyx in tablex
HMEID and HCATID are values creaed from the set parameter command       
                              

 sql =  "SELECT * FROM [HCATID] WHERE VAL(MEID) =  [HMEID];"
 

Thanks
Jim