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.
