Query w/ 8 "WHERE" Values
Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance
I have a Query with 8 (eight) WHERE vaiues.
It doesn't ALWAYS work. Sometimes it will
find the record, & other times it won't.
As I analyze it, I found an instance where an "A"
in the table did NOT find the record if "a" was entered
in the unbound textbox as one of the WHERE conditions.
Has anyone encountered a similar situation???
TIA - Bob
.
Relevant Pages
- Re: Data changes when Analyzed with Excel
... don't have too much experience with "Analyze with XL". ... But how about this...what happens when you create an external DB query from ... displaying the results rounded to zero because of formatting? ... shows zero qty in the as of field and zero quantity in the count field, ...
(microsoft.public.access.queries) - RE: Data/Values change when Query Analyzed in Excel
... I have a quantity in a reocrd of zero, when I analyze the data with Excel, it ... Please post the SQL statement for the query. ...
(microsoft.public.access.queries) - Re: Select statement tuning - help required
... When I run the query in SQL Plus, I have observed that the query ... Can some one tell me how do I analyze this and if I have to make a ... I was hoping to see the trace file to obtain an idea why it is running ... Let's try an experiment with a hint to try a different access path to ...
(comp.databases.oracle.server) - Re: Ugh, sluggish query
... >based) Database is oracle 10.1.0.3. ... >While this query is running, I can see no visible bottlenecks in system ... >SQL> show sga ... Try creating an index on bu_date, analyze the table and then see what an explain plan shows for an access method.. ...
(comp.databases.oracle.server) |
|
