Just as an additional note, when I change the column name of the child entity to something different, like 'Fabric_Quantity' then the problem goes away.
Robert On Oct 22, 11:16 am, Rawlins <[email protected]> wrote: > Hello Guys, > > I've stumbled across a problem this morning which is an unusual one. > It MAY be documented or expected behaviour but it caught me out so I > thought I would start conversations off here. > > When I have two objects that have matching column names (http:// > pastebin.com/x272btY7 *note the 'Quantity' column) but these two > columns have different data types, when loading from the database > Transfer throws a SQL error if the data in the child entity column > doesn't match the datatype of the parent entity. > > [Macromedia][SQLServer JDBC Driver][SQLServer]Conversion failed when > converting the varchar value '1.25' to data type int. > > The quantity column in my Fabric table is a varchar, and contains the > value 1.25. The quantity column in the OrderItem table is int. > > This does not occur when inserting the entity, only when loading it. > > Any ideas? is this normal? or a bug? Sorry for the sketchy > explanation, it was difficult to describe. > > Thanks, > > Robert -- Before posting questions to the group please read: http://groups.google.com/group/transfer-dev/web/how-to-ask-support-questions-on-transfer Try out the new Transfer ORM Custom Google Search: http://www.google.com/cse/home?cx=002375903941309441958:2s7wbd5ocb8 You received this message because you are subscribed to the Google Groups "transfer-dev" group. To post to this group, send email to [email protected] To unsubscribe from this group, send email to [email protected] For more options, visit this group at http://groups.google.com/group/transfer-dev?hl=en
