Re: String was not recognized as a valid DateTime



I do have one additional problem:

It is now not complaining about the SQL text, but is not returning any
rows, when it should be.
I need to see the final constructed SQL text after the markers have
been substituted for their parameter values.
Is there a way for me to see the final SQL as submitted to the DBMS?

Thanks.

.



Relevant Pages

  • Re: SQL Losing Data
    ... I recently created a new set of tables for the app, ... > are complaining that unsaved data is being lost when they move to a new ... > Is this something with SQL 7 when it's dealing with new tables? ...
    (microsoft.public.sqlserver.odbc)
  • Re: INTERVAL question
    ... Yeah, it is complaining with ERROR 1604: You have an error in your SQL ... How to get the numbers without using subqueries? ...
    (comp.databases)
  • Re: MV and SQL
    ... >> perform enquiries on it using the query language then, again, how the ... > Are you sure that a column in Pick is equivalent to a column in an SQL table ... If you had some bizarre need to do this in a Pick DBMS though, ... > Besides the query language of Pick what other ways do ...
    (comp.databases.theory)
  • Re: MV and SQL
    ... >> perform enquiries on it using the query language then, again, how the ... > Are you sure that a column in Pick is equivalent to a column in an SQL table ... If you had some bizarre need to do this in a Pick DBMS though, ... > Besides the query language of Pick what other ways do ...
    (comp.databases.theory)
  • Re: MV and SQL
    ... >> perform enquiries on it using the query language then, again, how the ... > Are you sure that a column in Pick is equivalent to a column in an SQL table ... If you had some bizarre need to do this in a Pick DBMS though, ... > Besides the query language of Pick what other ways do ...
    (comp.databases.theory)