COMPILER vs RUNTIME For each client.

Posted by OctavioOlguin on 12-Sep-2017 16:16

I run a quick and dirty program to update some stuff in my test database,  but didn't noticed I hadn't completed the program, so I ended with something equivalent with this:

for each customer, 
    each order where:
end.

Just to find it compiles, but never run....  so I start thinking what's going on, so I went to Dojo, and found it shows more info about this problems.   It just says:

Killed

Funny.

Posted by Marco Mendoza on 12-Sep-2017 16:36

10.1C

It works fine.

FOR EACH si_mstr,

      EACH po_mstr WHERE :

END.

DISPLAY "FIN".

-----------

FIN

All Replies

Posted by Marco Mendoza on 12-Sep-2017 16:36

10.1C

It works fine.

FOR EACH si_mstr,

      EACH po_mstr WHERE :

END.

DISPLAY "FIN".

-----------

FIN

Posted by Rob Fitzpatrick on 12-Sep-2017 17:12

> but never run...

Do you mean you didn't run it or it wouldn't run?  

This code *will* query those tables, table-scanning customer once and order once per customer.

It looks like someone is bouncing dojo right now:

"SYSTEM ERROR: Can't attach shared memory with segment_id: 0 for sport

There is no server for database sport. (1423)"

...or else you really *did* kill it ;)

Posted by OctavioOlguin on 12-Sep-2017 19:27

I just waited, and in fact, it ran....   just it was a huge query on my db...

the lesson here is that avm and compiler, considered the " WHERE  : "    to be a valid "Where true:" condition...

This thread is closed