[Xoyo] Table.sort in write-Protected DB

[Ivan Smahin]

On Aug 21, 2013, at 3:27 PM, Karl Grob <karl.grob at hispeed.ch> wrote:

> Hi,
> could it be, that in 5.4 
> 
> Sort( inSet as VSet, s1 as VSortItem,
> s2 as VSortItem = nil,
> s3 as VSortItem = nil,
> s4 as VSortItem = nil ) as VArraySet
> 
> and also corresponding SQL-Statements no longer work in a write-protected Database?
> I get "unknown file" or error -39.
> 
> This would be rather difficult with a write-protected medium.
> 


I've tried following:

- Create new database and
 CREATE TABLE t1 * f1 LONG, f2 STRING );
 INSERT INTO t1 VALUES (10, '10');
 INSERT INTO t1 VALUES (30, '30');
 INSERT INTO t1 VALUES (20, '20');

- quit vStudio and make this db RO via Finder's GetInfo ...
 (RO for creator, group and everyone)

- launch vStudio again and tried
 1. SELECT * FROM t1 ORDER BY f1,f2;
 2. open table editor and sort its columns.
 
Both way - no problems.


1. Could you provide more details about the way how do you make the db RO?
2. -39	eofErr	End of file; no additional data in the format
  So, probably it is not about write protection but some damages - do you diagnose your db?
3. Is there a simple way to reproduce it? Say, in vStudio with sql?


-- 
Best regards,
Ivan Smahin
Senior Software Engineer
Paradigma Software, Inc
Valentina - The Ultra-Fast Database
http://www.valentina-db.com