duplicating contents of a field

[Barry Kahn]

Ah, and it does very nicely. Thanks all!

bk


On Jan 25, 2008, at 10:04 AM, Rob Campbell wrote:

> In that case, the procedure code Dave and I gave you would work.
>
>
>
> On 1/25/08, Barry Kahn <barryk at caravanbeads.net> wrote:
> The database has five fields and there is data in several of them.  
> I'd like to copy the records in the first field (it's a list of  
> item numbers) and append them to the database without changing  
> anything else.
>
>
> So let's say that I have this:
>
>
> Field One	Field Two
> A	Some data		
> B	Some data
> C	Some data
> D	Some data
> E	Some data
>
>
> And I'd like to just append the A thru E item numbers to the  
> existing list:
>
>
> A	Some data		
> B	Some data
> C	Some data
> D	Some data
> E	Some data
> A
> B
> C
> D
> E
>
>
>
>
> Thanks,
> bk
>
>
>
> On Jan 25, 2008, at 9:51 AM, David Thompson wrote:
>
>> Now we need to know what you mean by not changing
>> the data in the other fields. If the new records
>> don't yet exist, they don't have any data to
>> change. If you mean you want them to be empty in
>> the new records.
>>
>>
>> Local x
>> ArrayBuild x,¶,"",«field 1»+¬
>> OpenFile "+ at x"
>>
>>
>> Dave
>>
>>
>>> What if each line is a different record?
>>>
>>>
>>> Thanks,
>>> bk
>>>
>>>
>>>
>>>
>>>
>>>
>>>> On Jan 25, 2008, at 4:25 AM, Barry Kahn wrote:
>>>>
>>>>
>>>>>  I have a database and would like to duplicate
>>>>> the existing items in one of the fields and
>>>>> have them appended to the same field. Say, for
>>>>> example, field 1 contains:
>>>>>
>>>>>
>>>>> A
>>>>> B
>>>>> C
>>>>> D
>>>>> E
>>>>>
>>>>>
>>>>> I would like a way to duplicate and append to get:
>>>>>
>>>>>
>>>>> A
>>>>> B
>>>>> C
>>>>> D
>>>>> E
>>>>> A
>>>>> B
>>>>> C
>>>>> D
>>>>> E
>>>>>
>>>>>
>>>>> without changing any of the data in any of the
>>>>> other fields. Is there an easy way to do that?
>>
>>
>
> _______________________________________________
> Qna mailing list
> Qna at provue.com
> http://provue.com/mailman/listinfo/qna

Barry Kahn
Caravan Beads, Inc.
915 Forest Ave
Portland ME 04103
800-230-8941
fax: 207-874-2664
www.caravanbeads.net
barryk at caravanbeads.net





-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://provue.com/pipermail/qna/attachments/20080125/0c0bce36/attachment.html