Hi there,
I have a timestamp column in SQL Server (via ODBC 3) that I need to set
to the time of data entry.
Using the Timestamper doesn't work. Deleting the attribute from the
output feature type doesn't work. Setting the value to blank doesn't
work. They all give me an error like:
Bulk insert into table 'ciStreetVectors' failed: 'SQL call failed.'
(Vendor Message 1 is: '23000') (Vendor Message 1 is: '[Microsoft][ODBC
SQL Server Driver][SQL Server]Cannot insert a non-null value into a
timestamp column. Use INSERT with a column list or with a default of
NULL for the timestamp column. ** AND ** [Microsoft][ODBC SQL Server
Driver][SQL Server]Statement(s) could not be prepared.')
Since deleting the attribute from the output feature type doesn't appear
to remove it from the bulk insert statement, is there any way to set an
attribute to NULL (not just an empty string) in Workbench?
Thanks,
Jason
--
Jason Birch
Information Technology Office, City of Nanaimo
455 Wallace St., Nanaimo, BC, Canada, V9R 5J6
Phone: 250-755-4460/250 Fax: 250-755-4478
Get the maximum benefit from your FME, FME Objects, or SpatialDirect via our
Professional Services team. Visit www.safe.com/services for details.
Yahoo! Groups Links
<*> To visit your group on the web, go to:
http://groups.yahoo.com/group/fme/
<*> To unsubscribe from this group, send an email to:
[EMAIL PROTECTED]
<*> Your use of Yahoo! Groups is subject to:
http://docs.yahoo.com/info/terms/
