dbTalk Databases Forums  

Command "DATABASE" is making problems

comp.databases.informix comp.databases.informix


Discuss Command "DATABASE" is making problems in the comp.databases.informix forum.



Reply
 
Thread Tools Display Modes
  #1  
Old   
Philipp Walderdorff
 
Posts: n/a

Default 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



Reply With Quote
Reply




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off



Powered by vBulletin Version 3.5.3
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.