Talk About Network

Google


Register and Login
Nick
Password
Register create new account Sign up is FREE and you can post replies, new topics, bookmark posts and more!
Recover lost password


Data Bases > Pick > D3 ACCESS comma...
Latest [ Topics | Posts ] Archive Post A New Topic Post a Reply
<< Topic < Post Post 1 of 12 Topic 3419 of 3595
Post > Topic >>

D3 ACCESS command

by sh <shamada@[EMAIL PROTECTED] > Mar 25, 2008 at 02:58 PM

I've come across the following need on a number of occasions, and I'm 
wondering if there already exists a D3 command that will do the following:

I get a SAVE-LIST of values from some source

001 10001
002 10015
003 10018
....
100 10526

I now want to SELECT off another file, but the values in the SAVE-LIST 
are not item-ids in the second file, but are values (or multivalues) in 
a field within the second file.

In other words, I want the ACCESS command to morph to

SELECT file WITH field = "10001" "10015" "10018" ... "10526".

So my sequence of commands would be

SELECT file1
SELECT file2 WITH field = any-single-value-within-previous-select-list

I know I can probably get around this by using some sort of REFORMAT 
into a tem****ary file, but that's messy. I'm looking for something 
straightforward.

Does such a command already exist in D3, or do I have to roll my own?
 




 12 Posts in Topic:
D3 ACCESS command
sh <shamada@[EMAIL PRO  2008-03-25 14:58:15 
Re: D3 ACCESS command
Dale <dale_benedict@[E  2008-03-25 12:19:13 
Re: D3 ACCESS command
sh <shamada@[EMAIL PRO  2008-03-25 15:47:58 
Re: D3 ACCESS command
rockingred <willsteve2  2008-03-27 06:35:40 
Re: D3 ACCESS command
Dale <dale_benedict@[E  2008-03-27 08:15:27 
Re: D3 ACCESS command
Dale <dale_benedict@[E  2008-03-27 08:19:05 
Re: D3 ACCESS command
sh <shamada@[EMAIL PRO  2008-03-27 11:39:25 
Re: D3 ACCESS command
Scott Ballinger <scott  2008-03-30 21:19:01 
Re: D3 ACCESS command
Tony Gravagno <address  2008-03-29 17:58:28 
Re: D3 ACCESS command
"Peter McMurray"  2008-03-31 01:29:35 
Re: D3 ACCESS command
sh <shamada@[EMAIL PRO  2008-03-31 10:36:35 
Re: D3 ACCESS command
Tony Gravagno <address  2008-03-31 15:55:17 

Post A Reply:
  Go here to Signup

AddThis Feed Button


About - Advertising - Contact - Frequently Asked Questions - Privacy Policy - Terms of Use - Signup

Contact
tan13V112 Sat Jul 5 18:25:56 CDT 2008.