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

Posted by francois.caron on 16-Jan-2018 08:19

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

Posted by Brian K. Maher on 16-Jan-2018 08:26
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.
Posted by francois.caron on 16-Jan-2018 08:41

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

Posted by Rob Fitzpatrick on 16-Jan-2018 08:45

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.

Posted by Brian K. Maher on 16-Jan-2018 08:52
KB article has been modified to remove reference to version 8.
Posted by francois.caron on 16-Jan-2018 09:05

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.

Posted by Brian K. Maher on 16-Jan-2018 09:08
Yes, that is true.  The code does not run under Progress 8.x (which is 20 something years old).
This thread is closed