Dialog.Input Something not quite right

[John31]

I am getting a strange error with the following code.


sCategory=Dialog.Input("NEW CATEGORY", "Please enter the Name for the New Category","" , MB_ICONQUESTION);
SQLite.Query(db, "Insert into groups(Cat) values( "..Enclose(MyEncrypt(sCategory))..")", nil);
ListBox.AddItem("ListBox2", sCategory);

If the CANCEL button is clicked instead of ending the routine the code inserts a new field in the database and listbox titled CANCEL.
What I want is for the user to be able to cancel the Dialog.Input routine and for no entries to be made in the database or ListBox.

Any Help Appreciated
John31

[Imagine Programming]

Hey there John,

I would suggest you check out the documentation on Dialog.Input.
It specifies the behaviour of this function. When a user clicks Cancel on
a Dialog.Input, the function returns the text CANCEL, you have to check
for that yourself.

sCategory=Dialog.Input("NEW CATEGORY", "Please enter the Name for the New Category","" , MB_ICONQUESTION);
if(sCategory ~= "CANCEL")then
	SQLite.Query(db, "Insert into groups(Cat) values( "..Enclose(MyEncrypt(sCategory))..")", nil);
	ListBox.AddItem("ListBox2", sCategory);
end

[John31]

Many thanks for the help, I missed the bit relating to CANCEL somehow (Time to see the optician).

[Imagine Programming]

Many thanks for the help, I missed the bit relating to CANCEL somehow (Time to see the optician).

Glad to help.
Hehe, it happens!