[Gambas-user] Database Edit error with SQlite

Jeff Johnson "Jeff Johnson" at direcway.com
Sun Aug 29 18:24:38 CEST 2004


If edit will not work without a Primary Key.. then that may be my problem..
I tried the Database example that came with Gambas. I do not remember it 
causing an error before, but it does now. When trying to create the primary 
key, it errors with "Unknown field: id"  I did apply the gb.exec.c patch you 
sent.

All of the other code in my program is extracting and processing the data from 
a Radio Shack (Oregon Scientific) wireless weather station and storing it in 
an Access database. It is from a Ham Radio APRS VB program I wrote many years 
ago.


Thanks for the help..

On Sunday 29 August 2004 6:46 am, Benoit Minisini wrote:
> On Sunday 29 August 2004 02:06, Jeff Johnson wrote:
> > I don't think you will have a problem with the segment I am sending..
> > Just change your path to the db
> >
> > On Saturday 28 August 2004 11:33 am, Benoit Minisini wrote:
> > > On Saturday 28 August 2004 22:24, Jeff Johnson wrote:
> > > > 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
> > >
> > > It may be another bug... Have you more information ? Can you send me
> > > some code with the correpsonding sqlite database ?
> > >
> > > Regards,
>
> I created a project from the files you sent me, but it is easier for me if
> you send me a complete archive of a project ("make source archive" in the
> Project menu).
>
> Your table has no primary key, which prevents the Edit() method working.
> There was a bug that prevented Edit() to stop with error, an so everything
> failed when calling Update().
>
> Regards,




More information about the User mailing list