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...
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...
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...
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...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.