Get more info about an IP address or domain name, such as organization, abuse contacts and geolocation.
One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.
ODBC Query to MSAccess
Hi there,
I stuck with this problem,
Im using ODBC to extract data from MSAccess Tables.
All works fine when querying for all data from the table:
SELECT * FROM Person
But I want to be able to extract only the records with its DOB field within the current month.
Ive used the "SELECT * FROM PERSON WHERE EXTRACT(MONTH FROM DOB) = variable month" statement on Paradox tables and it works fine
Is there an equivelent statement to use in querying MSAccess Tables to only retreive record that are relevant to the current or selected month.
Thankyou
James
I stuck with this problem,
Im using ODBC to extract data from MSAccess Tables.
All works fine when querying for all data from the table:
SELECT * FROM Person
But I want to be able to extract only the records with its DOB field within the current month.
Ive used the "SELECT * FROM PERSON WHERE EXTRACT(MONTH FROM DOB) = variable month" statement on Paradox tables and it works fine
Is there an equivelent statement to use in querying MSAccess Tables to only retreive record that are relevant to the current or selected month.
Thankyou
James
Asked:
2
1 Solution
hi hulsej,
my answer is just not complete
the delphicode should be:
query1.close;
query1.clear;
query1.sql.add('select * from PERSON where month(DOB) = '+IntToStr(MonatVar);
try
query1.open;
except
{errorhandling}
end;
try it
meikl
my answer is just not complete
the delphicode should be:
query1.close;
query1.clear;
query1.sql.add('select * from PERSON where month(DOB) = '+IntToStr(MonatVar);
try
query1.open;
except
{errorhandling}
end;
try it
meikl
Thankyou this statement worked prefectly.
I want to incorperate the days as well. (what im trying to do is assess whether it is someones birthday with in the next three days)
Ive tried a few different approaches with no succsess (this is my first crack at SQL stuff).
what do I need to do in order to query on the month and the next three days in the one statement.
Thanks again
Later
Jay
I want to incorperate the days as well. (what im trying to do is assess whether it is someones birthday with in the next three days)
Ive tried a few different approaches with no succsess (this is my first crack at SQL stuff).
what do I need to do in order to query on the month and the next three days in the one statement.
Thanks again
Later
Jay
Question has a verified solution.
Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.
Have a better answer? Share it in a comment.
Join & Write a Comment Already a member? Login.
Featured Post
Tackle projects and never again get stuck behind a technical roadblock.
Join Now
the sql statement:
select * from PERSON where month(DOB) = MonatVar
I Think DOB is a Datefield
Manotvar is IntegerTyp holds 1 to 12
meikl