Lazarus
Programming => Databases => Topic started by: FrancoMarco on December 30, 2006, 06:29:40 pm
-
I am using Lazarus 0.9.16 and Interbase 6.0 and components FIBL.
My problem is that when I want Edit, receive a error DataSet is Read Only.
I have a component naming QrFilial type TFIBDataSet.
If write the follow line:
QrFilial.Edit;
I obtain a error 'DataSet is Read Only'.
What happen?
-
I'm sorry! But I I discovered for me.
To allow Alterations the following one must be modified: CacheUpdates=True
AutoCommit=True
AutoStartTransction=True and
UpdateSQL = UPDATE FILIAL
SET
BAIRRO =? BAIRRO,
RAZAOSOCIAL =? RAZAOSOCIAL,
ENDERECO =? ENDERECO,
CIDADE =? CIDADE,
ESTADO =? ESTADO,
TELEPONE =? TELEPONE,
CGC =? CGC,
CEP =? CEP,
Email =? Email
WHERE
CODFILIAL =? OLD_CODFILIAL
Thus it functioned.
Me Desculpem , mas descobri por mim mesmo.
Para permitir Alterações deve-se alterar o seguinte:
CacheUpdates=True
AutoCommit=True
AutoStartTransction=True e
UpdateSQL = UPDATE FILIAL
SET
BAIRRO = ?BAIRRO,
RAZAOSOCIAL = ?RAZAOSOCIAL,
ENDERECO = ?ENDERECO,
CIDADE = ?CIDADE,
ESTADO = ?ESTADO,
TELEFONE =?TELEFONE,
CGC = ?CGC,
CEP = ?CEP,
EMAIL = ?EMAIL
WHERE
CODFILIAL = ?OLD_CODFILIAL
Assim funcionou.