Skip to main content
Solved

copy record in sql


Forum|alt.badge.img+2

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

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.

View original
Did this topic help you find an answer to your question?
This topic has been closed for comments

2 replies

Mark Jongeling
Administrator
Forum|alt.badge.img+23
  • Administrator
  • 3944 replies
  • Answer
  • July 29, 2021

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.


Forum|alt.badge.img+2
  • Author
  • Vanguard
  • 24 replies
  • July 29, 2021

Oke, thank you for your answer


Cookie policy

We use cookies to enhance and personalize your experience. If you accept you agree to our full cookie policy. Learn more about our cookies.

 
Cookie settings