I need to find a way to create 1 million records in FoxPro, starting with an empty table. The final result will have the same characters in for 1 million rows and 1 column. Here is an example of what needs to be created:
CODE
-------
NMZ
NMZ
NMZ
NMZ
NMZ
NMZ
NMZ
Any help that can be provided...
Thanks mkrausnick.....
But what if I mix it up even further and show two of the same addresses falling into the same decile. If I create this data set:
*!* let's mix them up good so we know the results aren't based on physical record order
INSERT INTO crstemp (address, zip, ID, decile)...
Not meaning to complicate things. In fact I should have included two data sets. So, what if the data set looked more like:
Address Zip ID Decile
123 Main St 76132 1 7
123 Main St 76132 2 6
123 Main St 76132 3 1
321 Davis St...
To all:
Man, I can not figure this out. This is what I am trying to do. Let's say I have a data set of:
Address Zip ID Decile
123 Main St 76132 1 7
123 Main St 76132 2 6
123 Main St 76132 3 1
I am trying to get a result...
To all:
Man, I can not figure this out. This is what I am trying to do. Let's say I have a data set of:
Address Zip ID Decile
123 Main St 76132 1 7
123 Main St 76132 2 6
123 Main St 76132 3 1
I am trying to get a result...
Santa:
1) As random as possible, meaning, it does not have to be randon, what is more important is that it is unique.
2) Because sometimes the digits are more than 7 in length, so we will use alphanumerics to increase the number of different combinations we can use.
Good questions, I hope I...
SantaMufasa:
Absolutely, a sequential-number-generator would be fine, it only has to be random as possible. So, we can use a sequential-number-generator if we order the list by, say, customer number. So, no problem.
Thanks,
ed
I need a little PL/SQL help. I am trying to create a 10 character field that has a unique set of characters in it that will be later turned into a barcode. The methodology I have to use is the following:
The first 3 characters will be hard coded, for example, "CCD"
The remaining 7 characters...
I am trying to insert breaks into a table after every 200 records. So the breaks (#########) should like like the following:
123 Main St Richmond VA 22201
###################
125 Main St Richmond VA 22203
Is there any easy way to accomplish this task?
ER
Here is what i am trying to accomplish
Field1 Field2
123 Main St #150 #150
2235 Main St #134 134 REAR
Results should be:
123 Main St #150 blank
2235 Main St #134 REAR
Any help is appreciated
What is the best way to set up a mail/merge in Microsoft Word using a Foxpro file as the data source and have the signature on a letter vary based upon data in the foxpro file?
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.