Icon View Thread

The following is the text of the current message along with any replies.
Messages 1 to 5 of 5 total
Thread change data in one field on all records
Tue, May 2 2006 10:53 PMPermanent Link

Aaron Taylor
i want to add a tag all / untag all function to my app.

i have a boolean field for tag.

whats the best / fastest way to update all fields at once ?

thanx
Tue, May 2 2006 11:49 PMPermanent Link

"Clive"
Are you trying to add new fields or something?.. You may just meen an update
if so then

Update table
set tag = TRUE

?

"Aaron Taylor" <service@jme.com.au> wrote in message
news:973A89F9-938D-4FC8-9CE2-CD657C216F9B@news.elevatesoft.com...
>i want to add a tag all / untag all function to my app.
>
> i have a boolean field for tag.
>
> whats the best / fastest way to update all fields at once ?
>
> thanx
>

Wed, May 3 2006 12:47 AMPermanent Link

Aaron Taylor
no not add a field

change the data in a field.

"Clive" <dd@dddd.com> wrote:

Are you trying to add new fields or something?.. You may just meen an update
if so then

Update table
set tag = TRUE

?

"Aaron Taylor" <service@jme.com.au> wrote in message
news:973A89F9-938D-4FC8-9CE2-CD657C216F9B@news.elevatesoft.com...
>i want to add a tag all / untag all function to my app.
>
> i have a boolean field for tag.
>
> whats the best / fastest way to update all fields at once ?
>
> thanx
>

Wed, May 3 2006 2:17 AMPermanent Link

"Clive"
Does

Update Table set Tag = TRUE

not do what you want..

Need more information if not.


"Aaron Taylor" <service@jme.com.au> wrote in message
news:2F6F8826-DE04-487B-B991-8C31EEEDE78C@news.elevatesoft.com...
> no not add a field
>
> change the data in a field.
>
> "Clive" <dd@dddd.com> wrote:
>
> Are you trying to add new fields or something?.. You may just meen an
> update
> if so then
>
> Update table
> set tag = TRUE
>
> ?
>
> "Aaron Taylor" <service@jme.com.au> wrote in message
> news:973A89F9-938D-4FC8-9CE2-CD657C216F9B@news.elevatesoft.com...
>>i want to add a tag all / untag all function to my app.
>>
>> i have a boolean field for tag.
>>
>> whats the best / fastest way to update all fields at once ?
>>
>> thanx
>>
>
>

Wed, May 3 2006 2:29 AMPermanent Link

Aaron Taylor
have not tried it yet
but if it will set the tag field of all records to true
then yes..

thanx Clive.
  
"Clive" <dd@dddd.com> wrote:

Does

Update Table set Tag = TRUE

not do what you want..

Need more information if not.


"Aaron Taylor" <service@jme.com.au> wrote in message
news:2F6F8826-DE04-487B-B991-8C31EEEDE78C@news.elevatesoft.com...
> no not add a field
>
> change the data in a field.
>
> "Clive" <dd@dddd.com> wrote:
>
> Are you trying to add new fields or something?.. You may just meen an
> update
> if so then
>
> Update table
> set tag = TRUE
>
> ?
>
> "Aaron Taylor" <service@jme.com.au> wrote in message
> news:973A89F9-938D-4FC8-9CE2-CD657C216F9B@news.elevatesoft.com...
>>i want to add a tag all / untag all function to my app.
>>
>> i have a boolean field for tag.
>>
>> whats the best / fastest way to update all fields at once ?
>>
>> thanx
>>
>
>

Image