I've solved this. I was using the Exec method (invoking a select
statement) to obtain ResultSite: the documentation says that this is
therefore read-only i.e. as the run-time error says. So I've changed the
Exec to Edit with the appropriate changes to its parameters. It now
works OK.
I've just not
I would check the permissions on all your database tables. Also check and
make sure the table files are writable.
I know I've seen this kind of error on MySQL DBs when someone copies files
from one machine or user to another.
On Thu, Feb 2, 2012 at 4:01 AM, Shane Powell wrote:
> On 02/02/12 2
On 02/02/12 22:49, John Rose wrote:
> I think that I've narrowed down this problem on the attached Test
> project. The run time error on the starred line below is an error
> message stating "Update database site table record error"& "Error:
> Result is read-only":
> Public Sub ButtonSave_Click()
>
I think that I've narrowed down this problem on the attached Test
project. The run time error on the starred line below is an error
message stating "Update database site table record error" & "Error:
Result is read-only":
Public Sub ButtonSave_Click()
Dim latitude As Float
Inc Application.Busy
I'm using Gambas3.0. I have a database table Site with structure:
CREATE TABLE site(_id Integer Primary Key AutoIncrement, site Text Not
Null, latitude Float, longitude Float, image Blob, description Text,
locality_id Integer, Foreign Key(locality_id) References locality(_id)
On Delete Cascade On U
