The Forums on slxdeveloper.com are now retired. The forum archive will remain available for the time being. Thank you for your participation on slxdeveloper.com!
|
|
FormatString User
Posted: 04 Jun 07 3:20 AM
|
Hi folks,
A simple query (or it seems to be) just have never had to do it before. Basically I'm looking to format an editbox (that brings back a userid from the database) as a username but... not in the default format of surname, firstname but in the format of firstname surname.
I'm assuming it's something to do with the FormatString property. Can you please shed some light.
Cheers
Kev |
|
|
|
Re: FormatString User
Posted: 05 Jun 07 3:10 AM
|
Sorry, it isn't. You just find those pieces and concatenate them into the eb e.g.
ebTextBox.Text = strFirstname & " " & strLastName |
|
|
|
Re: FormatString User
Posted: 05 Jun 07 9:26 AM
|
I use a LookupEdit Box....lookupId points to the UserID/AccountManagerId....no (NO!) ftType.....in the Text box I populate it on the OnChange of the form or PopUp Return of the Lookup.
DIM UDATA()
IF GETFIELDS("USERINFO FIELDS","USERINFO","USERID = '" & yourIDVariable & "' ",UDATA) THEN
leUSER.TEXT = UDATA(1) & " " & UDATA(2)
END IF |
|
|
|
Re: FormatString User
Posted: 05 Jun 07 9:46 AM
|
RJ Samp.. this looks like the direction I want to head in with this, any chance you could give me a bit more info on how the getfields function works? It's alien to me...
Cheers |
|
|
|
Re: FormatString User
Posted: 05 Jun 07 2:52 PM
|
| GetField and GetFields are in the "System:Database Support" script. Just included it in your script/form. |
|
|
|