Is "_Tbl-Type" really supported in 8.x versions? - Forum - OpenEdge Development - Progress Community

Is "_Tbl-Type" really supported in 8.x versions?

 Forum

Is "_Tbl-Type" really supported in 8.x versions?

This question is not answered

Hi,

I try to compile on Progress 8.2 the script provided in this article https://knowledgebase.progress.com/articles/Article/P105742

but I get the following error message:

** Nom de champ ou de variable inconnu _Tbl-Type. (201)    [Field or variable unknown]
** P:\AppCSPQ\ASUR\Dev\test3.p Ligne 10 incomprise. (196)

However, in this second article https://knowledgebase.progress.com/articles/Article/P128230 , the same attribute is used and it's suppposed to be supported on 8.x versions.

I'm wondering why it doesn't compile.

Thanks

All Replies
  • The first KB article is for 9.x (Progress) and all OpenEdge (10.x and higher) versions.  Progress was renamed to OpenEdge at that point.  Version 8 not supported because that field doesn’t exist in V8 schema.

  • OK but why it's used in the second article which the code shown is supposed to be supported by 8.x versions?

    FOR EACH _File NO-LOCK WHERE _TBL-Type = "T",

       EACH _Index NO-LOCK WHERE _Index._File-Recid = RECID(_File):

           DISPLAY _File-name _Index-name.            

    END.

    Tahnks

  • The 'where_tbl-type = "T"' clause is used to select application tables.

    As an alternative, you could use:

    where _file._file-number > 0 and _file._file-number < 32768

    That should work on any version.

  • KB article has been modified to remove reference to version 8.

  • OK but anyway it seems that a lot of attributes in this script are not supported (unknown) in 8.2:

    ** Expression apres -- "BUFFER  hBufferHandle" incomprehensible. (247)

    ** P:\AppCSPQ\ASUR\Dev\test4.p Ligne 15 incomprise. (198)

    Widget-type non reconnu pour la fonction CREATE widget. (3184)

    ** P:\AppCSPQ\ASUR\Dev\test4.p Ligne 16 incomprise. (196)

    Attribut inconnu SET-BUFFERS utilis‚ dans widget:attribute phrase. (3406)

    ** P:\AppCSPQ\ASUR\Dev\test4.p Ligne 17 incomprise. (196)

    Attribut inconnu QUERY-PREPARE utilis‚ dans widget:attribute phrase. (3406)

    ** P:\AppCSPQ\ASUR\Dev\test4.p Ligne 18 incomprise. (196)

    Attribut inconnu QUERY-OPEN utilis‚ dans widget:attribute phrase. (3406)

    ** P:\AppCSPQ\ASUR\Dev\test4.p Ligne 19 incomprise. (196)

    Attribut inconnu GET-NEXT utilis‚ dans widget:attribute phrase. (3406)

    ** P:\AppCSPQ\ASUR\Dev\test4.p Ligne 23 incomprise. (196)

    Attribut inconnu QUERY-OFF-END utilis‚ dans widget:attribute phrase. (3406)

    ** P:\AppCSPQ\ASUR\Dev\test4.p Ligne 24 incomprise. (198)

    The main goal was to supress all CR/LF in a specific field ('details') of a specific table ('acheteur') by adapting it for this purpose. I'll forget that, unless I can find another similar script working for this version.

    Thanks for your  support.

  • Yes, that is true.  The code does not run under Progress 8.x (which is 20 something years old).