Selecting Data
Posted: Sun Mar 13, 2016 1:23 am
I have this bit of code:
This, I believe, is the code for when populating a data grid. However, I was wondering if there was a way to get the query data put into an array so I can display each piece of data seperatly without using a datagrid.
I would like to populate text fields with the data from the query. In this instance, what I'm after is something along the lines of dbData[collum1] dbData[collum2]. The queries that will be run only return 1 row from the database.
Code: Select all
put "SELECT * FROM customers WHERE company = '"&company& "'" into dbSQL
put revDataFromQuery(tab,return,connectionID,dbSQL) into dbData
if item 1 of dbData = "revdberr" then
answer error "There was a problem" & cr & dbData
end if
answer dbData
I would like to populate text fields with the data from the query. In this instance, what I'm after is something along the lines of dbData[collum1] dbData[collum2]. The queries that will be run only return 1 row from the database.