EuAql input
- Posted by sixs at ida.net Apr 12, 2003
- 382 views
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--