Search results for query: *

I installed a workgroup installation with 3 users. (server: Novell file server). It's a Netware network. The first user can login into database. Afterwards it's impossible to login into the database for further users. They get always: Error 116 - The file is owned by another Microkernel engine...

I downloaded the Patch SP4 from pervasive site. Now I can use the SET OWNER function in a SQL statement. But my target is to clearing all owners. And if I try to execute SET OWNER = '' it gives no error. But I cannot e.g. "edit table design" because an owner ('') is existing. How can I...

I tried to execute the following: Set Owner = 'TEST' I got an error message: ODBC Error: SQLSTATE = 37000, Native error code = 0 Syntax Error: Set Owner<< ??? >> = 'TEST' After then I tried this: Set Owner = TEST The same error message: ODBC Error: SQLSTATE = 37000, Native error code = 0...

What is the correct statement fot changing the owner from a table or/and database (SET / CLEAR OWNER ?). I used the manual function in Pervasive tool Maintenance for setting table owner until now. But I don't know how can I use in a SQL statement. Thanks. Holger

I removed the &quot;AND&quot;. Now the statement does work. Its also faster as my original statement. Thanks. Holger

The first one need only 7 sec. And the second one is faster: only 3 sec. Its fine. The last one with JOINs doesn't work. I'm looking for the reason. I didn't work with INNER JOIN, LEFT JOIN etc. before. This are very good advices. I will try out the new possiblities in other statements. Thank...

I want to get a list of amounts converted in EUR. I have amounts in different currencies in database. Thats the reason, why I need the newest currency rate from table &quot;currency_rate&quot; for calculation. Here is the statement: SELECT b.balance_date bdate, a.curr_code, c.spot_rate...

I want to get a list of amounts converted in EUR. I have amounts in different currencies in database. Thats the reason, why I need the newest currency rate from table &quot;currency_rate&quot; for calculation. Here is the statement: SELECT b.balance_date bdate, a.curr_code, c.spot_rate...

In addition to my question (holgermol). I tested some things last day. I did the following for having a better response time: I created logical indexes. I added WHERE conditions which mainly content the created indexes. I increased the response time from 50 sec to 10 sec. (I read some very good...

I created a small database with 5 tables in Pervasive SQL.2000i (max.record number: 300). I wrote a simple SQL statement in SQL Data Manager direct in PCC. I received very fast the result (1 sec). Then I added a sub-select in WHERE condition of SQL statement. The query runs 50 sec. For a...