> -----Original Message-----
> From: [email protected] [mailto:[email protected]]
> On Behalf Of Paul McNett
> Sent: Tuesday, April 06, 2010 9:22 PM
> To: Dabo Users list
> Subject: Re: [dabo-users] Error message when requery recipes
>
> On 4/5/10 12:53 PM, Martinecz Miklós wrote:
> > I just created CklCategories.py in the PyCon Tutorial, and added it to
> the
> > Edit tab of the UI.
> >
> > Making a query on tab Select involves an error message (1054, "Unknown
> > column 'reccats.catid' in 'on clause'").
> >
> >
> >
> > I cannot find out what can cause this.
> >
> > The requery button on Select tab calls a function 'onRequery' :
> >
> > requeryButton.bindEvent(dEvents.Hit, self.onRequery).
> >
> >
> >
> > I am not very familiar with object oriented programming, probably this
> is
> > why I cannot find where this function resides.
> >
> > It probably would help to find out where the mistake is.
> >
> >
> >
> > Can anyone help in this?
>
> Can you please post the entire traceback?
>
> Paul
> _______________________________________________
Hi Paul,
There was no traceback only one row in the command window something like
this: "Failed to open the database with the following message:" and the
message appeared in a pup-up window with the text (1054, "Unknown column
'reccats.catid' in 'on clause'").
Meantime, I kept looking for the mistake and I just found it. The solution
is in the message.
I wrote 'reccats.catid' instead of 'reccat.catid' in the code
(biz/Reccat.py) at this part:
Class CategoriesForRecipe(Reccat)
...
def setBaseSQL(self):
self.super()
self.addJoin("reccats", "reccats.id = reccat.catid", "inner")
This is a nasty misspelling because 'reccats' is also a valid name but not
properly used in this SQL statement.
So the error is eliminated by now.
Thank you for your response,
Miklós
_______________________________________________
Post Messages to: [email protected]
Subscription Maintenance: http://leafe.com/mailman/listinfo/dabo-users
Searchable Archives: http://leafe.com/archives/search/dabo-users
This message:
http://leafe.com/archives/byMID/!~!uenerkvcmdkaaqacaaaaaaaaaaaaaaaaabgaaaaaaaaackgpanngp0urgxvyyklpm8kaaaaqaaaaqoif8ecg3e2kxdjpqlpymweaa...@upcmail.hu
