Re: Recordset Data Type


"bz" <nospam@xxxxxxxxx> wrote in message
news:ug4M1gLGHHA.1468@xxxxxxxxxxxxxxxxxxxxxxx
Yours is the same as Bob's. I think I get the idea.

val = rs!Rate & "" will return a string.

but what does this particular one do?
val = rs!Name & vbNullString


<snipped>

Please ignore that example. <g>

It is part of a method to manage both a 'string' or a 'number' return
(within a different expression) - but there is no reason to go there and I
should not have suggested it.

[vbNullString is essentially what in C would be a "\0" or "" in VB. A string
with a value of zero. Its primary use is in calling APIs. However, due to
VB's ETC (Evil Type Coercion <g>) it can occasionally be abused to be both a
'string' or a 'number' (zero). Using it to manage 'nulls' is a hack. <g>]

-ralph


.

Relevant Pages

  • REPRESENT revisited
    ... Forth-94 has few floating point display functions [none in the ... If u is greater than zero the character string shall consist ... If u is zero the string shall consist of one digit representing ...
    (comp.lang.forth)
  • Re: Reproducing java calculations in UNIX
    ... quotient goes in x, also a double. ... is greater than zero) only the fractional part of the ... {fraction is 52 zero bits, ... is converted from string to floating point (string ...
    (comp.unix.shell)
  • Re: REPRESENT revisited
    ... >has given rise to implementations that differ in critical ... The required compatibility is 1), but 2) makes it much easier to get ... > If u is zero the string shall consist of one digit representing ... But I think it is a very bad idea if a word that should fill a string ...
    (comp.lang.forth)
  • Re: Allow Zero Length String Property - 2000 vs 2003
    ... Are you the same person who posted the 'Allow Zero Length String in MS ... "Ash" wrote in message ...
    (microsoft.public.access.tablesdbdesign)
  • RE: Macro Question
    ... The string you want Microsoft Excel to search for. ... SearchOrder Optional Variant. ... The settings for LookAt, SearchOrder, MatchCase, and MatchByte are saved ... > include a search for occurrences of zero. ...
    (microsoft.public.excel.programming)
Loading