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.
Best answer by Mark Jongeling
View original
Userlevel 7
+23
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.
Reply
Enter your username or e-mail address. We'll send you an e-mail with instructions to reset your password.