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.
Tony Hoyle <tony.hoyle at march-hare.com> writes: > 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). Oracle provides INSERT .... RETURNING (someColumn) INTO :someBindVariable for precisely this purpose. Oracle also has sequences rather than auto-increment columns. Anthony -- Anthony Williams Software Developer Just Software Solutions Ltd http://www.justsoftwaresolutions.co.uk