ZUpdateSql 6.6.1 - Lazarus 0.9.21 - UpdateSql Editor

Forum related to version 6.5.1 (alpha) and 6.6.x (beta) of ZeosLib's DBOs

Moderators: gto, cipto_kh, EgonHugeist

Post Reply
osvaldotcf
Fresh Boarder
Fresh Boarder
Posts: 6
Joined: 09.03.2007, 22:40

ZUpdateSql 6.6.1 - Lazarus 0.9.21 - UpdateSql Editor

Post 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!
Last edited by osvaldotcf on 15.03.2007, 14:42, edited 2 times in total.
Post Reply