|
Apparently I am missing something very simple here… I am trying to load a user record that contains and identity
record. No matter what I try, the user.getIdentityRecord() function will
only try to select based on the identity PK. Here is my XML config: <reactor> <config> <project
value="test"/> <dsn
value="test" /> <type
value="mssql" /> <mapping
value="/reactorData" /> <mode
value="development" /> </config> <objects> <object
name=" User"> <hasOne
name="identity"> <relate
from="ID" to="UserID" /> </hasOne> </object> <object
name="Identity"> <hasOne
name="User"> <relate
from="userID" to="ID" /> </hasOne> </object> </objects> </reactor> Here is the code that I use: user
= reactor.createRecord("User"); user.setID(2168); user.load(); ident
= user.getIdentityRecord(); debug.dump(ident.getFirstName()); The dump of the ident.getFirstName() function is always
empty. Since have SQL statement output enabled, I am able to find the
statement that handles this, and the WHERE looks like this: [indentity].[id] = Why isn’t this statement using the userID field
specified in the XML file? Since this is a primary feature, I assume that
I am simply misunderstanding something about this feature. Could anyone
shed any light? Thanks, Chris |
