Ivan Prenosil wrote:

>> Docs have two examples and one is wrong. Unfortunatelly, you picked
>>up wrong one.
>>
>>
>>
>>>isc_tpb_protected, isc_tpb_lock_read, "COUNTRY",
>>>isc_tpb_protected, isc_tpb_lock_write, "EMPLOYEE"};
>>>
>>>Any idea what the correct TPB format is ?
>>>
>>>
>>...isc_tpb_lock_write, 8, 'E','M','P','L','O','Y','E','E'...
>>
>> Here "8" is length of "EMPLOYEE".
>>
>>
>
>And afaik the order of parameters is fixed, and should be
>
> isc_tpb_lock_write, 8, 'E','M','P','L','O','Y','E','E', isc_tpb_protected
>
>Ivan
>
>
>

Guys,

What about the WITH LOCK clause of a select statement ?

I had never used it, neither think I will need it in the near future,
but how does it differ from the transaction parameter ?

see you !

--
Alexandre Benson Smith
Development
THOR Software e Comercial Ltda
Santo Andre - Sao Paulo - Brazil
www.thorsoftware.com.br