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