4GL

17 views
Skip to first unread message

jean

unread,
Jun 26, 2008, 2:49:02 AM6/26/08
to source...@googlegroups.com
Hello, sourcefourjs,

Nice to meet you!
I'm very sad to trouble you.

But i have one problem about the genero 4GL, GDC 1.33
version infor:
Genero Application Server - Application Server
Version 1.32.1c
Build 505 - Jun 9 2005 15:56:15
(c) 1989-2005 Four J's Development Tools

This is my test:
Oracle store procedure:

create or replace procedure sp_test1
is
begin
update test1 set t1=99;
end;

4GL code:
database ds
main
define varstring varchar(15)

BEGIN WORK
PREPARE id1 FROM "exec sp_test1"
EXECUTE id1
COMMIT WORK
select t1||"-test" into varstring from test1
CALL FGL_WINMESSAGE("First result of data is...",varstring,"information")

end main


At last , after i execute the code above, i found the data in the
table 'test1' is the old data;
it means that it's false to execute the 4gl code.

How can i do it?
Is there anything wrong in my code above?
Can you help to correct it?
Thank you very much!


We can chat:
MSN:fai...@hotmail.com
Gtalk:jean....@gmail.com
skype:mrsf_jean.luc


======================================================================
jean
mailto:jean....@gmail.com

Reply all
Reply to author
Forward
0 new messages