How to combine Var for Listbox from SGLQuery? (REALbasic getting started Mailinglist archive)
Back to the thread list
Previous thread: GroupBox enabling?
Next thread: How do I Accept Tabs in Styled EditField as five spaces
| RE: Using the 2005 DB Example - Dixon, Tom | |
| How to combine Var for Listbox from SGLQuery? - Jonathon Bevar | |
| How to combine Var for Listbox from SGLQuery? |
| Date: 09.01.06 04:34 (Sun, 8 Jan 2006 20:34:01 -0700) |
| From: Jonathon Bevar |
|
Ok, I got the 2005 DB Example working as I found out I had one letter
missing in the SQLQuery. Here is what I had first: SELECT PatientNumber, PatienLastName, PatientRevNo, PatientRevDate FROM Patients. It should of been this: SELECT PatientNumber, PatientLastName, PatientRevNo, PatientRevDate FROM Patients. As you can see I forgot the "t" in the PatientLastName. After that, it works GREAT! Wow, no error came up at all so it was a major pain to figure it out. Ok, now I would like to have the Patient Name be shown in the ListBox like this: Bevar, Jonathon M. NOTE: I have the form to enter the First Name, Middle Name and Last Name seperately, but I want the Listbox to combine all 3 into one entry. Is this possible in the SQLQuery function? Currently it is just the Last Name shown in the ListBox. How or what do I need to do to make it come out like the above as for: LastName comma then space then FirstName space then MiddleName? The ListBox has a heading of: Patient Name. Can I do what I want without breaking up the ListBox column. I want this way as some names are long or short and it will it look more PRO then having a bunch of columns. Thanks Jonathon |
Links
MBS Realbasic Plugins - Pfarrgemeinde St. Arnulf Nickenich