Does thinkwise have a sql function that I can use to copy a record? In the GUI there is a copy button. Can I use the functionality behind that button to use it in my sql code?
Thanks.
Page 1 / 1
Hi,
The GUI button does not run a SQL procedure to copy row data but instead it copies data from the selected row and uses that data to pre-fill the fields for your new row.
Having a copy button written in SQL is of course possible but there's no code that works in all cases. Best way to use data of a specific row in SQL is either by filling declared variables with it to use within your code or by joining the row to your queries.
Oke, thank you for your answer
Reply
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.