My front end SpiderBasic app is talking to a MySQL server hosted on another local box via XAMPP using php scripts. I can call the php scripts with HTTPReqest, my JSON comes back fine, - I can parse it just fine and dump to ListIcon- all the data is present EXCEPT data from a second call I make to fill in the rest of the structure.
Correction- the data does indeed 'get there' and the structure IS filled but the ListIcon grid is displayed before the structure is populated with data from specific columns from the JSON array. That data comes from the second HttpRequest. The first request, fills the data from the first part of the stucture (baseinfo), then the send HTTP call gets the second structure (eduinfo). The eduinfo finally gets there but the grid is already displayed even though I called my DisplayGrid() proc after the last HTTPrequest.
Below are the strutures I'm referring to:
Ary_employees\eduinfo\GPA - that's part of the struct that doesn't display UNTIL I to a refresh - which for now- I put a button on the form and just hit REFRESH and the column shows up- I don't want my users having to do this- no way.
I'm know this has something to do with some type of async / background task issue . I've tried setting up a simple global flag as a 'signal' to do a refresh on the grid- the flag variable doesn't get touched while the JSON is being parsed/processed.
I know you guys probably need more than this to really break it down- I'll see what I can come up with.
Thanks to all- I really like this forum- I just wish more people would 'discover' SpiderBasic. I can't believe how much I can do with very little code. And it's fast
Anyway- any help would be appreciated. - thanks again.
Code: Select all
Global Dim Ary_employees.struct_employees(400)
Structure struct_eduInfo
empID.s
school.s
gradDate.s
GPA.f
major.s
minor.s
cert.s
EndStructure
Structure struct_baseInfo
empID.s
lastname.s
firstname.s
stAddress1.s
stAddress2.s
city.s
state.s
zipcode.s
ssn.s
dob.s
phone1.s
phone2.s
email.s
EndStructure
Structure struct_employees
empID.s
baseinfo.struct_baseinfo
education.struct_eduInfo
EndStructure