I have a fusion table that i need to update base on a certain criteria. Does someone have any suggestions on how to do it.
UPDATE Seminar
SET YearOS = 2013
where seminar ='CollectingData';
Base on Google documentaion
UPDATE <table_id>
SET <column_name> = <value> {, <column_name> = <value> }*
WHERE ROWID = <row_id>
To update values in one or more columns of an existing row in a table, use the following syntax in an HTTP POST request:
have you tried the method outlined here?
http://fmepedia.safe.com/articles/How_To/Using-Feature-Based-Attributes-for-Database-updates
David
Hi David,
I created this model base on yoru suggestion. I can not update the field. Any sugestions. ?
Thanks
what does the FME log say? Does it show any errors or warnings?
Also, I see that you're using mixed case field and/or table names. I recommend you quote them to prevent the SQL parser from assuming all lower or upper case (depending on backend):
UPDATE "Seminar"
SET "YearOS" = 2013
where "Seminar" ='CollectingData';
Remember: double quotes for field and table names, single quotes for string values.
David
