strange behaviour on array

[D.Cardoen]

Hello,

when I put on a listbox datasource some names i can create a excel file
with data
from a sql file
listbox double click function

but when I create

a listbox on open
with a small qsl an array and fill up the listbox by double click only the
excel tempelate opens but don't get the data when I double click on the list
box

for both I use an variable in my sql statement

regards

Dirk C

[Geoff Wass [dBVIPS]]

Post by D.Cardoen
Hello,
when I put on a listbox datasource some names i can create a excel file
with data
from a sql file
listbox double click function
but when I create
a listbox on open
with a small qsl an array and fill up the listbox by double click only the
excel tempelate opens but don't get the data when I double click on the list
box
for both I use an variable in my sql statement
regards
Dirk C

Dirk,

Can you show us the code which worked and the code which didn't?

[Geoff Wass [dBVIPS]]

Hello Geoff

Dirk,

You new code:

this.VISTBX = new LISTBOX(this)
with (this.VISTBX)
onOpen = class::VISTBX_ONOPEN
onLeftDblClick = class::VISTBX_ONLEFTDBLCLICK
height = 176.0
left = 0.0
top = 0.0
width = 196.0
id = 101
endwith

does not have any dataSource. Therefore, the LISTBOX is completely
empty. So, cVert will be an empty string and the whole SQL string
probably has nothing to return when cVert is empty.