DS update multiple rows

classic Classic list List threaded Threaded
3 messages Options
Reply | Threaded
Open this post in threaded view
|

DS update multiple rows

Jolle Carlestam-2
What would be the DS optimal equivalent of this SQL:

UPDATE mytable
SET  this_col = ’A value'
WHERE this_key = ’A key’

Expecting 0 to infinite number of rows to be updated.

HDB
Jolle

#############################################################

This message is sent to you because you are subscribed to
  the mailing list Lasso [hidden email]
Official list archives available at http://www.lassotalk.com
To unsubscribe, E-mail to: <[hidden email]>
Send administrative queries to  <[hidden email]>
Reply | Threaded
Open this post in threaded view
|

Re: DS update multiple rows

Ke Carlton-3
ds->update(::mytable)->set(::some_col = 'value')->where(::some_key = 'a
value')

On Mon, 26 Feb 2018 at 19:35, Jolle Carlestam <[hidden email]> wrote:

> What would be the DS optimal equivalent of this SQL:
>
> UPDATE mytable
> SET  this_col = ’A value'
> WHERE this_key = ’A key’
>
> Expecting 0 to infinite number of rows to be updated.
>
> HDB
> Jolle
>
> #############################################################
>
> This message is sent to you because you are subscribed to
>   the mailing list Lasso [hidden email]
> Official list archives available at http://www.lassotalk.com
> To unsubscribe, E-mail to: <[hidden email]>
> Send administrative queries to  <[hidden email]>

#############################################################

This message is sent to you because you are subscribed to
  the mailing list Lasso [hidden email]
Official list archives available at http://www.lassotalk.com
To unsubscribe, E-mail to: <[hidden email]>
Send administrative queries to  <[hidden email]>
Reply | Threaded
Open this post in threaded view
|

Re: DS update multiple rows

Jolle Carlestam-2
Thanks!

> 26 feb. 2018 kl. 10:53 skrev Ke Carlton <[hidden email]>:
>
> ds->update(::mytable)->set(::some_col = 'value')->where(::some_key = 'a
> value')
>
> On Mon, 26 Feb 2018 at 19:35, Jolle Carlestam <[hidden email]> wrote:
>
>> What would be the DS optimal equivalent of this SQL:
>>
>> UPDATE mytable
>> SET  this_col = ’A value'
>> WHERE this_key = ’A key’
>>
>> Expecting 0 to infinite number of rows to be updated.
>>
>> HDB
>> Jolle
>>


#############################################################

This message is sent to you because you are subscribed to
  the mailing list Lasso [hidden email]
Official list archives available at http://www.lassotalk.com
To unsubscribe, E-mail to: <[hidden email]>
Send administrative queries to  <[hidden email]>