Command "DATABASE" is making problems -
09-13-2003
, 02:47 PM
Hallo specialists!
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 with the error
above.
I have no idea, what could be the reason for that.
Does anyone know the solution ?
Thanks
Philipp Walerdorff |