Hi, I have read SimpleORM white paper, and seen that I have to maintain my own collection for child objects by hand. My presentation layer relies on this...
Bonjour Franck, Not sure if I understand you correctly but you want to get all objects that reference another row in a related table? If yes do it like this : ...
Bonjour, ... Quite true. But in fact I really want to get all objects that reference several rows in a related table (several parents and their respective ...
Hi Franck, I won't call myself experienced, but I think I can help: read inline comments ... no problems here ... to generate the "in-list" for the in (....)...
Again I want to make sure since I find this so simple that I might be missing something. Instead of your abstract names let me provide a more concrete scenario...
DISCLAIMER this code has not been tested I just saw some flagrant syntax errors in it. Should be easy to correct. VB.NET is starting to corrupt me! ;-) ... be ...
... No, no, this is really simple indeed. I just want to retrieve a bunch of "invoices", get their "invoiceDetails" in Collections contained by each invoice,...
... queries ... invoiceDetails ... If the invoice objects are already in cache no query will be done in database. If they arent a query will have to be made...
Hello, This email message is a notification to let you know that a file has been uploaded to the Files area of the SimpleORM group. File :...
SimpleORM@yahoogroups...
May 7, 2004 6:20 pm
830
... This is sort of deliberate. Join semantics are a little weird, IMHO. Logically you create a huge cross product, and then select a tiny subset. It is easy...
Anthony & Melissa Ber...
berglas@...
May 13, 2004 9:15 am
831
Hello Florian, Um, this sort of thing is supposed to work. If you look at the code for eq you'll see that it calls eqReference to recur through the keys. Are...
Anthony & Melissa Ber...
berglas@...
May 13, 2004 9:20 am
832
Have a look at the long transactions test. But this is only partially supported by SimpleORM, and it would be a good thing to add. Anthony...
Anthony & Melissa Ber...
berglas@...
May 13, 2004 9:21 am
833
Hello Anthony, I don't think this is supposed to work. What I meant is a query over three joined tables: Order, User and Company. To get all orders from all...
Florian Fankhauser
f.fankhauser@...
May 13, 2004 9:47 am
834
No you are right. This is only doable via SQL/rawClause. Unless you want to do : - a query for the users of a company - a query for each users to obtain the...
I agree with this. A little performance hit for the sake of simplicity is often worth it. ... above, ... if you ... IMHO. ... joins ... eg. ... queries, ... ...
Hello all, when using SQuery.SQY_OPTIMISTC, I can update all fields and properly check whether they have been modified, ie. I can perform a set...() method on...
Sorry, misunderstood. There is actually a facility to create virtual fields, have a look at SCOLUMN_QUERY. You can specify a subquery with it. This means...
Anthony & Melissa Ber...
berglas@...
May 16, 2004 7:29 am
839
It isn't a major problem for me too. I just want to be sure, that I have got it right. SimpleORM's query language is sql, so this is ok. ... I defined the...
Florian Fankhauser
f.fankhauser@...
May 17, 2004 10:47 am
840
Can someone on this list confirm that the semantics of SFieldReference values are intentionally overloaded, and that a "null" value in a reference field can...
hey hey, just thought id tell you guys about this free debt consolidation site that reduced my monthly payments by damn near half, no more worries about bills!...
Hi Sylvain or others, After I got stuck using the jdbc.odbc Driver and a DSN on Win XP. I could do ~ 800 inserts, above that it became shaky and the...
Alexander Banthien
alexander@...
May 20, 2004 1:10 pm
843
Hello, SimpleORM throws a cast exception if i pass a non SRecordInstance instance to the SRecordInstance.equals method. I think it should simply return false...
Florian Fankhauser
f.fankhauser@...
May 21, 2004 12:39 pm
844
Hi all .NET people on the list! who is using Sylvain's ADODriver to build the java.sql.Connection? can you please give me a hint as to what needs to be passed...
Hi there, I am currently in vacation in south carolina and so I dont have my source code with me. The point of that so called bridge is to delegate the call to...
I'm sorta stuck here and not sure if its my compiler, my lack of experience in Java or something with the class SRecordInstance. Per the SRecordInstance class,...
Leave getMeta() as it is an add another method for your static meta-getter, maybe: public static getRecordMeta() Or simply make the static meta field public...
Florian Fankhauser
f.fankhauser@...
Jun 2, 2004 1:45 pm
848
Hah - too logical. Thanks. I like the idea of a public static getRecordMeta() method rather than making meta public. I guess I was just getting hung up on the...
As I am coming up to speed with SimpleORM I am using MySQL as my DB. I have encountered a limitation with the supplied createTableSQL and would like some...