Is this proper SQL
Hi Das,
VALUES is part of an insert query.
Proper syntax for updating a single table:
—-
update table_a
set column_in_table_a = new_value
where another_column_in_table_a = some_identifying_value
—-
When you want to join tables your syntax becomes:
—-
update table_a
set column_in_table_a = new_value
from table_b
where foreign_key_in_table_a = primary_key_in_table_b
and another_column_in_table_b = some_identifying_value
—-
Cheers,
Bas
On 2/3/18 8:36 am, Das Goravani wrote:
>
>
> Do istaobj.$execdirect(con(
> ‘UPDATE cust_balowed FROM customers VALUES ‘,iCustRow.cust_balowed))
> Returns #F
>
> I put in the carriage returns only here in the email to make it more clear
> It’s a one liner in my code, an $execdirect
>
> It fails and I can’t figure why.
> _____________________________________________________________
> Manage your list subscriptions at lists.omnis-dev.com
> Start a new message -> mailto:omnisdev-en@lists.omnis-dev.com
—
Kindest Regards,
Bastiaan Olij
e-mail: bastiaan@basenlily.me
web: www.basenlily.me
Skype: Mux213
www.linkedin.com/in/bastiaanolij
_____________________________________________________________
Manage your list subscriptions at lists.omnis-dev.com
Start a new message -> mailto:omnisdev-en@lists.omnis-dev.com