Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Deleteing a cursor and returning to original table 1

Status
Not open for further replies.

FoxEgg

Programmer
Mar 24, 2002
749
AU
I have been struggling with this forever
I wanted to browse the table... but it was seriously slow

Code:
BROW fields ENTRY_NUM :4 :H= '#', PRINT :P='!' :4 :H= 'Pr', TRANSFER :6 :P='!!!' :H= 'T/F' , percent_fe :5 :H= '%', FILE_NUM :R :28 :P='!!!!!!!!!!!!!!!!!!' :H= 'File Number',  LAST_NAME :R :18 :H= 'Last Name', item_numb :R :10 :H= 'Item #', idx_sequen :5, SERVICE :24 :R  TIMEOUT(15) NOMENU for file_num = fnum && 250299 removed -->> service :10
DO ortho2014

so I tried SELECT
It seems faster... but how do I now clear the SELECT or the Cursor so I can get back to my original table ?


Code:
select ENTRY_NUM, PRINT, TRANSFER, FILE_NUM, LAST_NAME, First_NAME, idx_sequen, service ,recno() as rec ;
   from 1;
   where file_num = "CA910126FQ";
   into cursor mycursor
BROWSE

It is probably very straightforward but I cant seem to nail it.

Thoughts appreciated

FoxEgg

FPD2.6 Legacy Human
Sydney, Australia
 
I have been running my simple little FPD26 code for 30 years (and it has NEVER had a glitch) and I was simply seeking the kind assistance of anyone kind enough to assist for a quick fix to solve one line of code that I had ....

Backwards compatibility is alluring, isn't it? But when you think about it, it's really exactly the same as compatible with backwards. [lipstick]

I've seen a lot of FPD code that will run in VFP just fine. But I've also seen a lot of FPD code that was actually FoxBase code, so it was already in "backwards compatibility" mode even in FPD. If you've been running your code for 30 years you may fall into this category.

VFP is not simply FPD ported to Windows. (That product was called FPW 2.x) VFP is an entirely different product that runs on an object-oriented event-driven model previously unknown to us. It is a different beast. It just is. That they achieved the level of backwards compatibility that we have available is actually surprising.

You're bumping into the problem of deferred maintenance, just as you would if you didn't do routine upkeep with your car or your house. It isn't a nice feeling, but it was inevitable.
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top