Hello,
I'm a new user of Torque and am trying to understand idMethod usage a little better. If I select to use the idBroker idMethod method for primary key generation then am I locked into Torque as the only means for inserting data into my tables? In other words, since Torque will be generating the id's then is it true that I shouldn't use another mechanism for inserting into a table using idBroker (i.e. direct JDBC call or non-Java script access) else Torque and the non-Torque methods may try to insert duplicate primary keys?
Thanks, David Sica
You can still use other methods you just need to be aware of the id_table appropriately named "id_table". The structure is straightforward so it is easy to understand. You would grab the next id for the table you are inserting into and update the next_id field for that table in id_table. I have not used it across a lot of different databases, but it looks like the structure and usage is the same in any supported database. I use id broker in databases where I am importing legacy data and id values into a new database. I just import the data and then adjust the next id value after the import is done. There are obviously some issues that may arise based on multiple users, but that may not be a problem for your needs.
Hope this helps, Rob
//--------------------------------------------------------------------
Rob Broadhead - Consultant
RB Consulting Inc.
[EMAIL PROTECTED]
//--------------------------------------------------------------------
--------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
