MySQL Forums
Forum List  »  Microsoft Access

Advanced Search
New Topic

Re: The decimal field's precision is too small--when making query by access
Posted by: murat sezer
Date: September 19, 2004 02:45AM

THANX FOR YOUR REPLY

BUT I THINK I HAD NOT TOLD CLEARLY.
I MAKE QUERY FROM ACCESS. SO USING % IS NOT A SOLUTION.

FOR EXAMPLE I HAVE 20000 DATA. FROM ADRESS BLANK I QUERY "ISTANBUL TECHNICAL UNIVERSITY" (USING FIND ICON) WITH MATCH "WHOLE FILED". IF THERE IS "ISTANBUL TECHNICAL UNIVERSITY", QUERY FINISHED IN LESS THAN 1 SECOND. IT IS AMAZING.

SIMILARLY FROM ADRESS BLANK, I QUERY "ISTANBUL" WITH MATCH "START OF FILED". IF THERE IS "ISTANBUL TECHNICAL UNIVERSITY", QUERY FINISHED IN LESS THAN 1 SECOND. IT IS AMAZING TOO.

BUT WHEN I QUERY "ISTANBUL" WITH MATCH "ANY PART OF FILED". IF THERE IS "ISTANBUL TECHNICAL UNIVERSITY", QUERY FINISHED IN MIN 20 SECOND. IT CANNOT BE TRUE.

BECAUSE IF I QUERY FROM COMMAND AND PROMPT LIKE
SELECT * FROM TABLE_NAME WHERE ADRESS LIKE 'ISTANBUL%', IT IS SO FAST. SO ACCESS MAKES SOMETHING CONFUSED.

THANKS FOR YOUR REPLIES

Navigate: Previous Message• Next Message
Options: Reply• Quote


Subject
Views
Written By
Posted
The decimal field's precision is too small--when making query by access
8316
murat sezer
September 17, 2004 02:04PM
Re: The decimal field's precision is too small--when making query by access
3353
Saul Montalvo Perales
September 17, 2004 04:42PM
Re: The decimal field's precision is too small--when making query by access
4252
murat sezer
September 19, 2004 02:45AM
Re: The decimal field's precision is too small--when making query by access
3415
Mike Hillyer
September 28, 2004 09:56AM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.