 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
| HomeDiscussion Groups Database Servers DB2InformixIngresMS SQLOraclePervasive.SQLPostgreSQLProgressSybaseDesktop Databases FileMakerFoxProMS AccessParadoxGeneral General DB TopicsDatabase TheoryRelated Topics Java Development.NET DevelopmentVB DevelopmentMore Topics ... |
Database Forum / General DB Topics / General DB Topics / August 2003MS ACCESS97
I AM TRYING TO RUN A A QUERY THAT CONTAINS ALOT OF CALCULATED FIELDS. WHEN I TRY AND RUN THE QUERY, I RECEIVE AND OVERFLOW ERROR THAT IS JUST IN A SMALL WINDOW WITH AND OKAY BOX, AND GIVES NO ADDITIONAL INFORMATION. UNTIL JUST TODAY AFTER ADDING NEW RECORDS INTO THE MAIN TABLE THIS QUERY WORKED PERFECTLY. DOES ANY ONE HAVE ANY IDEA WHAT COULD POSSIBLY BE WRONG? > I AM TRYING TO RUN A A QUERY THAT CONTAINS ALOT OF CALCULATED FIELDS. > WHEN I TRY AND RUN THE QUERY, I RECEIVE AND OVERFLOW ERROR THAT IS > JUST IN A SMALL WINDOW WITH AND OKAY BOX, AND GIVES NO ADDITIONAL > INFORMATION. UNTIL JUST TODAY AFTER ADDING NEW RECORDS INTO THE MAIN > TABLE THIS QUERY WORKED PERFECTLY. DOES ANY ONE HAVE ANY IDEA WHAT > COULD POSSIBLY BE WRONG? Your CAPS key is stuck - please fix the keyboard. Jan M. Nelken > I AM TRYING TO RUN A A QUERY THAT CONTAINS ALOT OF CALCULATED FIELDS. > WHEN I TRY AND RUN THE QUERY, I RECEIVE AND OVERFLOW ERROR THAT IS > JUST IN A SMALL WINDOW WITH AND OKAY BOX, AND GIVES NO ADDITIONAL > INFORMATION. UNTIL JUST TODAY AFTER ADDING NEW RECORDS INTO THE MAIN > TABLE THIS QUERY WORKED PERFECTLY. DOES ANY ONE HAVE ANY IDEA WHAT > COULD POSSIBLY BE WRONG? One or more of the new rows is causing the trouble. I would try to remove "calculated" columns from the query one by one, until the problem disapears. When you know what column that is causing trouble, check max, min, and "close to zero" values for attributes involved in that particular column. BTW, your post is very hard to read, since you only use capital letters. /Lennart -- the above email no longer works due to spam. values'lennart'||CHR(46)||'jonsson'||CHR(64)||'enlight'||CHR(46)||'net' Hi John, What I've also found with most query tools, one of the them as MS ACCESS being the most fundamental one, is that running multiple queries has a problem especially when it has been loaded with a lot of mathematical calculation and hence the reason for the stack overflow message you received. By running each query as its own, does the job perfectly. This concept works for DELETE, UPDATE and INSERT statements predominantly. Hope this helps you. Let me know how you went. Regards Brendon > > I AM TRYING TO RUN A A QUERY THAT CONTAINS ALOT OF CALCULATED FIELDS. > > WHEN I TRY AND RUN THE QUERY, I RECEIVE AND OVERFLOW ERROR THAT IS [quoted text clipped - 13 lines] > > /Lennart |
Reply to this Message |
 Sign In
 Join
 My Latest Posts My Monitored Threads My Blog My Photo Gallery My Profile My Homepage Start New Thread Enable EMail Alerts Rate this Thread
|
©2009 Advenet LLC Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.