IUserAccessiableGetTableFromStore Method (String, String, String, String, String) |
Namespace: SurveyToGo.UserLogic.InterfacesAssembly: UserLogicInt.Pocket (in UserLogicInt.Pocket.dll) Version: 1.0.4.0
Syntax ITable GetTableFromStore(
string inStoreName,
string inColumns,
string inWhere,
string inOrder,
string inGroup
)
Parameters
- inStoreName
- Type: SystemString
Name of the subject store - inColumns
- Type: SystemString
Column name in SQL - inWhere
- Type: SystemString
Where command in SQL - inOrder
- Type: SystemString
Order command in SQL - inGroup
- Type: SystemString
Group by command in SQL
Return Value
Type:
ITableReturn Value
Type:
ITableExamples if I would like to get specific data from my table,
I can use this function as follows:
GetTableFromStore("my_store123","country","@@country='Holland'","")[0])
This will return the row from ‘country’ column then you can use this row to pull out from its columns:
if we put the row inside a var called ‘myrow’, so we
can go to column number 2, like this: myrow[1];
See Also