MySQL Forums
Forum List  »  Microsoft Access

The decimal field's precision is too small--when making query by access
Posted by: murat sezer
Date: September 17, 2004 02:04PM

HI;
I HAVE MYSQL DATABASE (4.0.20). I LINK MY TABLES TO AN ACCESS 2002 FORM.
MY AIM IS TO QUERY TABLES BY THESE FORMS.
I HAVE INSTALLED MICROSOFT JET 4.0 SP 8 PACKAGE.
WHEN I QUERY WITH MATCH "WHOLE FIELD" (FIND) OR "START OF FIELD" THERE IS NO PROBLEM.
HOWEVER WHEN I QUERY WITH MATCH
"ANY PART OF FIELD" THERE IS NO ANSWER OR THE ANSWER IS SHOWN SO LATE(CAN SHOW ONLY FIRST 300 ANSWER). FOR OTHER DATA
THE POP UP SHOWS "The decimal field's precision is too small"

EXAMPLE
ADRESS ='ISTANBUL TECHNICAL UNIVERSITY'. I WANT TO FIND FROM ADRESS LIST.

1ST QUERY => WHOLE FIELD =>FIND='ISTANBUL TECHNICAL UNIVERSITY' => OK
2ND QUERY => START OF FIELD => FIND='ISTANBUL' => OK
3RD QUERY => ANY PART OF FILED => FIND='ISTANBUL' => PROBLEM

I NEED YOUR ADVICES
THANKS IN ADVANCE.

MURAT SEZER

Options: ReplyQuote


Subject
Views
Written By
Posted
The decimal field's precision is too small--when making query by access
7491
September 17, 2004 02:04PM


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.