Postby ConvertFromOldNGs » Fri Aug 07, 2009 11:44 am
by The_Swami >> Mon, 8 Nov 1999 19:16:41 GMT
CBTDEV,
Yes it can be done. I have managed to do it through the Borland Database Engine and also through MS Query. This was back on Jade 4. However the performance wasn't great (it took just over 1 minute to retrieve a single record from a class containing approx 60 000 objects). I haven't tried it under Jade 5 yet though I have heard that the performance has improved.
The way I did it was by first installing the Jade ODBC driver and then setting up a relational view of the classes I wanted to expose. Once that was done I could acess it like any other ODBC data source. However there is one small limitation. Only Level 0 SQL was supported by Jade 4 and from memory that hasn't changed in Jade 5.
Also make sure you don't have any class names that are reserved words in SQL, I'm not sure if you can use the escape characters around them so play it safe and don't expose classes with names like, say, Group.
The Swami.