Community technical support mailing list was retired 2010 and replaced with a professional technical support team. For assistance please contact: Pre-sales Technical support via email to sales@march-hare.com.
Paulo Soares wrote: > The problem is not creating the tables in plsql or with toad. First of > all, there no docs about the tables itself and second that would > apparently not work anyway because of the identity that must be returned > from the row. I'll have to look at the source. There's a visio file in the source directory plus the various *.sql files that get installed for other databases. There's really only one key, and that's the ID that gets created in the session table, which links to all the other tables. The ID columns in the other tables are for consistency - you could get away without implementing them (at the moment anyway). The identity columns are always called ID - a habit I picked up years ago and don't plan on breaking in the future - so you could use the column name reliably in the code to identify them. The trick is getting the correct one after the insert (since on a busy server many clients may be creating rows at the same time). Tony