|Related to : Select query returning the string instead of the value|
|Select Query returning multiple records
Select Query returning multiple records
I have a select query that returns multiple records.i have
to store this in a variable and again use that variable in the where
clause of a cursor.
Im getting an exception as my query returns
PS: This might be a simple
thing but im new to oracle.
|Select statement with sub-query not returning any rows
Select statement with sub-query not returning any rows
I have the following SQL statement where I am
trying to find SIGID rows in SIGNATURES that have no matching value in
any fields in the B table. The B tables field holds an integer value
that points to a signature in the SIGNATURES table.
UNIONed all the selects together to give me a list (which it will do
if I run it seperately).
When I run this, I get back 0 rows
found. There are rows that have no matching values and I should be
returning some rows.
All of the fields are integer fields but I
have even tried convert(int,<field>) on all of
|Select query not returning any data
I am trying to select all projects with the keyword
"sett" in them. About a thousand rows with this keyword
exist but why isn't my query returning any data? :confused:
Here's an example of the data "STPT-SETT-NY-EQ Legacy"
Now i want to return all rows with "SETT".
What am i
doing wrong here please :)
WHERE (((projectList.projectName) Like
this doesn't work eith
|Returning Select Records in Query
Hello, I am sure this is quite simple, however I cannot figure it
out. I have a query that shows tblPartNumber and tblAverage. The
average is calculated in the query by taking the total minutes to
assemble the parts, divided by the number of parts completed. What I
am trying to do is run a query that will show me the most efficient
(lowest average), time for each Partnumber. Ideally the query would
show me something like this;
Part # Average
I searched on here and it seemed like
the Top 10 is used, but in my application that
|Select Query not returning the correct results
I'm just having a problem with a select query that is
not returning all the results that match the join conditions for two
The results that are missing when one condition ie field
has not value in both table though the other 2 conditions match. Is
this the way access behaves and if so what is the best way to
structure my query to overcome that
Thanx for the help
|Select query returning the string instead of the value|
Why is strCreditCheck returning the actual query string and not
the result? Of course, this is not working. Please help.
Dim strCreditCheck As String
strCompany_id As Integer
Dim stlinkCriteria As