Recent content by Chemi

Oh dear! you are right. The error was in the very next line. It seems AVM takes the line after THEN as the same line as IF line. /* line 1 */ IF expression THEN /* line 2 */ run something. Line 2 is indeed line 1 to AVM. Thank you Casper. Regards. - José Miguel Giménez.

Hello all. I'm trying to compare a file name with a literal string, but i obtain error 223 (Incompatible data types in expression or assignment). This is my code: DEFINE VARIABLE cRuta AS CHARACTER LABEL "Introduce ruta completa donde se encuentran los ficheros ERP" FORMAT "X(100)"...

Hello. I think my explanation was a bit confusing, when I wrote "table" I was meaning a table name, not the reserved word table. I'll rewrite it to make more clear: SELECT COUNT(*) FROM table_name a, table_name b WHERE a.field1 = 1 AND b.field1 = 2 AND a.field2 = b.field2...

Hello all. I am wondering if it is possible to qualify tables in a OpenEdge query using FOR EACH. For example, I have this code in SQL: SELECT COUNT(*) FROM table a, table b WHERE a.field1 = 1 AND b.field1 = 2 AND a.field2 = b.field2. Is it possible to write it in OpenEdge...

Hello. Thank you very much. I'll try your changes. I need the BREAK statement to show de number of DEVO_IMPA records related with each SOCIOS record. Regards. - José Miguel Gimenez

Usage of BREAK BY and OUTER-JOIN Hello all. I am very newbie with Progress and OpenEdge, still learning via documentation. I come from Oracle. Firstly, many thanks to the community of ProgressTalk, this forum has saved my life meny times. I have a problem using BREAK BY and OUTER-JOIN in...