Subject Re: [IBO] Re: Prepare in IBquery - Help me!!!!
Author Svein Erling Tysvær
Of course you get an error message if you try to update a table without
update/write access!

What do you expect to happen?

Set

At 14:30 21.12.2000 -0000, you wrote:
>Helen,
>there is message:
>
>ISC ERROR CODE:335544352
>
>ISC ERROR MESSAGE:
>no permission for update/write access to table NOMES
>
>STATEMENT:
>TIB_Cursor: "frmWISQL.crEdit"
>
>I'm using the IB_Wisql with Cursor|sql page:
>UPDATE NOMES SET
>ID=:ID,
>NOME=:NOME,
>DATA=:DATA
>WHERE ID=:ID
>
>The user have only grant select in the table NOMES.
>
>
>--- Em IBObjects@egroups.com, Helen Borrie <helebor@w...> escreveu
>> At 12:31 PM 21-12-00 +0000, you wrote:
>> >I try but IB_Query show me the msg "no permission...bla bla"
>> >Help me!!!!
>>
>> Calm down....this message means what it says - you have have no
>permissions
>> for this table.
>>
>> Let's do a bit of even-headed testing here.
>>
>> Get a copy of IB_WISQL.exe from the Downloads page of
>www.ibobjects.com
>>
>> Connect to the database using the SAME username, password and path
>that you
>> used in your application.
>>
>> Copy the SQL from your IB_Query and submit it on the Cursor | SQL
>page of
>> IB_Wisql.
>>
>> Click the Prepare button.
>>
>> If there is no error message, click the blue book button to fetch
>the dataset.
>>
>> Click the 'Last' button to fetch all the rows (this is the >|
>button on the
>> navigation bar).
>>
>>
>> Report back to the list what you see.
>>
>> You might also get some useful information by activating the
>Monitor dialog
>> in IB_WISQL and watching what is going to the server.
>>
>> Helen
>>
>> All for Open and Open for All
>> InterBase Developer Initiative · http://www.interbase2000.org
>> _______________________________________________________
>
>
>
>
>
>