PC Toledo

... ec.fec_ord , "
cSql+= "ec.fec_cap , "
cSql+= "ec.factura , "
cSql+= "dc.id_prod , "
cSql+= "dc.ean , "
cSql+= "ar.descrip1 , "
cSql+= "isnull(dc.cant , 0) as [cantidad], "
cSql+= "isnull(dc.precio, 0.00) as [preciox] , "
cSql+= "dc.lote , "
cSql+= "dc.FECHACAD , "
cSql+= "ec.usuario ...

... Valid dFECFIN >= dFECINI
Read
If LastKey() = 27
Loop
Endif

cSQL := "SELECT "
cSQL += "F.FOLIO AS FACTURA, "
cSQL += "F.FECHA, "
cSQL += "ISNULL(F.VTAEXE,0.00) AS EXENTAS, "
cSQL += "ISNULL(F.VTAGRA,0.00) AS GRAVADAS, "
cSQL += "ISNULL(F.IVA,0.00) AS IVAS, "
cSQL += "( ISNULL(F.VTAEXE,0 ...

... tb01.*
FROM emp AS tb01
LEFT JOIN (
SELECT TOP :offset empno FROM emp ORDER BY empno ASC
) AS tb02
ON tb01.empno = tb02.empno
WHERE ISNULL(tb02.empno)
ORDER BY tb01.empno ASC

ENDTEXT

cSQLReturn := StrTran( cSQL , ":registroPorPagina" , hb_ntos( nRegistroPorPagina ) )
cSQLReturn ...

... tb01.*
FROM emp AS tb01
LEFT JOIN (
SELECT TOP :offset empno FROM emp ORDER BY empno ASC
) AS tb02
ON tb01.empno = tb02.empno
WHERE ISNULL(tb02.empno)
ORDER BY tb01.empno ASC



Se fosse MySQL/PostgreSQL, por exemplo, bastaria o seguinte :

"SELECT * FROM emp LIMIT ...

... 14,22 GET dFECFIN PICT "@D" VALID dFECFIN >= dFECINI
READ
IF LASTKEY() = 27
LOOP
ENDIF



cSQL := "SELECT F.FOLIO AS FACTURA, F.FECHA, ISNULL(F.VTAEXE,0.00) AS EXENTAS, ISNULL(F.VTAGRA,0.00) AS GRAVADAS, ISNULL(F.IVA,0.00) AS IVAS, ( ISNULL(F.VTAEXE,0.00) + ISNULL(F.VTAGRA,0.00) + ISNULL ...

... aResults>

2017-11-14 20:30 UTC+0100 Przemyslaw Czerpak (druzus/at/poczta.onet.pl)
* src/rdd/dbf1.c
! fixed typo in index used inside DBS_ISNULL
! fixed blanking new record for variable length unicode fields (Q:U)
; above fix problems reported by KevinC - many thanks for information
about ...

... Header :", hb_ValToExp( iccprofile )
hb_traceLog( "line 183" )
? iccprofile:SayMembers( " ", .T., .T. )

bmpinfoheader:Reset()
#endif

IF ! HB_ISNULL( cStr := hb_MemoRead( IMAGES_IN + "sample1.jpg" ) )
? "Load JPEG from memory"
im := fi_LoadFromMemory( FIF_JPEG, cStr, JPEG_DEFAULT ...

Olá!

Apenas para enriquecer o tópico:

IsNull é uma função do SQL Server que retorna o valor especificado caso o outro valor contenha NULL.

Exemplos SQL Server:

-- considerando que o campo x seja do tipo alfanumérico
SELECT IsNull( x, 'Campo nulo' )

-- considerando que o campo x seja do tipo ...

Olá ,

Quintas,
str:=" select data , codproce from "+xarquivo+" where not isnull( historico ) and Length( Trim( historico ) ) = 0 ;"
dá esse erro na execução
Error HY000 - [ODBC Firebird Driver][Firebird]Dynamic SQL Error
SQL error code = -104
Token unknown - line 1, column 68
and

fiz assim e deu ...

Talvez parecido com isto?

not isnull( historico ) and Length( Trim( historico ) ) = 0

... dada a campos alfanuméricos. que podem conter o carácter apóstrofe. (Exemplo: "Caixa d'água"). Isto causa erro no SQL, devendo o apóstrofe ser trocado por dois apóstrofes, como em "Caixa d''água".

Edit: as funções equivalentes em outros SGBDs importantes são NVL() no Oracle, IsNull() no SQL Server.

... As Object
LOCAL oErr As Object
LOCAL cSql As Character

Altd()

Try
// Cria novo banco de dados, se não existir
oRs := ExecuteSQL( "SELECT IsNull( db_id('harbour'),0 ) As dbID" )

If ! oRs:Eof()
If oRs:fields("dbID"):value == 0
TEXT INTO cSql
CREATE DATABASE Harbour
ON
( NAME = Harbour ...

... added support for VFP tables with NULLABLE fields
+ added new dbFieldInfo() action to check if given field is NULL, f.e.:
? dbFieldInfo( DBS_ISNULL, FieldPos( <cFieldName> ) )
The above modifications were not tested with real VFP files. I do
not have VFP. VFP users should make some real life ...