|
Home > Archive > FoxPro database connector > March 2006 > indexing
You are viewing an archived Text-only version of the thread.
To view this thread in it's original format and/or if you want to reply to
this thread please [click here]
|
|
|
| hi there
Select * from table1 into cursor cc
is there a way to transfer the index of table1 to cc.
actually I can create cc with create cursor CC1
and than
scan
insert into CC1 (fi,f2) values(cc.f1,f2)
endscan
but it takes time ro load all the data to the cursor i want make it fast.
because i use UNION ALL and combine to table
thanks!!!!
iso
| |
| Cindy Winegarden 2006-03-06, 7:31 pm |
| Hi Iso,
I'm not sure what you mean when you describe what you're doing with the
cursor after you've added the data, and in particular, why you need indexes,
so I don't know whether a table would work for you, but if it will you can
use:
Select Table1
Copy Structure To Table2 With CDX
Insert Into Table2 Select * From Table1....
--
Cindy Winegarden MCSD, Microsoft Visual FoxPro MVP
cindy_winegarden@msn
.com www.cindywinegarden.com
"iso" < ismailozyigit@hotmai
l.com> wrote in message
news:eWYwOdKOGHA.2320@TK2MSFTNGP11.phx.gbl...
> hi there
> Select * from table1 into cursor cc
>
>
> is there a way to transfer the index of table1 to cc.
> actually I can create cc with create cursor CC1
> and than
> scan
> insert into CC1 (fi,f2) values(cc.f1,f2)
> endscan
> but it takes time ro load all the data to the cursor i want make it fast.
> because i use UNION ALL and combine to table
>
> thanks!!!!
> iso
>
| |
|
| hi
because i use cursor for grid recorsource. then when i click the grid Column
i sort the column
grid1.column1.click()
set order to cursor.filed1
so for this purppse i nedd indexed cursor. As I said one way create cursor
with index and than put the dat into the indexed cursor with scan...
endscan
but it takes time. I need fast.
tahnks
iso
"Cindy Winegarden" < cindy_winegarden@msn
.com> wrote in message
news:ezNAksKOGHA.2472@TK2MSFTNGP11.phx.gbl...
> Hi Iso,
>
> I'm not sure what you mean when you describe what you're doing with the
> cursor after you've added the data, and in particular, why you need
> indexes, so I don't know whether a table would work for you, but if it
> will you can use:
>
> Select Table1
> Copy Structure To Table2 With CDX
>
> Insert Into Table2 Select * From Table1....
>
> --
> Cindy Winegarden MCSD, Microsoft Visual FoxPro MVP
> cindy_winegarden@msn
.com www.cindywinegarden.com
>
>
> "iso" < ismailozyigit@hotmai
l.com> wrote in message
> news:eWYwOdKOGHA.2320@TK2MSFTNGP11.phx.gbl...
>
>
| |
| Usenet 2006-03-06, 7:31 pm |
| I've done this, the only way I've found is to create the indices that
I want.
Ideally (?) the crsor you create shouldn't be big, and then the index
creation is very fast.
Mark Stanton
One small step for mankind...
| |
|
| actually even I didi this loading the data to crs is takes time 13 second.
but i want faster.
fineally instead of combining to table i rduce to one and I used
use v:\myTable1 in 0 alias myCursor.
thanks everybody
iso
"Usenet" <Mark@dont.spamme.invalid> wrote in message
news:VA.00001a11.28189cfd@vowleyfarm.co.uk...
> I've done this, the only way I've found is to create the indices that
> I want.
>
> Ideally (?) the crsor you create shouldn't be big, and then the index
> creation is very fast.
>
> Mark Stanton
> One small step for mankind...
>
>
|
|
|
|
|