SQL Lite and QM

[stupomer]

Hi Gintaras,
You never cease to amaze me and this is just the functionality that I was looking for. Thank you!

I was looking for select row function - like in the LB and CB functions but it turns out, the normal acc functions work! I assume I can substitute a str for the Namewhich can be filled based on search results but I wonder if it will be a problem with duplicates. Is this a good strategy or is there a way of having direct row selection through another function?

Function Function10

Code:

Copy      Help

Acc a=acc("a" "LISTITEM" win("QM_Grid" "#32770") "QM_Grid" "" 0x1001)
a.Select(SELFLAG_TAKEFOCUS|SELFLAG_TAKESELECTION)

2.0
Acc v=acc("k" "LISTITEM" win("QM_Grid" "#32770") "QM_Grid" "" 0x1001)
;v.Select(SELFLAG_ADDSELECTION)
v.Select(SELFLAG_EXTENDSELECTION)

In case it might be useful for others, I created a function From2dimArraytoSingleColum which helps me take the output from a specified column from all the selected rows (in my case, a list of exan numbers to be entered serially into another application to create a worlist in that application).

Member function str.From2dimArrayToSingleColumn

Code:

Copy      Help

function ARRAY(str)&a

fix(0)
int c r; str s
c=1;;set to desired column (0-based)
for r 0 a.len(2)
,addline(a[1 r])

I'm sure there is a direct way to make it without going through 2 dim array but this was easy to reverse-engineer from your work!

Thanks again,

Stuart