What if you INSERT as YYYY/mm/dd? If found this works better regardless of database.
-- sent from my iPhone4 -- Beverly Voth -- On May 3, 2011, at 8:27 PM, Wayne Irvine <[email protected]> wrote: > Yes I am using FileMaker 11 (Single user). > > I checked my version of the JDBC drivers and they have indeed been > superseded. I updated to the latest version but still no luck. > > Actual debug lines: > > [Query] [14] INSERT INTO Layout_0 (Start_date) VALUES (03/05/2011) > [Error] [16] [FileMaker][FileMaker JDBC] FQL0013/(1:47): > Incompatible types in assignment. 08007 > [Error] [16] -101 General error during data source operation. > > I have changed the Field type in FileMaker to 'text' to fix the problem > temporarily. > > Wayne > > On 03/05/2011, at 9:36 PM, Dan Stein wrote: > >> There was a bug in the ODC driver that may also be in the JDBC that caused >> an error like this. What does the debug code say the insert statement looks >> like? Are you on FileMaker 11? If so you need the latest Drivers and Server >> update anyway. The bug was with how the driver dealt with whitespace. >> >> Try it with the new drivers but also send us the actual debug so we can see >> what it is trying to insert. >> -- >> Dan Stein MSN CPNP >> FileMaker 7 Certified Developer >> FileMaker 9 Certified Developer >> Digital Software Solutions >> 303 W. Chestnut St >> Souderton PA 18964 >> Land: 215-799-0192 >> Cell: 610-256-2843 >> FMP, WiTango,MSSQL, MySQL,PHP >> [email protected] >> www.dss-db.com >> >> >> Men do not care how nobly they live, but only how long they live, although >> it is within the reach of every man to live nobly, but within no man's power >> to live long. Brian Haig Private Sector >> >> >> >> >> >> >> >> >> On May 3, 2011, at 1:57 AM, Wayne Irvine wrote: >> >>> I have a TAF converted from 5.5 that inserts a date in a FileMaker field. >>> >>> The date is entered automatically by a Javascript widget in the format >>> %d/%m/%Y (todays date is 3/5/2011 for example). >>> >>> Witango's ini file is set to this format: >>> >>> DATEFORMAT:%d/%m/%Y >>> >>> And the field in FileMaker is set to this format too. >>> >>> But the TAF is giving an error: >>> >>> [FileMaker][FileMaker JDBC] FQL0013/(1:47): Incompatible types in >>> assignment. >>> 08007 >>> >>> I have tried everything up to and including hardcoding the date into the >>> insert action. >>> >>> Any ideas? >>> >>> Wayne >>> >>> To unsubscribe from this list, please send an email to [email protected] >>> with "unsubscribe witango-talk" in the body. >> >> >> To unsubscribe from this list, please send an email to [email protected] >> with "unsubscribe witango-talk" in the body. > > > To unsubscribe from this list, please send an email to [email protected] > with "unsubscribe witango-talk" in the body. ---------------------------------------- To unsubscribe from this list, please send an email to [email protected] with "unsubscribe witango-talk" in the body.
