Pessoal, boa tarde.
Gostaria de saber para que serve a built-in do forms chamada Process_Element ???
Seguinte, gostaria de saber, pois meu SYNCHRONIZE não funciona quando acesso um banco remoto (não atualiza a tela), apenas quando acesso um banco local.
Forms [32 Bit] Version 6.0.8.27.0 (Production)
Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 - 64bit Production
With the Partitioning and Data Mining options
Oracle Toolkit Version 6.0.8.25.0 (Production)
PL/SQL Version 8.0.6.3.0 (Production)
Oracle Procedure Builder V6.0.8.21.0 Build #1459 - Production
PL/SQL Editor (c) WinMain Software (www.winmain.com), v1.0 (Production)
Oracle Query Builder 6.0.7.1.0 - Production
Oracle Virtual Graphics System Version 6.0.5.38.0 (Production)
Oracle Tools GUI Utilities Version 6.0.8.25.0 (Production)
Oracle Multimedia Version 6.0.8.25.0 (Production)
Oracle Tools Integration Version 6.0.8.18.0 (Production)
Oracle Tools Common Area Version 6.0.8.18.0
Oracle CORE Version 4.0.6.0.0 - Production
-- Built-in: SYNCHRONIZE
-- Example: Achieve an odometer effect by updating the
-- screen as an items value changes quickly.
-- Without synchronize, the screen is typically
-- only updated when Form Builder completes all trigger
-- execution and comes back for user input.
BEGIN
FOR j IN 1..1000 LOOP
:control.units_processed := j;
SYNCHRONIZE;
Process_Element(j);
END LOOP;
END;
Verifiquei o Bug desta versão (não sei se em outras está corrigido): O que acontece é o seguinte: Quando se usa o SYNCHRONIZE, o mesmo ainda está processando, você sai da tela e volta, ele pára de funcionar.