How select multi record in one time in a multiple record form

Applications Forms
#1

I’ve multiple record form and I want to use the first radiobox field to select records.

My goal is to copy these selected records to another table with same structure.

How can manage out this problem ?
How can I write a WHERE cause that say… only selected…fields .

Thanks

update.jpg

#2

If I’m not mistaken, then there’s a youtube sample of processing each individual record. Then you can use an event to individual move each record.

#3

I have a button like “copy selected rows” with this code
$sql_recopy =
“INSERT INTO iteprarig( numrig, codice, descri, descrb, descrl, riflegge, id_stapra_default, status_descri, id_tipdat, gg_prev, allegato_doc, allegato_img )
SELECT numrig, codice, descri, descrb, descrl, riflegge, id_stapra_default, status_descri, id_tipdat, gg_prev, allegato_doc, allegato_img
FROM iterig_temp WHERE XXXXXXX = 1
ORDER BY numrig
ON DUPLICATE KEY UPDATE dataua = NOW()”;
sc_exec_sql($sql_recopy);

I need to substitute the WHERE clause with ??? something . I think it would be a sistem variable {XXXX}

I did a youtube search without success. There was an old tutorial for a problem like this but it’s really for a beginning version 5 or 6 and quite everything is different from actual version and features.

#4

[QUOTE=giovannino;18228]
I did a youtube search without success. There was an old tutorial for a problem like this but it’s really for a beginning version 5 or 6 and quite everything is different from actual version and features.[/QUOTE]

Look at SCs homepage for videos, not at youtube … In this video at 09:58 h the run button is what you look for …

#5

Hi,
I trying to use multiple record form with a checkbox field and Mark every column to yes.
After saving selected rows I use the button with the sql insert code.
It’s not very elegant but in someway it works.