Fw: EuSql input
- Posted by sixs at ida.net
Apr 12, 2003
This is a multi-part message in MIME format.
------=_NextPart_000_0068_01C30108.2A6516A0
charset="iso-8859-1"
Sorry for mispelling of subject. other errors are free
----- Original Message -----=20
From: sixs at ida.net=20
Subject: EuAql input
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
TOPICA - Start your own email discussion group. FREE!
=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=
=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D
------=_NextPart_000_0068_01C30108.2A6516A0
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>Sorry for mispelling of subject. other =
errors are=20
free</FONT></DIV>
<DIV style=3D"FONT: 10pt arial">----- Original Message -----=20
<DIV style=3D"BACKGROUND: #e4e4e4; font-color: black"><B>From:</B> <A=20
title=3Dsixs at ida.net href=3D"mailto:sixs at ida.net">sixs at ida.net</A> =
</DIV>
<DIV><B>To:</B> <A title=3DEUforum at topica.com=20
href=3D"mailto:EUforum at topica.com">EUforum</A> </DIV>
<DIV><B>Sent:</B> Saturday, April 12, 2003 3:13 PM</DIV>
<DIV><B>Subject:</B> EuAql input</DIV></DIV>
<DIV><BR></DIV><PRE>=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D The Euphoria =
Mailing List =3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=20
</PRE>
<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>
<DIV><FONT face=3DArial =
size=3D2>Jim</FONT></DIV><PRE>=3D=3D^=3D=3D^=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=
=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=
=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=
=3D
This email was sent to: sixs at ida.net
EASY UNSUBSCRIBE click here: <A =
href=3D"http://topica.com/u/?b1dd66.b2NUvS.c2l4c0Bp">http://topica.com/u/=
?b1dd66.b2NUvS.c2l4c0Bp</A>
Or send an email to: EUforum-unsubscribe at topica.com
TOPICA - Start your own email discussion group. FREE!
<A =
href=3D"http://www.topica.com/partner/tag02/create/index2.html">http://ww=
w.topica.com/partner/tag02/create/index2.html</A>
=3D=3D^=3D=3D^=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=
=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=
------=_NextPart_000_0068_01C30108.2A6516A0--
|
Not Categorized, Please Help
|
|
