Update com 2 tabelas - Firebird

[tato184 0]

Bom dia

 

Estou tentando atualizar um campo no Ibexpert e não estou conseguindo, segue abaixo o comando.

 

 

update lancamentos set lancamentos.pconta='2017' where lancamentos inner join tipos_pgtos on (lancamentos.tipo_pgto=tipos_pgtos.tipo_pgto)

where tipos_pgtos.natureza='201' and lancamentos.tipo='R' and lancamentos.data_emissao between '09/01/2013' and '09/30/2013'
and lancamentos.tipo_origem='S' and filial=48

 

E dá erro.

Alguem pode me ajudar?

Obrigado

[Motta 645]

Qual a mensagem de erro ?

[tato184 0]

Esta

 

Invalid token.

Dynamic SQL Error.

SQL error code = -104.

Token unknown - line 2, column 11.

lancamentos.

[Motta 645]

Putz, no manual tem uma enormidade de erros com 104

 

-------------

-104 336003075 dsql_transitional_numeric Precision 10 to 18 changed from DOUBLE PRECISION in SQL dialect 1 to 64-bit scaled integer in SQL dialect 3. -104 336003077 sql_db_dialect_dtype_unsupport Database SQL dialect @1 does not support reference to @2 datatype. -104 336003087 dsql_invalid_label Label @1 @2 in the current scope. -104 336003088 dsql_datatypes_not_comparable Datatypes @1 are not comparable in expression @2. -104 335544343 invalid_blr Invalid request BLR at offset @1. -104 335544390 syntaxerr BLR syntax error: expected @1 at offset @2, encountered @3. -104 335544425 ctxinuse Context already in use (BLR error). -104 335544426 ctxnotdef Context not defined (BLR error). -104 335544429 badparnum Bad parameter number. -104 335544440 bad_msg_vec -104 335544456 invalid_sdl Invalid slice description language at offset @1. -104 335544570 dsql_command_err Invalid command. -104 335544579 dsql_internal_err Internal error. -104 335544590 dsql_dup_option Option specified more than once. -104 335544591 dsql_tran_err Unknown transaction option. -104 335544592 dsql_invalid_array Invalid array reference. -104 335544608 command_end_err Unexpected end of command. -104 335544612 token_err Token unknown. -104 335544634 dsql_token_unk_err Token unknown- line @1, column @2. -104 335544709 dsql_agg_ref_err Invalid aggregate reference. -104 335544714 invalid_array_id Invalid blob id. -104 335544730 cse_not_supported Client/Server Express not supported in this release. -104 335544743 token_too_long Token size exceeds limit. -104 335544763 invalid_string_constant A string constant is delimited by double quotes. -104 335544764 transitional_date DATE must be changed to TIMESTAMP. -104 335544796 sql_dialect_datatype_unsupport Client SQL dialect @1 does not support reference to @2 data type. -104 335544798 depend_on_uncommitted_rel You created an indirect dependency on uncommitted metadata. You must roll back the current transaction. -104 335544821 dsql_column_pos_err Invalid column position used in the @1 clause. -104 335544822 dsql_agg_where_err Cannot use an aggregate function in a WHERE clause, use HAVING instead. -104 335544823 dsql_agg_group_err Cannot use an aggregate function in a GROUP BY clause. -104 335544824 dsql_agg_column_err Invalid expression in the @1 (not contained in either an aggregate function or the GROUP BY clause). -104 335544825 dsql_agg_having_err Invalid expression in the @1 (neither an aggregate function nor a part of the GROUP BY clause). -104 335544826 dsql_agg_nested_err Nested aggregate functions are not allowed. -104 335544849 malformed_string Malformed string. -104 335544851 command_end_err2 Unexpected end of command - line @1, column @2. -104 336397215 dsql_max_sort_items Cannot sort on more than 255 items. -104 336397216 dsql_max_group_items Cannot group on more than 255 items. -104 336397217 dsql_conflicting_sort_field Cannot include the same field (@1.@2) twice in the ORDER BY clause with conflicting sorting options. -104 336397218 dsql_derived_table_more_columns Column list from derived table @1 has more columns than the number of items in its SELECT statement. -104 336397219 dsql_derived_table_less_columns Column list from derived table @1 has less columns than the number of items in its SELECT statement. -104 336397220 dsql_derived_field_unnamed No column name specified for column number @1 in derived table @2. -104 336397221 dsql_derived_field_dup_name Column @1 was specified multiple times for derived table @2. -104 336397222 dsql_derived_alias_select Internal dsql error: alias type expected by pass1_expand_select_node. -104 336397223 dsql_derived_alias_field Internal dsql error: alias type expected by pass1_field. -104 336397224 dsql_auto_field_bad_pos Internal dsql error: column position out of range in pass1_union_auto_cast. -104 336397225 dsql_cte_wrong_reference Recursive CTE member (@1) can refer itself only in FROM clause. -104 336397226 dsql_cte_cycle CTE '@1' has cyclic dependencies. -104 336397227 dsql_cte_outer_join Recursive member of CTE can't be member of an outer join. -104 336397228 dsql_cte_mult_references Recursive member of CTE can't reference itself more than once. -104 336397229 dsql_cte_not_a_union Recursive CTE (@1) must be a UNION. -104 336397230 dsql_cte_nonrecurs_after_recurs CTE '@1' defined non-recursive member after recursive. -104 336397231 dsql_cte_wrong_clause Recursive member of CTE '@1' has @2 clause. -104 336397232 dsql_cte_union_all Recursive members of CTE (@1) must be linked with another members via UNION ALL. -104 336397233 dsql_cte_miss_nonrecursive Non-recursive member is missing in CTE '@1'. -104 336397234 dsql_cte_nested_with WITH clause can't be nested. -104 336397235 dsql_col_more_than_once_using Column @1 appears more than once in USING clause. -104 336397237 dsql_cte_not_used CTE "@1" is not used in query.

 

------

http://ibexpert.net/ibe/index.php?n=Doc.Firebird21ErrorCodes

[tato184 0]

Me passaram que devo fazer um subselect?!?!

Mesmo assim não consigo...

[Motta 645]

Não sei se este banco suporta update cruzado (com join), se for o caso só via subselect ou procedure com cursor.