[Gambas-user] Database Edit error with SQlite

[Jeff Johnson]

Everything works fine now, except for the rWeather.update  that I have before 
$hConn.commit

Gambas reports SQL Error of missing database

a .count reports that it did find the record, but it can not update the record

Thank you for your help



On Saturday 28 August 2004 5:57 am, Benoit Minisini wrote:
> On Saturday 28 August 2004 03:09, Jeff Johnson wrote:
> > $hConn AS Connection
> > rWeather AS result
> >
> > PUBLIC SUB Form_Open()
> >
> > $hConn = NEW Connection
> >
> >
> >   WITH $hConn
> >     .Type = "sqlite"
> >     .Name = "/home/jeffjohnson/projects//Database/WXaprs/WXaprs.db"
> >     .open
> >   END WITH
> >
> > END
> >
> > PUBLIC SUB Button1_Click()
> > DIM rWeather AS result
> >
> > $hConn.Begin
> >
> > >>>>I do not get past this line
> >
> > rweather = $hconn.edit("ClimateData","Callsign = &1","THORN")
> >
> > >>>>>I get an error "Type mismatch: Wanted Void, Got String instead"
> > >>>>
> > >>>>What am I doing wrong?
>
> Nothing, this is a bad bug in the interpreter... I join a patch that fixes
> it. Put it in ./src/exec.
>
> Tell me if you have any problem with it.
>
> Regards,