Wayne,
Double check (in Witango) that the column’s Quote Value = true in the Insert
action.
The statement should read something like:
INSERT INTO Layout_0 (Start_date) VALUES ({ d ‘03/05/2011’})
Also, make sure that you have the column set to Date type in FMP and then open
the database in Witango. This way Witango will learn the correct data type for
the column and use the proper quoting, which in this case is to format it as an
ODBC date as shown above.
Robert
From: Wayne Irvine [mailto:[email protected]]
Sent: Tuesday, May 03, 2011 8:27 PM
To: [email protected]
Subject: Re: Witango-Talk: Date issue (OSX/JDBC/FMP)
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 <http://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.
