Hello,
can anyone help me with my problem? When I use the same view in runtime it works fine, but when I try it on the web it doesn't save foreign keys from lookup and logs the following message on the server:
[08/01/29@15:35:50.656+0100] P-001136 T-002944 1 WS -- (Procedure: 'saveLookup C:\Progress10\tty\dynamics\ry\app\ryuimsrvrp.r' Line:11866) QUERY-OPEN for query requires a previous QUERY-PREPARE. (7312)
[08/01/29@15:35:50.656+0100] P-001136 T-002944 1 WS -- (Procedure: 'saveLookup C:\Progress10\tty\dynamics\ry\app\ryuimsrvrp.r' Line:11867) Cannot run GET methods on query until it is opened. (7313)
OE version is 10.1B03, date format is European, decimal point is comma(,)
I'd guess that the query-prepare failed. Maybe seeing the query string would be useful for us to help further.
There's not much complexity behind it:
FOR EACH pmm_Investor NO-LOCK,
EACH pmm_Country OF pmm_Investor NO-LOCK INDEXED-REPOSITION
I forgot to mention that the same program works fine in runtime...
The error seems to indicate that the query is not being opened. Is it possible that the statement used to open the query is not being executed (perhaps because of a prior error)? Is this a dynamic or a static query? Is there no WHERE clause? Is the field used to join the two tables by chance a decimal field?
I would consider using the debugger to figure out exactly what is going on. Logging a call with Tech Support might also be a good idea.