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!
ZUpdateSql 6.6.1 - Lazarus 0.9.21 - UpdateSql Editor
Moderators: gto, cipto_kh, EgonHugeist
-
- Fresh Boarder
- Posts: 6
- Joined: 09.03.2007, 22:40
ZUpdateSql 6.6.1 - Lazarus 0.9.21 - UpdateSql Editor
Last edited by osvaldotcf on 15.03.2007, 14:42, edited 2 times in total.