Page 1 of 1

ZUpdateSql 6.6.1 - Lazarus 0.9.21 - UpdateSql Editor

Posted: 15.03.2007, 14:03
by osvaldotcf
Sorry my english.

Environment:
ZeosLib 6.6.1 - Lazarus 0.9.21
The database is Firebird 2.0, server in linux, client in linux. I use debian etch.

In form1, zquery1 + zupdatesql1 + zsequence1 , when i use "UpdateSql Editor" i have an Access Violation when click on generate sql button.

This is generated by Update Sql editor:
'DELETE FROM aluno'
'WHERE'
' ((aluno.AL_CODIGO IS NULL AND :OLD_AL_CODIGO IS NULL) OR (aluno.AL_CODIGO = :OLD_AL_CODIGO))'

'UPDATE aluno SET'
' aluno.AL_CODIGO = :AL_CODIGO,'
' aluno.AL_NOME = :AL_NOME,'
' aluno.AL_DATANASC = :AL_DATANASC,'
' aluno.AL_MATRICULA = :AL_MATRICULA,'
' aluno.AL_NOMEMAE = :AL_NOMEMAE'
'WHERE'
' ((aluno.AL_CODIGO IS NULL AND :OLD_AL_CODIGO IS NULL) OR (aluno.AL_CODIGO = :OLD_AL_CODIGO))'

Why this is generated: "(aluno.AL_CODIGO IS NULL AND :OLD_AL_CODIGO IS NULL)"



Thanks for your great job!