Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
How to find indexed fields on the table with code
Message
From
21/10/2003 07:10:25
Cetin Basoz
Engineerica Inc.
Izmir, Turkey
 
General information
Forum:
Visual FoxPro
Category:
Coding, syntax & commands
Miscellaneous
Thread ID:
00840297
Message ID:
00840588
Views:
12
>Hi All,
>i am designing for Database&DBF file maintenance form and using getfile(),adir() for this ( i am thinking globally for use every applicaion). dbf's selection button code like below
>
>
>* cdir,lcselected is public variable on form init
>cdir=getdir()
>
>CREATE CURSOR dosyalar (dosyaadi c(30),boyut c(10),degtar c(10),degzaman c(10),nicelik c(3))
>lcselected=""
>
>gnDbcnumber = ADIR(gaDatabase, '&cdir.'+'*.DBF')  && Create array
>
>CLEAR
>FOR nCount = 1 TO gnDbcnumber  && Loop for number of databases
>SELECT dosyalar
>*   ? gaDatabase(nCount,1)  && Display database names
>lcdosya=gaDatabase(nCount,1)
>lcboyut=gaDatabase(nCount,2)
>lcdtar=gaDatabase(nCount,3)
>lcdzaman=gaDatabase(nCount,4)
>lcnicelik=gaDatabase(nCount,5)
>INSERT INTO dosyalar(dosyaadi,boyut,degtar,degzaman,nicelik) ;
>values(TRANSFORM(lcdosya),TRANSFORM(lcboyut),TRANSFORM(lcdtar),TRANSFORM(lcdzaman),TRANSFORM(lcnicelik))
>ENDFOR
>GO top
>thisform.grid1.RecordSource ="dosyalar"
>thisform.grid1.SetFocus
> thisform.grid1.refresh
>lcselected= cdir + dosyalar.dosyaadi
>
>thisform.Refresh
>thisform.cmdtamamdbf.Enabled =.t.
>
>
>
>
>USE &lcselected EXCLUSIVE
>PACK
>MESSAGEBOX(allt("&lcselected")+" File has been maintenanced",64,"maintenace report")
>
>
>
>my question : when the user select some file i can open and pack its like above code but how can find indexed fields and reindex its in a loop ? TIA


You don't need to find. Reindex doesn't work for individual tags but for all tags. IOW doing that in a loop for each tag would be reindexing all tags n times.
Cetin
Çetin Basöz

The way to Go
Flutter - For mobile, web and desktop.
World's most advanced open source relational database.
.Net for foxheads - Blog (main)
FoxSharp - Blog (mirror)
Welcome to FoxyClasses

LinqPad - C#,VB,F#,SQL,eSQL ... scratchpad
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform