1. EuAql input
- Posted by sixs at ida.net
Apr 12, 2003
This is a multi-part message in MIME format.
------=_NextPart_000_0030_01C30106.076D6FF0
charset="iso-8859-1"
Hi.=20
I can create sql edb database and add data as such :
run_sql( "INSERT INTO PEOPLE PEOPLE.KEYID,PEOPLE.LNAME values =
(112,'jimmy')")=20
I want to have data from a windows and insert into the table:
--Declare=20
sequence HLNAME
---get data from window
hlname =3D getText(Sle1)
HLNAME =3D hlname
ok =3D 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
------=_NextPart_000_0030_01C30106.076D6FF0
Content-Type: text/html;
charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML><HEAD>
<META http-equiv=3DContent-Type content=3D"text/html; =
charset=3Diso-8859-1">
<META content=3D"MSHTML 6.00.2800.1106" name=3DGENERATOR>
<STYLE></STYLE>
</HEAD>
<BODY style=3D"COLOR: #000000; FONT-FAMILY: " bgColor=3D#ffffff>
<DIV><FONT face=3DArial size=3D2>Hi. </FONT></DIV>
<DIV><FONT face=3DArial size=3D2>I can create sql edb database and add =
data as=20
such :</FONT></DIV>
<DIV><FONT face=3DArial size=3D2></FONT> </DIV>
<DIV><FONT face=3DArial size=3D2>run_sql( "INSERT INTO PEOPLE=20
PEOPLE.KEYID,PEOPLE.LNAME values =
(112,'jimmy')") <BR> =20
I want to have data from a windows and insert into the =
table:</FONT></DIV>
<DIV><FONT face=3DArial size=3D2>--Declare </FONT></DIV>
<DIV><FONT face=3DArial size=3D2>sequence HLNAME</FONT></DIV>
<DIV><FONT face=3DArial size=3D2>---get data from window</FONT></DIV>
<DIV><FONT face=3DArial size=3D2> hlname =3D =
getText(Sle1)</FONT></DIV>
<DIV><FONT face=3DArial size=3D2>HLNAME =3D hlname</FONT></DIV>
<DIV><FONT face=3DArial size=3D2>ok =3D run_sql( "INSERT INTO PEOPLE =
PEOPLE.KEYID,=20
PEOPLE.LNAME VALUES( '175', HLNAME)")</FONT></DIV>
<DIV><FONT face=3DArial size=3D2>I have looked at data inserted into the =
sql edb by=20
selecting the data so i know I can insert =
literal(112,'jimmy') data=20
and retrieve it.</FONT></DIV>
<DIV><FONT face=3DArial size=3D2>I have tried several things but I don't =
know what=20
I'm doing in regard to getting data from getText command.!</FONT></DIV>
------=_NextPart_000_0030_01C30106.076D6FF0--
2. Re: EuAql input
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
