Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations Rhinorhino on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  1. edrossi

    Creting 1 million dummy records

    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...
  2. edrossi

    Choosing an id using differnet group by and another field as priority

    Oh sorry, thanks craigsboyd too. This was great.
  3. edrossi

    Choosing an id using differnet group by and another field as priority

    ...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) VALUES ("456 main st"...
  4. edrossi

    Group by and priority

    I am running it now. Will let you know...... Thanks E
  5. edrossi

    Group by and priority

    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...
  6. edrossi

    Group by and priority

    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...
  7. edrossi

    Choosing an id using differnet group by and another field as priority

    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...
  8. edrossi

    PL/SQL to build a unique barcode

    Santa: You rock......... It was perfect.... Ed
  9. edrossi

    PL/SQL to build a unique barcode

    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...
  10. edrossi

    PL/SQL to build a unique barcode

    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
  11. edrossi

    PL/SQL to build a unique barcode

    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...
  12. edrossi

    Using Delphi With Microsoft MapPoint 2002

    Does anyone have any good sources for programming with Delphi using the Microsoft Mappoint Object Model?
  13. edrossi

    Personal Edition

    Can you use file controls with the Personal Edition of delphi. I keep getting a platform error.
  14. edrossi

    Inserting breaks every 200 records

    A table.
  15. edrossi

    Inserting breaks every 200 records

    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
  16. edrossi

    Replacing a String with blnak if it exists in another field

    This is what I am going to try and do, the part I am missing is how to check and see if filed2 exists in field 1
  17. edrossi

    Replacing a String with blnak if it exists in another field

    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
  18. edrossi

    Variable Imaging and Foxpro Mail Merge

    Mike: The signature is in fact a bitmap image.
  19. edrossi

    Variable Imaging and Foxpro Mail Merge

    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?
  20. edrossi

    How To Convert Multiple Tables To Text Files In Batch

    What would the code look like to get the files into an array?

Part and Inventory Search

Back
Top