Re: Error trying to close EDS database
- Posted by ronaustin at alltel.net Oct 14, 2003
- 551 views
--------------Boundary-00=_Q3GQQL80000000000000 charset="iso-8859-1" =0D =0D -------Original Message-------=0D =0D From: EUforum at topica.com=0D Subject: Re: Error trying to close EDS database=0D =0D =0D =0D ronaustin at alltel.net wrote:=0D =0D >=0D > So I am creating the table more than once. Would it then be better to =0D > write a short install program that would be ran one timR>=0D >=0D You could just check for the existence of the table and create it if it =0D doesn't exist...=0D =0D err =3D db_select_table("whatever")=0D if err !=3D DB_OK then=0D err =3D db_create_table("whatever")=0D end if=0D -- keep going...=0D =0D I see what you mean. I changed the program as suggested (actually I just removed the db_create) and it's adding records like a charm. Now I have = to work on a way to retrieve, edit and save them.=0D =0D Thanks everybody for your help.=0D =0D =0D =0D =0D TOPICA - Start your own email discussion group. FREE!=0D =0D =0D =0D =0D =2E=20 --------------Boundary-00=_Q3GQQL80000000000000 Content-Type: Text/HTML; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable <HTML><HEAD> <META http-equiv=3DContent-Type content=3D"text/html; charset=3Diso-8859-= 1"> <META content=3D"IncrediMail 1.0" name=3DGENERATOR> <!--IncrdiXMLRemarkStart> <IncrdiX-Info> <X-FID>FLAVOR00-NONE-0000-0000-000000000000</X-FID> <X-FVER></X-FVER> <X-CNT>;</X-CNT> </IncrdiX-Info> <IncrdiXMLRemarkEnd--> </HEAD> <BODY style=3D"BACKGROUND-POSITION: 0px 0px; FONT-SIZE: 12pt; MARGIN: 5px= 10px 10px; FONT-FAMILY: Arial" bgColor=3D#ffffff background=3D"" scroll=3D= yes ORGYPOS=3D"0" X-FVER=3D"3.0"> <TABLE id=3DINCREDIMAINTABLE cellSpacing=3D0 cellPadding=3D2 width=3D"100= %" border=3D0> <TBODY> <TR> <TD id=3DINCREDITEXTREGION style=3D"FONT-SIZE: 12pt; CURSOR: auto; FONT-F= AMILY: Arial" width=3D"100%"> <DIV><BR> </DIV> <DIV id=3DIncrediOriginalMessage><I>-------Original Message-------</I></D= IV> <DIV> </DIV> <DIV id=3Dreceivestrings> <DIV dir=3Dltr style=3D"FONT-SIZE: 11pt" <i><B>From:</B></I> <A href=3D"m= ailto:EUforum at topica.com">EUforum at topica.com</A></DIV> <DIV dir=3Dltr style=3D"FONT-SIZE: 11pt" <i><B>Date:</B></I> Tuesday, Oct= ober 14, 2003 1:19:43 AM</DIV> <DIV dir=3Dltr style=3D"FONT-SIZE: 11pt" <i><B>To:</B></I> <A href=3D"mai= lto:EUforum at topica.com">EUforum</A></DIV> <DIV dir=3Dltr style=3D"FONT-SIZE: 11pt" <i><B>Subject:</B></I> Re: Error= trying to close EDS database</DIV></DIV> <DIV> </DIV> <DIV>=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 <BR><BR><BR><A href=3D"mailto:ronaustin@al= ltel.net">ronaustin at alltel.net</A> wrote:<BR><BR>><BR>> So I am cre= ating the table more than once. Would it then be better to <BR>> write= a short install program that would be ran one timR><BR>><BR>You co= uld just check for the existence of the table and create it if it <BR>doe= sn't exist...<BR><BR>err =3D db_select_table("whatever")<BR>if err !=3D D= B_OK then<BR>err =3D db_create_table("whatever")<BR>end if<BR>-- keep goi= ng...</DIV> <DIV> </DIV> <DIV><FONT color=3D#ff8000>I see what you mean. I changed the progr= am as suggested (actually I just removed the db_create) and it's adding r= ecords like a charm. Now I have to work on a way to retrieve, edit = and save them.</FONT></DIV> <DIV><FONT color=3D#ff8000></FONT> </DIV> <DIV><FONT color=3D#ff8000>Thanks everybody for your help.</FONT></DIV> <DIV><BR><BR>--^---------------------------------------------------------= -------<BR>This email was sent to: <A href=3D"mailto:ronaustin at alltel.net= ">ronaustin at alltel.net</A><BR><BR>EASY UNSUBSCRIBE click here: <A href=3D= "http://topica.com/u/?b1dd66.b6KEgr.cm9uYXVz">http://topica.com/u/?b1dd66= =2Eb6KEgr.cm9uYXVz</A><BR>Or send an email to: <A href=3D"mailto:EUforum-= unsubscribe at topica.com">EUforum-unsubscribe at topica.com</A><BR><BR>TOPICA = - Start your own email discussion group. FREE!<BR><A href=3D"http://www.t= opica.com/partner/tag02/create/index2.html">http://www.topica.com/partner= /tag02/create/index2.html</A><BR>--^-------------------------------------= ---------------------------<BR><BR><BR><BR><BR>. </DIV></TD></TR> <TR> <TD id=3DINCREDIFOOTER width=3D"100%"> <TABLE cellSpacing=3D0 cellPadding=3D0 width=3D"100%"> <TBODY> <TR> <TD width=3D"100%"></TD> <TD id=3DINCREDISOUND vAlign=3Dbottom align=3Dmiddle></TD> <TD id=3DINCREDIANIM vAlign=3Dbottom align=3Dmiddle></TD></TR></TBODY></T= --------------Boundary-00=_Q3GQQL80000000000000--