FiveTech Software tech support forums

Rick Lipkin wrote:oRsFac:Fields("permnum"):Value := if(i->permnum = 0, '', i->permnum )

Try

Code: Select all  Expand view

oRsFac:Fields("permnum"):Value   := if(i->permnum = 0, , i->permnum )

EMG

To All YES .. all the fields are marked to accept 'null' .. for some reason on SQL Server the in line if() does not seem to want to accept '' as null ( for me ) .. I have in the mean time used a regular if statement and only append a field if it is ...

Rick: With this sample I have no problem LOCAL nValor    := 10.50// The field "UNI_USU" is VARCHAR(10) NOT NULL TypeoRsUni:Fields("UNI_USU"):Value := IIF(nValor = 0.00,'',nValor)oRsUni:UpDate()  Neither with this an other example I have ...

Rick:

A silly question

Do you have defined the field to accept NULL?

Regards

To All How do I write NULL to a numeric or a nvarchar field on a Sql Server table .. when I do this : oRsFac:Fields("permnum"):Value := if(i->permnum = 0, '', i->permnum ) "permnum" is a nvarchar(255) and i->permnum ...

... PIXEL MDI; TITLE "Sistema ; MENU BuildMenu( ); COLOR "W+/B" ICON oIco DEFINE BRUSH oBrush99 NAME "logo2" // STYLE NULL SET BRUSH OF oWnd:oWNDCLIENT TO oBrush99 . ... .. ACTIVATE WINDOW oWnd

do you try with LOCAL oBrush := TBrush():New("NULL",,,) @ 320, 15 BITMAP oApp:oLogoBmp FILENAME ".\bitmaps\LOGOSYST2.BMP" NOBORDER PIXEL OF oApp():oDlg oApp:oLogoBmp:nClrPane := GetSysColor(3) oApp:oLogoBmp:lTransparent := .t. ...

... := oBrowFont:nHeight + 12 END fieldname is 'podate', declared in Ads 8.5 as: Data Type : date Index : no Minimum Value Maximum Value Default Value Null Valid : yes Failed Validation Message Description Hope this helps, ryugarai

... DBFILTER() returns the filter condition defined in the current work area as a character string. If no FILTER has been SET, DBFILTER() returns a null string ("").  elseif ! Empty( cFilter := ( ::cAlias )->( dbFilter() ) )            bFilter  := &( ...

... // OK . . . . //para desconectar: GPRSRELEASE(hGprs) // No disconecta // But no disconnect why? HB_FUNC (GPRSRELEASE) { HANDLE hCon= NULL; ConnMgrReleaseConnection( ( HANDLE ) hb_parnl( 1 ),2); }

Julio:

No, is BIT type, this is the definition

"PRO_CAN BIT NOT NULL COMMENT 'Cancelado ?'," +;

Regards

... DEFINE FONT oFont NAME "Roman" SIZE 22, 32 DEFINE FONT oFont1 NAME "Roman" SIZE 15, 20 DEFINE BRUSH oBrush STYLE NULL DEFINE WINDOW oWnd TITLE "Wcall2009 Ver. 1.0"; ICON "cd-10.ico" BRUSH oBrush DEFINE BUTTONBAR obar 3D OF oWnd SIZE 37,42 DEFINE ...

hi, When I execute " pdescricao: = oRich: SaveAsRTF () " the following error is occurring: xb_free called with null to pointer DEFINE DIALOG oDlg RESOURCE "SAC170IA" oRich := TRichEdit():Redefine( 103, { || "" }, oDlg ) oRich:lHighLight = .f. ...

... 491: Expression syntax Error E2257 c:\Harbour\INCLUDE\hbdefs.h 523: , expected Error E2451 main.c 21: Undefined symbol 'NULL' Error E2141 main.c 21: Declaration syntax error Error E2190 main.c 21: Unexpected } Error E2190 main.c 21: Unexpected } Error E2040 main.c 21: ...

... ADDR.OWNER_EID = FAC.LOCAL_FACIL_EID " cSQL += "AND ADDR.ADDRESS_TYPE_CODE = 'BUSINESS' " cSQL += "AND ADDR.STOP_DATE IS NULL " cSQL += "AND STANDARDTASKS.GETNAME( FAC.TANK_OWNER_EID,'NO_NUM' )LIKE '"+cFIND+"%'order by owner" I get the first column ...