New call-to-action
Results 1 to 2 of 2

Thread: Queries

  1. #1
    Frank Cozzi
    Guest

    Default Queries

    How do I delete an existing Query

  2. #2
    "Certified" Alphaholic Stan Mathews's Avatar
    Real Name
    Stan Mathews
    Join Date
    Apr 2000
    Location
    Bowling Green, KY
    Posts
    25,119

    Default RE: Queries

    "index>.drop()
    Syntax:
    "Index>.drop()
    Description:
    Deletes the index, or query list, referenced by the object pointer ("Index>).
    If "Index> references an index tag, the index is marked as deleted in the index
    file.
    If "Index> references a query list, the corresponding query list file ($$*.MPX)
    is deleted from disk.
    Dropping an index from an index file does not reduce the size of the index file
    (tablename.CDX). To compact the size of the index file, you must either rebuild
    the entire index file in Xbasic (using the Table.index_create_begin(),
    Table.index_add() and .index_create_end() methods), or interactively,
    by right clicking on a table in the Control Panel and selecting the Define Indexes
    command.
    Example:
    'This script drops the LASTNAME index.
    '----------------------------------------------------------------
    tbl = table.current()
    indx = tbl.index_get("LASTNAME")
    indx.drop()

    I assume you were not asking about deleting a saved operation query.

Similar Threads

  1. SQL Queries
    By Sonia Sidhwaney in forum Web Application Server v6
    Replies: 6
    Last Post: 07-15-2005, 05:44 AM
  2. queries
    By Mike Finnerty in forum Alpha Five Version 5
    Replies: 1
    Last Post: 07-18-2003, 01:07 PM
  3. Migrating Queries
    By William R Schone in forum Alpha Five Version 5
    Replies: 1
    Last Post: 07-03-2003, 04:50 AM
  4. Queries
    By John Gagnon in forum Alpha Five Version 4
    Replies: 8
    Last Post: 03-04-2002, 01:11 AM
  5. Help with queries
    By Jamin Dunivan in forum Alpha Five Version 4
    Replies: 8
    Last Post: 04-24-2001, 05:26 PM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •