Hi all,

I am facing a problem in populating data into ListBox.

I am using 2 buttons viz., " Add" and "Remove" to insert and remove Values
into ListBox.

I am calling a Custom Action to achieve this.

After Adding few values into ListBox. If i try to remove any element in the
ListBox and then try adding Again,
I am getting an error as *Function failed during execution. Database:
Table(s) Update failed.*

The code i am using in the Custom Action are as given below:

[ Add Button ]
_______________________________________________________________________________________________________

i = s.Database.CountRows("ListBox");

View v;

v = s.Database.OpenView("INSERT INTO `ListBox`
(`Property`,`Order`,`Value`,`Text`) VALUES ('MACLIST'," + (i) + ",'" + s[
"MACNAME"] + "','" + s["MACNAME"] + "')TEMPORARY");

v.Execute();

v.Close();

____________________________________________________________________________________________________________
[Remove
Button]________________________________________________________________________________________________________

View v;

v = s.Database.OpenView("DELETE FROM `ListBox` WHERE (`Value`='"+s["MACLIST"
]+"')");

v.Execute();

v.Close();

_______________________________________________________________________________________________________________

Please let me know where i might be going wrong.

Thanks,

Pavan
-------------------------------------------------------------------------
This SF.Net email is sponsored by the Moblin Your Move Developer's challenge
Build the coolest Linux based applications with Moblin SDK & win great prizes
Grand prize is a trip for two to an Open Source event anywhere in the world
http://moblin-contest.org/redirect.php?banner_id=100&url=/
_______________________________________________
WiX-users mailing list
WiX-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/wix-users

Reply via email to