Importing Text File and ListBox 1

[cenwesi]

Apart from me having to read a text file line by line and using the listbox.additem(...) function, is there another way or a better way to do this. Like with datawindow we can use the importfunction. Infact are there any free activeX control that can be used???

 

[wsmall73]

You can import a text file into a datawindow using

l_ret=dw_1.ImportFile(ls_doc_path)

I use it all the time. Works like a champ. Be sure to define your datawindow with the same columns as your tab delimited text file.

 

[cenwesi]

i guess you missed my point... is there a similar function for a listbox or better yet and nice ActiveX control for doing this?

 

[wsmall73]

not for a listbox... your would have to loop through your result set using probably a fetch or retrieving into a datastore and looping through that....but I guess the point would be.. what functionality are you gaining by using a listbox?

 

[pgaec]

how about a dropdown datawindow?

 

[wsmall73]

that was exactly where I was heading...

 

[cenwesi]

you guys, i already know all the datawindow function. What i was hoping for was a similar function like importfile for listbox control

 

[PowerObject]

Maybe Sybase thought it was not worth it offering an ImportFile() function for a ListBox. It would have been nice to have it natively in PowerBuilder but you can write it yourself - reading and adding each line as an item in the listbox. See Help on FileOpen, FileRead, FileClose... functions. And if you declare this in your ancestor listbox, it is always available. As you know, a listbox can offer you only one column's data compared to a datawindow/datastore that can support multiple columns, dropdown-edit style, ShareData()...

---
PowerObject!
-----------------------------------------

http://Groups.Yahoo.com/group/PowerObject

PowerBuilder / PFC Developers' Group

 

[romeyson]

test