Precisely Speaking
May 21, 2012, 07:00:41 PM
Welcome,
Guest
. Please
login
or
register
.
1 Hour
1 Day
1 Week
1 Month
Forever
Login with username, password and session length
News
: So what's news with you? Tell us about it in "Getting To Know You"!
Home
Help
Calendar
Login
Register
Precisely Speaking
>
Application Support
>
Activant/Prelude Support
>
How do you Copy a list of data items
Pages: [
1
]
Go Down
« previous
next »
Print
Author
Topic: How do you Copy a list of data items (Read 517 times)
DonQuixote
Rock Star
Posts: 108
To Dream the Impossible Dream...
How do you Copy a list of data items
«
on:
February 03, 2011, 05:06:04 PM »
I'm not sure if its PRC or Prelude or Unidata or what is causing the problem but I have a select list of CUSTOMER records that I need to copy to a work file.
At real TCL I've tried:
GET-LIST listname
COPY CUSTOMER <cr>
TO: (wrkfile <cr>
nothing is copied. Any ideas?
Logged
Tom Pellitieri
Rock Star
Posts: 171
Tom Pellitieri - Toledo, Ohio
Re: How do you Copy a list of data items
«
Reply #1 on:
February 04, 2011, 06:57:22 AM »
This may seem silly, but are you sure your list is right? Try this:
GET-LIST listname
SELECT CUSTOMER <-- Make certain your list has customer items
COPY CUSTOMER
Alternatively, try copying a specific customer, e.g.:
COPY CUSTOMER 001000COD
--Tom
Logged
DonQuixote
Rock Star
Posts: 108
To Dream the Impossible Dream...
Re: How do you Copy a list of data items
«
Reply #2 on:
February 04, 2011, 10:47:45 AM »
I can appreciate the skepticism since it just seems so simple.
Yes, I'm in real TCL. I get the list and list the file; so the list is real and the items are in the file.
In the back of my little mind I remember Kevin saying that some (what seems) obvious commands are no longer 'real' and are wrapped in some creation of Prelude. And the 'real' commands now have different names. I don't know if this is one of them.
Logged
Tom Pellitieri
Rock Star
Posts: 171
Tom Pellitieri - Toledo, Ohio
Re: How do you Copy a list of data items
«
Reply #3 on:
February 04, 2011, 12:15:07 PM »
You can check your command by examining the VOC entry. If you enter:
AE VOC COPY
you should see a two attribute item. Attribute 1 = "V", Attribute 2 = "COPY". If you have something else, you're not using the real COPY command. It's possible that someone created a BASIC program called COPY and compiled it. Prelude has set the compiler to automatically catalog all programs. You might also check the xxPROCESS (e.g., DEVPROCESS) file for an entry called COPY - there should not be one.
Also, from the SB+ TCL prompt, most UniData commands use Pick style parameters when entered in upper case. The lower case version lets you use UniData style parameters. For example, I could use:
SELECT ORDER.HISTORY WITH INV.DATE = "02/03/11"
select ORDER.HISTORY SAVING UNIQUE CUST.NUM
to get a list of all of the customers who were invoiced on 2/3/11.
Logged
DonQuixote
Rock Star
Posts: 108
To Dream the Impossible Dream...
Re: How do you Copy a list of data items
«
Reply #4 on:
February 04, 2011, 05:18:11 PM »
Thank you. In my case COPY was a PRC created VOC entry, that I would guess should have worked as I expect but is not. The original COPY command is now named OS.COPY.
Logged
Pages: [
1
]
Go Up
Print
« previous
next »
Jump to:
Please select a destination:
-----------------------------
General Category
-----------------------------
=> Getting To Know You
=> Announcements
=> Big Thoughts / Cool Ideas
=> Rants & Raves
-----------------------------
Application Support
-----------------------------
=> Red Leaf
=> Activant/Prelude Support
=> Summit Support
=> Avante Support
=> PRC Support
-----------------------------
Training and Education
-----------------------------
=> Connect!
=> U2 Programming Questions
=> SB+ Programming Questions
=> Web Programming Questions
=> Business Intelligence / MITS
=> PC / Hardware / Miscellaneous Support
Loading...