Hi Jeremy,
BIG select statement. :)
How about something like this...
CREATE CURSOR cTemp (cCustId c(10))
INSERT INTO cTemp VALUES("02049")
INSERT INTO cTemp VALUES("01442")
.
.
SELECT "Empty" AS group1,"Empty" AS grouph1, "HHF" AS groupf1...
FROM mastcus WHERE mastcus.ccust IN
(SELECT cTemp.cCustId FROM cTemp)
INTO CURSOR MastRepo
Hope this helps.
>Here is the sqlcmd. This is not a real command, it was only a test to see if Size was going to matter. So here it is:
>
>MASTCUS->CCUST is the customer number. This command would select data from mastcus for the following customers only. The group stuff is a trick we are using to get Crystal Reports to sort our data. All the "Empty" stuff just means that no sort order was picked. This might seem strange, but it is working, and we are getting some neat results from this. The problem we are having now is that someone suggested that users might make a sql command that is too large and would foxpro be able to handle it.
>
>
>Select "Empty" as group1,"Empty" as grouph1,"HHF" as groupf1,"Empty" as group2,"Empty" as grouph2,"HHF" as groupf2,"Empty" as group3,"Empty" as grouph3,"HHF" as groupf3,"Empty" as group4,"Empty" as grouph4,"HHF" as groupf4,"Empty" as group5,"Empty" as grouph5,"HHF" as groupf5,"Empty" as group6,"Empty" as grouph6,"HHF" as groupf6,"Empty" as group7,"Empty" as grouph7,"HHF" as groupf7,"Empty" as group8,"Empty" as grouph8,"HHF" as groupf8,"Empty" as group9,"Empty" as grouph9,"HHF" as groupf9,"Empty" as group10,"Empty" as grouph10,"HHF" as groupf10, * from mastcus where (MASTCUS->CCUST="02049" or MASTCUS->CCUST="01442" or MASTCUS->CCUST="03179" or MASTCUS->CCUST="02473" or MASTCUS->CCUST="03240" or MASTCUS->CCUST="01384" or MASTCUS->CCUST="02389" or MASTCUS->CCUST="02924" or MASTCUS->CCUST="02067" or MASTCUS->CCUST="02185" or MASTCUS->CCUST="02028" or MASTCUS->CCUST="01355" or MASTCUS->CCUST="02445" or MASTCUS->CCUST="04029" or MASTCUS->CCUST="03470" or MASTCUS->CCUST="01365" or
>MASTCUS->CCUST="03050" or MASTCUS->CCUST="01477" or MASTCUS->CCUST="01087" or MASTCUS->CCUST="01562" or MASTCUS->CCUST="03927" or MASTCUS->CCUST="03763" or MASTCUS->CCUST="02476" or MASTCUS->CCUST="02222" or MASTCUS->CCUST="03101" or MASTCUS->CCUST="04002" or MASTCUS->CCUST="03009" or MASTCUS->CCUST="01323" or MASTCUS->CCUST="01726" or MASTCUS->CCUST="01785" or MASTCUS->CCUST="01150" or MASTCUS->CCUST="02488" or MASTCUS->CCUST="03490" or MASTCUS->CCUST="03295" or MASTCUS->CCUST="04022" or MASTCUS->CCUST="03955" or MASTCUS->CCUST="03587" or MASTCUS->CCUST="01078" or MASTCUS->CCUST="03226" or MASTCUS->CCUST="01025" or MASTCUS->CCUST="01980" or MASTCUS->CCUST="01269" or MASTCUS->CCUST="02558" or MASTCUS->CCUST="03155" or MASTCUS->CCUST="01655" or MASTCUS->CCUST="01855" or MASTCUS->CCUST="01228" or MASTCUS->CCUST="01016" or MASTCUS->CCUST="01754" or MASTCUS->CCUST="02415" or MASTCUS->CCUST="03460" or MASTCUS->CCUST="03814" or MASTCUS->CCUST="02011" or MASTCUS->CCUST="01824" or
>MASTCUS->CCUST="02441" or MASTCUS->CCUST="01077" or MASTCUS->CCUST="03571" or MASTCUS->CCUST="01866" or MASTCUS->CCUST="01755" or MASTCUS->CCUST="03479" or MASTCUS->CCUST="03654" or MASTCUS->CCUST="02501" or MASTCUS->CCUST="03540" or MASTCUS->CCUST="03769" or MASTCUS->CCUST="03349" or MASTCUS->CCUST="03649" or MASTCUS->CCUST="01031" or MASTCUS->CCUST="01536" or MASTCUS->CCUST="01153" or MASTCUS->CCUST="01034" or MASTCUS->CCUST="01427" or MASTCUS->CCUST="01186" or MASTCUS->CCUST="03561" or MASTCUS->CCUST="03802" or MASTCUS->CCUST="03481" or MASTCUS->CCUST="01791" or MASTCUS->CCUST="01106" or MASTCUS->CCUST="03821" or MASTCUS->CCUST="01519" or MASTCUS->CCUST="03902" or MASTCUS->CCUST="01400" or MASTCUS->CCUST="01402" or MASTCUS->CCUST="01111" or MASTCUS->CCUST="01501" or MASTCUS->CCUST="03337" or MASTCUS->CCUST="02307" or MASTCUS->CCUST="03304" or MASTCUS->CCUST="03118" or MASTCUS->CCUST="03335" or MASTCUS->CCUST="03770" or MASTCUS->CCUST="02457" or MASTCUS->CCUST="01356" or
>MASTCUS->CCUST="03345" or MASTCUS->CCUST="02176" or MASTCUS->CCUST="02632" or MASTCUS->CCUST="02563" or MASTCUS->CCUST="01233" or MASTCUS->CCUST="02532" or MASTCUS->CCUST="02358" or MASTCUS->CCUST="01138" or MASTCUS->CCUST="01647" or MASTCUS->CCUST="01033" or MASTCUS->CCUST="03183" or MASTCUS->CCUST="01447" or MASTCUS->CCUST="02645" or MASTCUS->CCUST="01415" or MASTCUS->CCUST="03825" or MASTCUS->CCUST="01766" or MASTCUS->CCUST="04008" or MASTCUS->CCUST="04003" or MASTCUS->CCUST="02195" or MASTCUS->CCUST="01093" or MASTCUS->CCUST="01758" or MASTCUS->CCUST="01227" or MASTCUS->CCUST="01243" or MASTCUS->CCUST="02044" or MASTCUS->CCUST="03877" or MASTCUS->CCUST="01392" or MASTCUS->CCUST="01605" or MASTCUS->CCUST="01554" or MASTCUS->CCUST="03026" or MASTCUS->CCUST="01475" or MASTCUS->CCUST="01348" or MASTCUS->CCUST="01115" or MASTCUS->CCUST="01391" or MASTCUS->CCUST="01768" or MASTCUS->CCUST="01960" or MASTCUS->CCUST="02525" or MASTCUS->CCUST="01677" or MASTCUS->CCUST="01132" or
>MASTCUS->CCUST="03543" or MASTCUS->CCUST="01907" or MASTCUS->CCUST="04054" or MASTCUS->CCUST="04004" or MASTCUS->CCUST="01721" or MASTCUS->CCUST="03893" or MASTCUS->CCUST="02737" or MASTCUS->CCUST="03090" or MASTCUS->CCUST="01131" or MASTCUS->CCUST="02443" or MASTCUS->CCUST="04016" or MASTCUS->CCUST="03576" or MASTCUS->CCUST="01332" or MASTCUS->CCUST="01395" or MASTCUS->CCUST="03854" or MASTCUS->CCUST="03079" or MASTCUS->CCUST="01298" or MASTCUS->CCUST="01610" or MASTCUS->CCUST="01619" or MASTCUS->CCUST="01019" or MASTCUS->CCUST="01418" or MASTCUS->CCUST="01886") into cursor mastrepo