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.
