error: Incorrect database or cursor name format
Posted in 2003
I am running a 4ge-application since years. The database-tables are
situated in some different databases (DATABASE arzt, DATABASE statistik,
DATABASE datenalt ). In order to shift old datas to DATABASE datenalt for
example I use the command "DATABASE " to change from the current database
"arzt" to database "datenalt" and afterwards "DATABASE arzt" to come back
to the first database. This worked fine for years.
Since some time it does not work any more: the following error-message
comes:
Program stopped at "menues2.4gl", line number 548.
SQL statement error number -354.
ISAM error number 0.Incorrect database or cursor name format.
On this line 548 the command "DATABASE arzt" is situated.
But: This error did not occure at every function, that does this command.
There are functions with the same command "DATABASE arzt" and it worked.
First I thought, I made some mistake in the menues2.4gl-file.
But the erormessage comes in functions, which I did not touch in recent
weeks.
So I would like to get some information over this errormessage.
In Google I found only the information that the curser has to have a
certain length and so on... but I have not done any changes with that file,
that contains the command "Database arzt".
with isql the menu-command "Select Database" does work. With the command
"DATABASE datenalt I can change to database datenalt and back to DATABASE
arzt.
To find out the error I put into various 4ge-programms the same test-lines:
DATABASE datenalt
PROMPT "Now in DATABASE datenalt" for answer
DATABASE arzt
PROMPT "Now in DATABASE arzt" for answer
And what happened? Some programs can reach up to the second PROMPT "Now in
DATABASE arzt" and some programs stop before this message wit the error
above.
I have no idea, what could be the reason for that.
Does anyone kno the solution ?
Thanks
Philipp Walerdorff
>
> When creating a new program with these commands it works.
> Only in that first programm this command "DATABASE arzt" is beginning to
> make problems. But not all at once, succesively the problem is rising.
> First only in one function now in all functions.
>
> It seems that there the mistake is not in the sorce-code (4gl). Could it
> be that there is something overrun, to many open cursors or tomething like
> that??????? I am not very keen in INFORMIX basically.
>
> Does anyone have got an Idea wher I can find the mistake?
>
> Thanks
> Philipp