Hbpgsql data null com fieldput
Enviado: 30 Mar 2021 09:38
Caros,
Como gravar data em branco usando a hbpgsql usando o oRow:fieldput?
Como gravar data em branco usando a hbpgsql usando o oRow:fieldput?
Código: Selecionar todos
2017-05-23 22:35 UTC Viktor Szakats (vszakats users.noreply.github.com)
* contrib/hbpgsql/tpostgre.prg
+ add :SetNull( <lSet> ) to TPQServer class
and a param to :Query( <cQuery>, [ <lNull> ] )
TPQQuery class constructor is also extended.
With :SetNull( .T. ) retains NULL information as NIL. Standard
behaviour of hbpgsql library, until now, was to substitute NULL
with blank xBase value - thus :SetNull( .F. ) is the default
setting.
; Merge from Aleksander Czajczyński's fork (with minor cleanups):
https://github.com/alcz/harbour/commit/d5e681f79efd38f937935e07769361a50234db18
Código: Selecionar todos
2015-05-07 22:24 UTC+0200 Aleksander Czajczynski (hb fki.pl)
* src/rdd/dbcmd.c
+ added HB_FieldPut( <n>, <xVal> ) which is like FieldPut(), but
accepts NIL value as 2-nd parameter. FieldPut() ignores NIL and
shouldn't be changed, because of Clipper compatibility
and possible regressions.
* contrib/hbpgsql/tpostgre.prg
+ added :SetNull( <lSet> ) to TPQServer class
and a param to :Query( <cQuery>, [ <lNull> ] )
TPQQuery class constructor is also extended.
With :SetNull( .T. ) retains NULL information as NIL. Standard
behaviour of hbpgsql library, until now, was to substute NULL
as blank xBase value - thus :SetNull( .F. ) is the default setting.Agora basta usar: oRow:FieldPut( <numerodocampo>, ctod('')) que vai funcionar, na verdade qualquer campo que vc passar oRow:FieldPut(<numerodocampo>, nil) vai gravar null no bd.alxsts escreveu:Olá!
E qual é a solução para o problema? Poderia compartilhar, caso a tenha encontrado?