Multi-line database

[Bruce]

In the code below when adding text to the notes area I would like the text to look like this:

hello
this
is
me

Insted of this:

here's the code:
function UpdateRecord(nID)

--Capture input fields to update the record.
local strWho = Input.GetText("account_Input");
local strLog = Input.GetText("login_Input");
local strPass = Input.GetText("password_Input");
local strNote = Input.GetText("notes_Input");
--Check to see that the above entries are valid

if strWho ~= "" and strLog ~= "" and strPass ~= "" and nID > 0 then

--Insert new account information
SQLite.Query(db, "UPDATE accounts SET who = "..Enclose(strWho)..", login = "..Enclose(strLog)..", pass = "..Enclose(strPass)..", notes = "..Enclose(strNote).." where ID = ".. nID, nil);


--Clear the Inputs
ClearInputs();
return 0;
else
Dialog.Message("Error", "Please provide an Account name, Login and Password before trying to Update an entry");
return nID;
end
end

How would I do this?

[Desolator]

Listboxes don't support new lines, you must manually split the string in a table and add each item in the listbox.

[bule]

He uses an input object. I don't know, for me, multiline strings work normally.

[longedge]

If you are using an input object and require it to return multiline values, then you have to tick the Multiline enabled property or you could set the property in code -
as in the help file -

-- Create properties table (only include items that should be changed)
tProperties = {};
tProperties.Multiline = true;

-- Set the properties of an input object
Input.SetProperties("Input1", tProperties);

[Bruce]

Yes, sorry it is an input object. Thanks longedge, how would I apply your idea in the above code?

[Desolator]

You right-click on the input object, open it's properties and set it as multi-line input.

[longedge]

Yes, sorry it is an input object. Thanks longedge, how would I apply your idea in the above code?

In the properties dialogue for the input object on the settings tab, the multiline property is immediately under the "fonts" button. You have the option to enable multiline and then having done so you can specify whether you want scroll bars or not.

Personall I'd only do it in code if there were a reason to change it at some time while the app is running. You might for instance be using the same input for a number of purposes and sometimes want multiline and other times not.

[Bruce]

You right-click on the input object, open it's properties and set it as multi-line input.

LOL duh! Ok I got it. Thanks

[Bruce]

This was checked already.
it must be somthing to do with the SQLite database.

[Desolator]

Then use something like $& instead of \r\n and replace it before writing to the input.