I hope someone can help with an issue which I didn't think would be difficult, but has puzzled me for several hours:
I have a UX with a List Control that displays columnar data for future training courses that are offered (here's what the List Control looks like List_Control1.jpg).
In the "xbasic functions" section, I have written code to get the values of several fields (that are displayed on the UX) in a SQL "INSERT" command to update a table.
Here's my problem: I can Dim an "e.datasubmitted" command to get the value of any control on the UX. BUT, when I do e.datasubmitted.courses ("courses" is the name of the List Control), it returns only data from the first column (Class ID) of highlighted row.
I know I've done this before, but only the first column is returning a value. Here's what I've tried (NOTE: the numbers at the beginning are NOT in my code... I put them there, so that I can easily refer to them in this post):
1. dim courses as c = e.dataSubmitted.Courses
2. dim classID as c = word(courses,1,crlf())
3. dim courseID as c = word(courses,2,crlf())
4. dim className as c = word(courses,3,crlf())
When the program is run, line 1 (above) returns only the data in the FIRST COLUMN; Line 2 correctly returns the data 1st Column of the highlighted row. I expected line 3 (above) to give me the 2nd column and line 4 to give me the 3rd column (courses,3?), but both return no data at all!
I'm obviously using an incorrect syntax and I hope someone can show me how I can Dim the data of the specific columns in the highlighted row.
Thanks so much!
I have a UX with a List Control that displays columnar data for future training courses that are offered (here's what the List Control looks like List_Control1.jpg).
In the "xbasic functions" section, I have written code to get the values of several fields (that are displayed on the UX) in a SQL "INSERT" command to update a table.
Here's my problem: I can Dim an "e.datasubmitted" command to get the value of any control on the UX. BUT, when I do e.datasubmitted.courses ("courses" is the name of the List Control), it returns only data from the first column (Class ID) of highlighted row.
I know I've done this before, but only the first column is returning a value. Here's what I've tried (NOTE: the numbers at the beginning are NOT in my code... I put them there, so that I can easily refer to them in this post):
1. dim courses as c = e.dataSubmitted.Courses
2. dim classID as c = word(courses,1,crlf())
3. dim courseID as c = word(courses,2,crlf())
4. dim className as c = word(courses,3,crlf())
When the program is run, line 1 (above) returns only the data in the FIRST COLUMN; Line 2 correctly returns the data 1st Column of the highlighted row. I expected line 3 (above) to give me the 2nd column and line 4 to give me the 3rd column (courses,3?), but both return no data at all!
I'm obviously using an incorrect syntax and I hope someone can show me how I can Dim the data of the specific columns in the highlighted row.
Thanks so much!
Comment