Database read-only mode?

[RaspDev]

I've successfully used DbCreateFN to create and reopen a database but cannot see how to make it open in read-only mode. Is there a way to do this?

[Malkom]

I've successfully used DbCreateFN to create and reopen a database but cannot see how to make it open in read-only mode. Is there a way to do this?

Yes there is. If the database already exists then use the DbOpenFN function:-

DbOpenFN(path,mode)    - where mode = 0 for read only and 1 for read/write

eg

Code: [Select]

Local res

@ -- read only --
Put DbOpenFN(filepath,0) into res
if res=1 then
   @ -- db is open in read only mode
    ...
    ....
endif

[RaspDev]

thank you.