Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Visible table=.t.
Message
From
01/05/2007 08:56:17
 
 
To
01/05/2007 08:48:06
General information
Forum:
Visual FoxPro
Category:
Forms & Form designer
Environment versions
Visual FoxPro:
VFP 9 SP1
OS:
Windows XP
Database:
Visual FoxPro
Miscellaneous
Thread ID:
01221354
Message ID:
01221427
Views:
18
This message has been marked as a message which has helped to the initial question of the thread.
If it's free tables then you can loop through array adding only tables that you want to the listbox:
=adir(myarray,"*.dbf")
With thisform.list1
  .RowSourceType = 0
  .Clear
  For nLoop=1 to Alen(myarray,1)
    cTablename=upper(alltrim(myarray[nLoop,1]))
    if cTablename=='FOXUSER.DBF
      loop
    endif
    .Additem(cTablename,nLoop)
  Endfor
Endwith
>thank you,
>my small project(via myform) i change excel files to free table, i make som operations, i need to show only those table at my list to make operations i need.
>
>>If you use database container then ADBOBJECTS(myarray,'table') will return database-related table names only.
>>
>>>hi all,
>>>
>>>i need help to let the table FOXUSER.DBF visible=.t. at my list
>>>as
>>>thisform.list1.(FOXUSER.dbf)visible=.t.
>>>
>>>nTablesCount=adir(thisform.aTables,"*.dbf")
>>>thisform.list1.RowSourceType = 5
>>>thisform.list1.RowSource = 'thisform.aTables'
>>>thisform.list1.Requery()
>>>thisform.list1.ListIndex = 1
>>>thisform.list1.refresh
>>>
>>>thanks.
Edward Pikman
Independent Consultant
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform