Concatenate question

[gkick]

WIN10 LO 7.3.2 HSQL 2.51

for a login procedure I need both username and password to appear in variables
encapsulated “jack” “pass” ADMIN without having to type the quotes in either textbox or
an input box.

How does one concatenate or manipulate such strings Concat(’" “’+“name”+’” "’) no good
Thanks for any pointers

Edit:

Ok, here is the generic SQL dialog used to maintain user access and priviledges for HSQL.
Now users will not have access to it as menu and toolbars are off.

Instead they will have a small form where the can change the password,etc.

This form will have a couple of textboxes to capture details to variables to be used to run the
sql in the background.

Now if quotes are omitted, HSQL converts stuff to uppercase which for some folks is not desirable.
As such if e.g. they type mypass1234 into a textbox, I need to somehow put the “ around for the
sql.

[Ratslinger]

Hello,

Don’t understand the question. Why don’t you instead present the situation instead of what you think is the direction to take? Cannot picture (although there is always a possibility) why user name and password need quotes or why they are to be concatenated. You do not even mention what login procedure you are referring to as there are multiple.

Please provide more details now and when asking the question.

[gkick]

@Ratslinger, have edited the post for more clarity

[Ratslinger]

Hello,

This has nothing to do with actual login. You seem to only want to create a string for use in an SQL statement.

Code you can copy:

Sub testString
Dim s1 as String
Dim s2 as String
Dim sSQL as String
s1 = "fred"
s2 = "Pass1"
sSQL = "CREATE USER """ & s1 & """ PASSWORD """ & s2 & """ ADMIN"
Print sSQL
End Sub

[gkick]

Thank you !