Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  1. johnnyi80

    Number formats in SQL statements

    Thanks a lot for the reply. I used to use the trick you suggested - storing numbers as text, lot in the past, especially in cases when I was using Breieve as a record manager, but this time I would like to be able to communicate to the DB entirely through SQL including: returning calculated...
  2. johnnyi80

    Number formats in SQL statements

    I am trying to update/insert records in a DB, using SQL statements. All numeric formats seem to work fine except for the Scientific (exponential) notations. In an UPDATE statement it raises "type mismatch" error (Example1). I managed to go arround it by using casting (Example2). When using...
  3. johnnyi80

    Passing parameters to an SQL query

    Thanks for the reply! Here are the queries. I have removed some fields for clarity and I have outlined the important areas by "<-----" Also the parameter in ":prmCategory" in Query2 is intended to filter out records. The filtering can also be done in Query1 in the FROM-JOIN-ON statements, but...
  4. johnnyi80

    Passing parameters to an SQL query

    Can any one help me out with my problem please? I am trying to run an SQL query1, which has an INNER JOIN in its FROM statement to another SQL query2. Query2 is using a parameter in its WHERE clause for filtering. When I run Query1 and error comes up: "Parameter not set in query string" I...

Part and Inventory Search

Back
Top