BearRiver

I figured out what was going on and wanted to let anyone else with this problem know the answer... This error was caused by a date field in the query using a 10 digit date...in other words a "mm/dd/yyyy" date crashes the query, which is why this just started popping up at the end of the year... 9/31/2008 in the query is ok but 10/31/2008 crashes the query. I came up with a workaround for my solution that strips the "20" from the year so the dat is only mm/dd/yy.

Hi I have an .asp site that queries our Filemaker database and it usually runs fine without problems. However about once a day a random user gets the following error ][ODBC FileMaker driver][FileMaker]Query Failed . This error occurs on an INSERT statement on the Set rsInfo = oConn.execute(strSQL). I don't see anything wrong in the code and it works successfully on dozens of instances of the same event each day. Please let me know if you have any ideas or need any more clues. Thank you for your time!

Hi All, I still have this problem where part of the page is not printing in some areas. It happens on all printers in the office for only two users on our network. Two database users have problems printing some reports...the report prints out all of the fields, however one large text field only prints half of the field (horizontally). In other words, it cuts of the text in the middle of each sentence in the field at about 1/2 way in the middle of the page. It is only on one field, the rest of the report prints normally across the whole page. They told me that it happens when they print out the report for the first time & they have not altered the font. I tried replicating the error on my computer/printer, but it did not happen, but I have scanned the misprinted report, please let me know if it would help to see the report. Any ideas? Thanks.

Thanks for your help Vaughan. That was actually the first thing we tried, and did not solve the problem. Any other ideas? Thanks

Hi All, I'm having a printing issue I'm hoping you can help me with. Two database users had a problem today printing a report...the report prints out all of the fields, however one large text field only prints half of the field (horizontally). In other words, it cuts of the text in the middle of each sentence in the field at about 1/2 way in the middle of the page. It is only on one field, the rest of the report prints normally across the whole page. They told me that it happens when they print out the report for the first time & they have not altered the font. I tried replicating the error on my computer/printer, but it did not happen, but I have scanned the misprinted report, please let me know if it would help to see the report. Any ideas? Thanks.