Re: Cursor Problem

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

From: Cindy Winegarden (cindy_winegarden_at_msn.com)
Date: 01/24/05 

Date: Mon, 24 Jan 2005 18:20:26 -0500

Hi Qaiser Me,

By "cursor" I assume you're referring to a permanent table and not a
temporary cursor. In order to pack a table you need exclusive use of the
table.

When you say that your grid is out of order, what do you mean? If I pack a
table that has an index order set then the order is preserved in the packed
table. Are you perhaps using record numbers as primary keys and when
records are removed the numbers don't fill in the gaps?

Why do you feel you need to pack the tables? Unless you've got large numbers
of deleted records in large tables, why not just leave the deleted records
in the file? 

-- 
Cindy Winegarden  MCSD, Microsoft Visual FoxPro MVP
cindy_winegarden@msn.com  www.cindywinegarden.com
"QaiserMehmood" <qaiserme@fastmail.fm> wrote in message 
news:822BF8E7-EC83-4B3A-883D-FB6623FF9CE3@microsoft.com...
> Hi
> Qaiser here
> Sir my first question is
> How to Permanently delete record in cusor i apply pack command on cursor 
> but
> its not work .
> second question : - Sir when i used pack command on table the grid that 
> are
> associated with that table become out of order sir how i solve this 
> problem
>
> Waiting for you goood reply
> -- 
> Qaiser Me

Relevant Pages

  • Re: PACK und Cursor
    ... Da ein pack sowieso nix anderes macht, ... USE DBFIN 0 AGAIN ALIAS Tabelle1 ... Und wenn Du das mit Pack hinkriegen willst, ... Da der Cursor ...
    (microsoft.public.de.fox)
  • Another question - about "scale"
    ... pack .sc ... that the command will be executed immediately after ... cursor. ... Is it normal behaviour of "scale"? ...
    (comp.lang.tcl)
  • Re: Where is EDWARD YOUNAN
    ... And you sir will enlighten me, ... ever took LifeMirage's advice knows yet that he was a fraud; ... can't just pack up and move on just yet. ...
    (rec.drugs.smart)
  • Re: One-Shots Redux
    ... Permanent is permanent, it ... after rolling to hit, ... You happen to have a spare meal for 2 people in your pack. ... Jim or Sarah Davies, but probably Jim ...
    (rec.games.frp.dnd)
  • Re: OT - asian shopkeepers - new tactic
    ... top of the goods so you have to pack the bag yourself is bad ... it means that you're free to pack the stuff the way you ... the 'sir' this and 'sir' ...
    (uk.local.glasgow)