/*********************************************************************
* Copyright (C) 2000 by Progress Software Corporation ("PSC"),       *
* 14 Oak Park, Bedford, MA 01730, and other contributors as listed   *
* below.  All Rights Reserved.                                       *
*                                                                    *
* The Initial Developer of the Original Code is PSC.  The Original   *
* Code is Progress IDE code released to open source December 1, 2000.*
*                                                                    *
* The contents of this file are subject to the Possenet Public       *
* License Version 1.0 (the "License"); you may not use this file     *
* except in compliance with the License.  A copy of the License is   *
* available as of the date of this notice at                         *
* http://www.possenet.org/license.html                               *
*                                                                    *
* Software distributed under the License is distributed on an "AS IS"*
* basis, WITHOUT WARRANTY OF ANY KIND, either express or implied. You*
* should refer to the License for the specific language governing    *
* rights and limitations under the License.                          *
*                                                                    *
* Contributors:                                                      *
*                                                                    *
*********************************************************************/
/*----------------------------------------------------------------------------

File: _gttblid.p

Description:
   This will return the id of a table.  DICTDB must be pointing to the
   correct database.

Input Parameters:
   p_DBID    - recid of the database this table is in. -- REQUIRED
   p_TblName - This is the name of the table you want to get an id for.

Output Parameters:
   p_TblID  - The recid of the _File record.

Author: Warren Bare

Date Created: 06/30/92 
    Modified: 07/10/98 D. McMann Added DBVERSION check and _owner to find
                                 statement for V9.

----------------------------------------------------------------------------*/


Define INPUT  PARAMETER p_DBID      as recid    NO-UNDO.
Define INPUT  PARAMETER p_TblName   as char     NO-UNDO.
Define OUTPUT PARAMETER p_TblID     as recid    NO-UNDO init ?.

IF INTEGER(DBVERSION("DICTDB")) > 8 THEN DO:
  Find dictdb._file WHERE _file._DB-recid = p_DBID 
                      AND _file-name = p_TblName 
                      AND (_Owner = "PUB" OR _Owner = "_FOREIGN")
                      NO-LOCK NO-ERROR.
  if not available _file THEN DO:
    IF NOT CAN-FIND(_db WHERE RECID(_db) = p_dbid) THEN
    MESSAGE SUBSTITUTE("_db record &1 does not exist in Database &2."
       ,p_dbid,ldbname("DICTDB"))
       view-as alert-box error buttons ok.

    MESSAGE SUBSTITUTE("Table &1 is no longer available.",p_TblName)
      view-as alert-box error buttons ok.
    RETURN.
  END.
  else
    p_TblID = RECID(_file).
END.
ELSE DO:
  Find dictdb._file WHERE _file._DB-recid = p_DBID AND
    _file-name = p_TblName NO-LOCK NO-ERROR.
  if not available _file THEN DO:
    /* This should not happen if you pass in a good p_dbid */
    IF NOT CAN-FIND(_db WHERE RECID(_db) = p_dbid) THEN
      MESSAGE SUBSTITUTE("_db record &1 does not exist in Database &2."
          ,p_dbid,ldbname("DICTDB"))
       view-as alert-box error buttons ok.

    MESSAGE SUBSTITUTE("Table &1 is no longer available.",p_TblName)
      view-as alert-box error buttons ok.
    RETURN.
  END.
  else
    p_TblID = RECID(_file).
END.
RETURN.