FiveTech Software tech support forums

COmo se pregunta si un coloumna es Nula Null
Tengo entendido que en xharbour equivale a Nill

vara := iif(oDatos:Fields("nombre_estilo"):Value = Nill," ",oDatos:Fields("nombre_estilo"):Value)

Esto eata bien


Tengo FWH 8.03 y xharbour 21/August/2008 1.1.0 Rev 6195

If you are using ADO, NULL values are returned as NIL. XBrowse shows NIL values properly. For reports, instead of using Transform(...), please use DATA oRs:Fields("..."):Value PICTURE "999.99" El Problema que Tengo ...

Self contained sample showing handling of NULL values by XBrowse and XBrowse's Report method: #include 'fivewin.ch'#include 'adodef.ch'    // \fwh\include folder#include 'xbrowse.ch'function Main()   local oCn, oRs   local oDlg, oBrw  ...

If you are using ADO, NULL values are returned as NIL.
XBrowse shows NIL values properly.

For reports, instead of using Transform(...), please use DATA oRs:Fields("..."):Value PICTURE "999.99"

Cuando hago una consulta a una base de datos Mysql Usando Sentencias Select, cuando Utilizo Xbrowse o Reporte cuando una de las columnas es Null , me genera un error y me saca del programa. cQte3 := "SELECT A1.codcia,A1.tipdoc,A1.codprov,A1.codprod,A1.consec,A1.simbolo,A1.referencia,A1.largo,"+;  ...

... If our SQL does not support MINUS or EXCEPT, we can always use 'NOT EXISTS' or 'NOT IN' in any SQL. Also we can use 'OUTER JOIN' and filter for NULL values. SELECT *FROM suppliersWHERE not exists (select * from orders Where suppliers.supplier_id = orders.supplier_id); or SELECT EmpNum, ...

... 491: Expression syntax Error E2257 c:\harbour\include\hbdefs.h 523: , expected Error E2451 obj\ALERT.c 87: Undefined symbol 'NULL' Error E2141 obj\ALERT.c 87: Declaration syntax error Error E2190 obj\ALERT.c 87: Unexpected } Error E2190 obj\ALERT.c 87: Unexpected } Error E2040 ...

... pBlock is a codeblock or an array that contains the task. * * nMillisecs is the number of milliseconds after which the task will be executed. * If NULL is passed the default is set to 0 which means that the task * will be executed at every time * * bActive defines if the task is active or not. ...

I've found that if I call BROWSE() with argument bNew := { || add1record() }
where add1recors is :

append blank
fieldput(1, "" )

all work fine.

In other words: if the first field od the new record is not null , there is no error.


best regards
Wzaf

When I run the program below I have different results depending on the version I use xHarbour With xHarbour 1.1.0 appears NULL in two commands " ? cVar " . With xHarbour 1.2.1 a NULL is displayed and then 10. The RELEASE ALL did not erase the contents of the variable! #include ...

Rao, Class TGroup uses a NULL brush for TRANSPARENT mode and the NULL brush does not work fine under all circunstances. Please use this workaround which works better: #include 'fivewin.ch'function Main()   local oWnd, ...

... char *user = "root"; char *password = "cdi"; char *database = "cdibussev"; conn = mysql_init(NULL); /* Connect to database */ if (!mysql_real_connect(conn, server, user, password, database, 0, NULL, 0)) { fprintf(stderr, "%s\n", mysql_error(conn)); ...

... (short int Dispositivo, short int Opcoes, char *Arquivo, short int Extensao, long Timeout, void *CallBack, void *Instancia); static void *pLib = NULL; static fSWEDA_CapturarDispositivo SWEDA_CapturarDispositivo = NULL; /******************************************************************************/ ...

... lpParameters [in] If lpFile specifies an executable file, this parameter is a pointer to a null-terminated string that specifies the parameters to be passed to the application. The format of this string is determined by the verb that is to ...

Antonio,

I get the "oFTP:hFTP is null" message, yet i can access the ftp site through i.e. fine

Regards,

Pete