Re: Big numbers

Flash Gordon wrote:
James Kuyper wrote:
....
I don't think that's a relevant analogy. Let me suggest one I consider
more relevant. If you were to send me an e-mail asking me to send you
statistics on the annual exports from Peru in 2004, and as part of your
request you specify the layout of the report, complete with column
numbers and the number of significant digits to report, I would consider
that those specifications were part of the request, and that a change to
those specifications would be a change to the request.

Well, you would be wrong. The C statements:
handle = sqlprepare("SELECT A FROM B");
sqlexecute(handle);
contain absolutely NO information about how the value is to be returned.

Then those functions do not, as I understand the term, constitute the
entire query; they only implement part of it. I don't consider the
query to have been completed until the data is in your program in a
form that ordinary C code can work with. I'm not familiar with the
particular routines you're referring to, but a web search for
documentation mentioning those two functions leads me to suspect that
you must use functions like sqsbindcol() or sqlgetdata(), which do
specify the data type to use, before you can get data in a data type
of your choice. I didn't bother investigating closely enough to
determine whether there's a default data type that you can retrieve w/
o specifying what it is; but I would consider specification of any non-
default type, by whatever method, to be part of the query.

....
I disagree from it from the perspective of how SQL is defined in the
ANSI standard for SQL. I suggest you go and read the standard for SQL.
Correct terminology is important in areas other than C.

I agree that it is important. However, for much of this discussion
I've been talking about queries in general, not specifically ANSI SQL
queries.
I don't know how ANSI SQL defines the term; I'm using it a less formal
sense that includes everything that you need to tell the system that
in order for it to deliver the data to you in a form you can directly
use; and if there's any options about what form that is, informing the
system which option you want to select is inherently part of the
information you need to tell it.
.

Relevant Pages

  • Re: Memo in a combo-box
    ... Don't specify a data type field in your query -- and you can't, ... I don't even get the option to use the memo field if I use the wizard to ...
    (microsoft.public.access.forms)
  • Make Table Question
    ... I have a Make Table Query that I use to make an initial table, the data type ... Is there a way in the Original Make Table to specify a Text field length ... larger than the 2 that it is automatically generating? ...
    (microsoft.public.access.queries)
  • Re: Parameter in a crosstab query
    ... For a cross-tab query, the ctiteria must be declared explicitly. ... and paste it from the criteria line, it must match precisely) and specify ... www.pcdatasheet.com "Melinda" wrote in message ... I have tried to set the data type in the> parameter box, but then it displays all four quarters with the specified> quarter's info. ...
    (microsoft.public.access.queries)
  • Re: Why in stdint.h have both least and fast integer types?
    ... There is no point making a data type "fast" if it is to be ... exactly 16 bits and another that behaves as if it has at least 16 bits. ... wouldn't prefer to specify that array as int16_t. ... architecture of the underlying machine (in this case, primary cache size) ...
    (comp.lang.c)
  • Re: Need help converting a Sined field
    ... if you are wanting the DATA TYPE of the resulting colum to be specified, you can use a data conversion function such as ... once the properties window is showing, you can type a format for your number by clicking in the appropriate column and filling the format property (if you choose from the drop-list, you can also specify the Decimal property -- specifying Decimal without Format has no effect). ... Just need a query or a way to convert the sined field into a large interger. ...
    (microsoft.public.access.tablesdbdesign)