FiveTech Software tech support forums

Sorry, I don't know how to explain that difference.

EMG

... table is : CountryID CountryName Population IT Italy 58800000 ... ... After oRs:Fields( 'Population' ):Value := nil, the Population is now 0 not NULL. If we link with my modified win32ole.prg or if we write ....Value := VTWrapper( 1, nil ), the updated value is NULL not 0.

oh you already answered in your earlier post

Mr Enrico

>
oRs:Fields( "Test" ):Value = NIL
>
Is the column getting updated to NULL ? or any numeric value like 0 ? What is the column type please ?
Can you clarify ? I have not tested on MSSql serve

This is my test: #define adOpenForwardOnly 0#define adOpenKeyset      1#define adOpenDynamic     2#define adOpenStatic      3#define adLockReadOnly        1#define adLockPessimistic     2#define adLockOptimistic     &nbs...

I try to assign NULL value to a column with NUMBER ( oracle ) data type. When I write oRs:Fields( n ):Value := nil, the column is not updated with NULL as we would want. If there is already a number there ( say 99 ) it remains the ...

It is not only with nchar types. The problem is even with numeric fields. I have just now tested with Oracle. I try to assign NULL value to a column with NUMBER ( oracle ) data type. When I write oRs:Fields( n ):Value := nil, the column is not updated with NULL as we would want. If there ...

If you mean nvarchar then I never used this datatype. I usually use varchar. So yes, this is a difference.

EMG

Enrico

Try your test using nvchar fields .. I inherrited this database and all I got were nvchar and datetime fields ..

Let me know if the datatype is perhaps the common denominator..

Thanks
Rick

All of this still doesn't explain why I don't get the problem...

EMG

>
> Otherwise I added VTWrapper() support specifically to allow explicit control
> over passed arguments.
>
That means we are in the right direction by using VTWrapper( ... )
Still I would like to test my proposed modification extensively and post here. Waiting for some free time.

... desired (and natural) > conversion of NIL (IIRC f.e. a skipped argument). I don't have time to check > so I'd urge you to check how is NULL value supported in vbScript - this may > provide some ideas. > > Otherwise I added VTWrapper() support specifically to allow explicit ...

Rao

YUP .. I won't take credit for the fix .. but I will take credit for my frustration that lead to the fix .. and happy the xHarb people were listning

Rick Lipkin

... the xHarb NG and one of the developers of Win32Ole.prg ... did indeed fix the blank date .. however, up until this time I have not tried to write NULL to any other field. > So you were the cause of the fix for blank dates. :) Let us await the right fix from the xHarbour team. Meanwhile my workaround ...

... .. if I recall .. it just gave an ugly run-time .. I have checked with the latest win32ole.prg. There is no change. If we try to assign nil, where NULL is to be assigned to a parameter, Oracle complains as wrong data type. When NULL is read it is returned as NIL but when NIL is written, it is not ...