OpenEuphoria

Re: EuAql input

• Posted by pampeano at rocketmail.com Apr 14, 2003
• 386 views

Hi Jim,
   I think what you want to do is:
ok = run_sql( "INSERT INTO PEOPLE PEOPLE.KEYID, PEOPLE.LNAME VALUES(
'175', '"&HLNAME&"')")

Hope this helps,
    Guillermo Bonvehi

--- sixs at ida.net wrote:
> 
> Hi. 
> I can create sql edb database and add data as such :
> 
> run_sql( "INSERT INTO PEOPLE PEOPLE.KEYID,PEOPLE.LNAME values
> (112,'jimmy')") 
>      I want to have data from a windows and insert into the table:
> --Declare 
> sequence HLNAME
> ---get data from window
>  hlname = getText(Sle1)
> HLNAME = hlname
> ok = run_sql( "INSERT INTO PEOPLE PEOPLE.KEYID, PEOPLE.LNAME VALUES(
> '175', HLNAME)")
> I have looked at data inserted into the sql edb by selecting the data
> so i know I can insert  literal(112,'jimmy')  data and retrieve it.
> I have tried several things but I don't know what I'm doing in regard
> to getting data from getText command.!
> Jim