This thread looks to be a little on the old side and therefore may no longer be relevant. Please see if there is a newer thread on the subject and ensure you're using the most recent build of any software if your question regards a particular product.
This thread has been locked and is no longer accepting new posts, if you have a question regarding this topic please email us at support@mindscape.co.nz
|
Hi, I have a table CUSTOMERS with a ID key column auto-increment. I must duplicate a record. Is it possible with lightspeed, or I must use a direct sql command like: INSERT INTO CUSTOMERS (fields_list) |
|
|
You mean keeping the ID? It's not possible with LightSpeed -- LightSpeed would want to allocate a new ID for the new record (or rather, it would want the database to allocate a new ID for the new record). If you just want to copy the fields, you can do that but you'll need to write code to set all the properties -- there's no "clone" method built in. |
|