General information
Category:
Coding, syntax & commands
Title:
Using variables in SELECT command
Hi all,
Quick question. I'm trying to scan through a bunch of my master tables to extract data for individual agencies. I'm scanning through my agency table to get "x", the current record's agency code, creating a subdir named "x" off of my "c:\mainwork\" directory to store that agency's data, then I scan through all my master tables to create new tables in my new "x" dir which only contain data for agency "x".
I've got variable "x" for the name of a subdir and the code for my current record's agency in my agency table (eg. '00604'). I've got "y" for the current file name of a table I'm trying to copy and create from my tables file (eg. 'contacts').
Now I'm trying to use a SELECT command to extract the data I need for each agency into their own directory. I'm trying the following, but getting errors. Anyone know what I'm doing wrong?
SELECT * FROM &y INTO TABLE c:\mainwork\&x\&y WHERE acode=&x
again, 'y'=my table name, 'x'=agency code/agency directory
MTIA!!
Mandy
Next
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only