I came back with a new trouble, people!
I have some problems with a code that seems very simple to me.
But it happens sometimes it does not work. Still unable to discover why.
I have source code like this.
[ some instructions ]
RUN Function1.
RUN Function2.
In Function1 there is:
CREATE <tablename>
ASSIGN <tablename>.<fileld> = <value>
[other fields assignments]
VALIDATE <tablename>
In Function2 there is:
PAUSE 3.
RUN <app>.
App is another application that should read from db what i set up on Function1.
Must say that the db where i write is external, on the net. App is also an application that reads from that db.
It happens sometimes App opens whitout showing values correctly.
To debug the problem, i tried opening App on the same data after a while.
So if i open App giving it the parameter after some time, it opens in the correct way.
Now, the point is..
Is it possible that data is written on db after i executed App? Procedures are exectuted ONE AFTER ANOTHER, not in multitasking ( just to say something! ), right?
It may depend on db settings on the remote db server or did i something wrong?
That happens only sometimes, it seems that commit is not done before executing App, but after it runs, when data is not ready yet.
Any clue?
I have some problems with a code that seems very simple to me.
But it happens sometimes it does not work. Still unable to discover why.
I have source code like this.
[ some instructions ]
RUN Function1.
RUN Function2.
In Function1 there is:
CREATE <tablename>
ASSIGN <tablename>.<fileld> = <value>
[other fields assignments]
VALIDATE <tablename>
In Function2 there is:
PAUSE 3.
RUN <app>.
App is another application that should read from db what i set up on Function1.
Must say that the db where i write is external, on the net. App is also an application that reads from that db.
It happens sometimes App opens whitout showing values correctly.
To debug the problem, i tried opening App on the same data after a while.
So if i open App giving it the parameter after some time, it opens in the correct way.
Now, the point is..
Is it possible that data is written on db after i executed App? Procedures are exectuted ONE AFTER ANOTHER, not in multitasking ( just to say something! ), right?
It may depend on db settings on the remote db server or did i something wrong?
That happens only sometimes, it seems that commit is not done before executing App, but after it runs, when data is not ready yet.
Any clue?