Search results for query: *

thats right...you can only unload the non-system-tables. but you don´t have to unload them because when you create a new database to load the unloaded data, all the systables are exists in a empty sqlbase database! Only the user tables, I mean all the table which are created additional to the...

normally you can only do a connection to the database when you have installed it on the new sqlbase server. But do the unload load of the database if you will be luky in the future...there are many basic-changes in the database schema-structure (systables, datatypes, aso. ) when you do the...

Sorry...no way to find it out...the only possibility is to unload the database, with an other user, table by table and load it again in a new database!

so when I understand your problem correct, the backup-process copys only the DBS and LOG-files to the tape, right? if this is try you will got a problem if you have to go back to your backup-version ;-) why you don´t schedule a separat backup process to your database? execute the following...

hello, you will get a return-value from message-boxes which button you have clicked (f.e. a message box with "yes" and "no" button returns IDYES or IDNO when you click the buttons. this return value you can use to handle the validate message!

you are right. the auto-convertion of older databases works fine. but you will get problems when you have stored procedures in the database. the best way is to reorganize the database (unload/load) it after auto-convertion has finished. But sometime I have the problem that the auto-convert...

for a rollforward-command you don´t need a database-connection. in this case you need only a server-connect with set server! Script example: set server xxxx; rollforward *databasename* *Parameter*; thats all. when get luck, you will get your database back!

hmmm... I only know the function "rowcount" but you only can use it to get total number of rows in a table and not on a specified sql statement...

Hello... from a gupta application you can use the function SqlGetResultSetCount( ) to get the number of rows in the result-set of your SQL-Statement. But if you use this function you must acivate the result-set of this specified connection-handle with SqlSetResultSet( TRUE ). Don´t forget to...

okay...only a solution to your second problem ;-) try it like in this simple example: SELECT FIELD1 ||';'|| FIELD2 ||';'|| FIELD3 FROM TESTTABLE now you get your result set separated by ';' I hope this will solve your problem ;-)

yes, its possible that a special index is currupted that you are using for the select...try unload and load...if it still don´t work drop the table an re-create it!

if you are using sqlbase, take a look in the table SYSTABLES. there you can find all existing tables of the databse..

NO CHANCE for us to get the SYSADM-PW

There exists a little application that you can find on the Iceteagroup homepage. The application is called SQLPerformance. All statements will be traced in a overview with some informations like the used indexes, the time and count of execution..nice tool..try it, i think its freeware

Na gut das wir drüber gesprochen haben ;-) Es gibt also doch noch ein paar vereinzelte Gupta Entwickler hier in Deutschland! Grüße!

okay the problem is that there are missing important log-files for this database! try to use the rollforward-command( look into sql-talk-help for the parameters) to kick the log-files that are missing ;-)

the password that "indoaryaan" means is the sqlbase-server-password(needed for f.e. "set server"-command), not the database-password. if you would like to change the password of non-SYSADM-user you can do this with the user sysadm but if you are lose the password for the SYSADM-User there is no...

Which version of SQLBASE did you use? Did you connect as user SYSADM to the database? Did you have tried to run a "check database" command?