Radicore Forum: How To » Use the ADD5 template

Home » RADICORE » How To » Use the ADD5 template

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

Re: Use the ADD5 template [message #1582 is a reply to message #1572]

Thu, 28 August 2008 11:08

gpatti
Messages: 283
Registered: August 2008

Senior Member

I looked at COPY and PASTE but if I understand correctly, that only works one row at a time. My application really needs to work in batches. I do understand the ADD5 transaction isn't what I need, but I was just experimenting to see how things worked.

My application is to manage exams. So I have an exam session table linked to an exam table (effectively a header/detail construct). There are other foreign keys in the exam table e.g. candidate id, and exam_type_id etc. I wanted to build a transaction that allows me to select all the candidates that took a particular exam type on a previous session, and insert them back into the exam table for a new session with updated exam type details - effectively creating a new exam session based on candidates from a previous session.

I can do this with COPY / PASTE but would have to do one candidate at a time.

Do you have any suggestions?

Report message to a moderator

[Message index]

		Use the ADD5 template By: gpatti on Tue, 26 August 2008 13:46
		Re: Use the ADD5 template By: AJM on Tue, 26 August 2008 14:33
		Re: Use the ADD5 template By: gpatti on Tue, 26 August 2008 14:42
		Re: Use the ADD5 template By: AJM on Tue, 26 August 2008 18:19
		Re: Use the ADD5 template By: gpatti on Thu, 28 August 2008 10:37
		Re: Use the ADD5 template By: AJM on Thu, 28 August 2008 10:47
		Re: Use the ADD5 template By: gpatti on Thu, 28 August 2008 11:08
		Re: Use the ADD5 template By: AJM on Thu, 28 August 2008 11:33
		Re: Use the ADD5 template By: gpatti on Thu, 28 August 2008 11:43

Previous Topic:	pickup subdir from table and put into upload_subdir
Next Topic:	Display of task description

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

] [

]

Current Time: Tue Nov 26 05:30:33 EST 2024

Total time taken to generate the page: 0.00947 seconds