Re: Do not get data!!!!!

From: Del Murray (Del.Murray_at_N_S_CreditHawk.Net)
Date: 06/09/04 

Date: Wed, 9 Jun 2004 08:39:38 -0400

Peet,
Notice how Kevin keeps steering you back to tADODataset instead of the
tADOQuery ? try to use the dataset not the query while you are converting.
the query is just there for backward compatibility and it does have a few
quirks that dont exist in the dataset object.

Relevant Pages

  • RE: why this wont work!!??
    ... is used when evaluating the WHERE clause in the query to ... eliminate records that aren't included in the requested data set. ... > That's way I have used a subquery to avoid converting data like 'c*' ...
    (microsoft.public.access.queries)
  • Re: HELP with DateAdd statement and SQL
    ... saying SQL that it is having a problem converting the charater set. ... > do datetime comparisons with character data without converting the character ... > the performance of any query that you run agains the table, ... > an example of one of the UTC entries and I'll show you how to do it. ...
    (microsoft.public.scripting.vbscript)
  • Re: Summing values where one is #Error doesnt work
    ... not be converted to a number, and would be ignored by the SUM() aggregate ... I have a normalised_query query based on raw_data and doing 'stuff' ... including converting a text column to a number column. ... conversion fails the column in the query contains #Error. ...
    (microsoft.public.access.queries)
  • Re: Updatable Queries in Conversion Project
    ... dbo_tblBillToInfo from the query. ... >I am converting a Access 2k project and going from a LAN using a total ... > 2k solution to a offsite SQL backend with my Access 2K as a front end. ... I inserted a timestamp field in both tables, ...
    (microsoft.public.access.queries)
  • Re: Convert text string to number in a query
    ... This seems to be progress, it is converting to number, however it is ... rounding. ... I want to run a query that converts the text from the field into a number, ... albeit it was in number format. ...
    (microsoft.public.access.queries)