UX List Update instead Insert

[dahas]

Hi
I have 2 list with more fields, list have same table as bind (proiecte) and use ID as (primary key).
Data from list 1 have one field active = 1 and list2 have same fild active = 0
What i want is to move from active list to inactive list and set active to zero (0) or one (1) depending of the case.
Just move 1 row from active to inactive (using javaaction) and submit i sow de sql is to insert data in table with ID key.
I try to interfer with it changing values of e.sqlArgs and e.sqlInsert on function beforeRecordInsert.
And I fail.
Is any way to update only that field only when i submit?
Or maybe is wrong my way i want to do that?

Here is what is on beforeRecordInsert function

function beforeRecordInsert

dim sql_insert as c ' what sql look like
dim args as sql::arguments ' arguments for sql
args.xml = e.sqlArgs.xml ' get xml from arguments
dim id as n ' how many arguments on list
id = e.sqlArgs.Count
if (id > 0) then
	if (args[id].data = "") then
		args[id].isNull = .t.
	end if
end if
sql_insert = e.sqlInsert; ' get sqlInsert on my own variable
sql_argumente = e.sqlArgs;

'INSERT INTO proiecte (id) VALUES (:proiecte_id) - here is how it looks the sqlInsert
'what i want to do 
'UPDATE proiecte SET activ = 0 WHERE id = 31;
e.sqlInsert = "UPDATE proiecte SET activ = 0 WHERE id = " + args[1].data

end function

Screenshot 2013-12-24 22.58.30.png

[lvasic]

Re: UX List Update instead Insert

If it's the same table then all you really need to do is set the flag and submit the record that is highlighted and refresh both lists. It will then give the appearance of moving to the other list.

[dahas]

Re: UX List Update instead Insert

You say to use buttons who send from a list to another and do acction there no with submit acction right?
Yes i was thinking at that too i will try and give a hint if it work more easy that way
That 2 pannels have 2 more down who is user list same way active and inactive to the project highlighted on list 1 left one :)
Than You for your answer
I will come back with answer if i find how to manage

[dahas]

Re: UX List Update instead Insert

Hi
I managed to solve doing 2 action on same onClick event.
1 who set on mysql data acording to move way
2 use acction list to move from List1 to List 2 or the other way.
Thank You lvasic.
I was in a trouble on second pair of list List3 and List4 when List3 have as key 2 fields but help me lastword function and using as separator ||| :)

[lvasic]

Re: UX List Update instead Insert

Good Deal. Can you post a video of your solution or a screen shot?

[dahas]

Re: UX List Update instead Insert

I will try but first have to translate on englis :) to can be read by any one.
I will look for mac or windos screen recording to get it done more easy