Select/export entire records, not just item-ids

[Han Timmers]

I rather unfamiliar with D3, I just know a few 'tricks' to get some data out.

Until now I used 'Copy to (dos' to export entire files, but because of size I'm looking into exporting subsets.

To get all records where the item-id start with '2017', I have tried:

SELECT myitems = '2017]'

SAVE-LIST myitems2017

COPY-LIST myitems2017

TO: (dos:c:\myitems

DELETE-LIST myitems2017

But this outputs only the item-ids, how can I get the complete records?

[Steve Trimble]

Han:

try this:

GET-LIST myitems2017

COPY myitems

TO:(dos:c:\temp

Steve Trimble

Computerized Data Mgmt Inc

(501) 615-8674 office

(501) 772-3450 cell / text

--
You received this message because you are subscribed to
the "Pick and MultiValue Databases" group.
To post, email to: mvd...@googlegroups.com
To unsubscribe, email to: mvdbms+unsubscribe@googlegroups.com
For more options, visit http://groups.google.com/group/mvdbms

[Wols Lists]

Go to PickWiki, and look at a couple of the dump programs there. I know
I've put a couple there, and they respect select lists.

Cheers,
Wol

[christian cottet]

get-list myitems2017

copy myitems

to:(dos:c:\myitems

hopela

[Zumasys Reply]

Han

This will work

    SELECT myitems = “20117]”

   COPY myitems

    TO: (dos:C:\myitems

The COPY-LIST command is saying to copy only the items  ids.  And when doing the select command you have an active select list that will be used by the copy command.

Mitch

[Tony Gravagno]

The correct solution was provided by others.
In addition, note that single quotes should only be used to reference specific item IDs, not in selection criteria. For example:

'2017]' could/will be interpreted as the item ID '2017]'.
"2017]" is certainly interpreted as all items beginning with "2017".

Also note the DOS: host spec is redundant with drive specs. The DOS: spec forces @AM to CRLF, where UNIX: forces @AM to LF. But if you're using C:, D:, E:, etc, those host definitions already include the same spec.
So all that is required is:
To:  (C:/temp

Also:
LIST C:/Temp
ED C:/Temp FOO.txt
Open "C:/Temp" to f.temp
etc.


HTH
T

[chandru murthi]

SELECT myitems = '2017]'

Tony said:      '2017]' could/will be interpreted as the item ID '2017]'.

Never with an "="n front of it.

Chandru