Hello:

I have used the Class Designer with a sqlite3 database to create a grid that

displays the look up value

that corresponds to foreign key value, as described in archived posts and the

Wiki. When I use the

SQL Builder to create the query which contains a field alias, things display

properly. When I create the identical

SQL statement manually and utilize UserSQL, I generate an error. The manual SQL

statement works when I run it

directly against sqlite3 and the database. I am interested in using UserSQL and

manual SQL statements rather

than SQL Builder, in order to create SQL statements that contain Table aliases.

SQL Builder does not seem to

allow Table aliases although it does permit field aliases.

I am running Windows XP Pro SP2, Python Version: 2.4.4 on win32, Dabo Version:

Version 0.9a; Revision 3335,

UI Version: 2.8.1.1 on wxMSW and SQLite version 3.3.12.

The generated error is:

Traceback (most recent call last):

File "C:\projects\dabo\lib\eventMixin.py", line 97, in raiseEvent

bindingFunction(event)

File "C:\projects\dabo\ui\uiwx\dPemMixin.py", line 1155, in __onUpdate

self.update()

File "C:\projects\dabo\ui\dDataControlMixinBase.py", line 109, in update

self.Value = method()

The functioning code is:

/**********works****************/

class FotoinfBizobj(dabo.biz.dBizobj):

def afterInit(self):

self.DataSource = "FotoInf"

self.KeyField = "count0"

self.LinkField = "recordID_fk"

self.addFrom("FotoInf")

self.addField("recordID_fk")

self.addField("FInfoID_fk")

self.addField("count0")

self.addJoin("InfoPT", "FotoInf.FInfoID_fk= InfoPT.InfoID")

self.addField("InfoPT.photoType as phType")

def validateRecord(self):

"""Returning anything other than an empty string from

this method will prevent the data from being saved.

"""

ret = ""

# Add your business rules here.

return ret

fotoinfBizobj = FotoinfBizobj(self.Connection)

self.addBizobj(fotoinfBizobj)

fotoinfBizobj.setLimitClause(None)

recnameBizobj.addChild(fotoinfBizobj)

The code that generates the error is:

/******************does not work***********************************/

class FotoinfBizobj(dabo.biz.dBizobj):

def afterInit(self):

self.DataSource = "FotoInf"

self.KeyField = "count0"

self.LinkField = "recordID_fk"

def validateRecord(self):

"""Returning anything other than an empty string from

this method will prevent the data from being saved.

"""

ret = ""

# Add your business rules here.

return ret

fotoinfBizobj = FotoinfBizobj(self.Connection)

self.addBizobj(fotoinfBizobj)

testsql = """Select FotoInf.count0, FotoInf.recordID_fk, FotoInf.FInfoID_fk,

InfoPT.photoType as phType

From FotoInf inner join InfoPT on FotoInf.FInfoID_fk = InfoPT.InfoID"""

fotoinfBizobj.UserSQL= testsql

fotoinfBizobj.setLimitClause(None)

recnameBizobj.addChild(fotoinfBizobj)

thank you,

dwarder