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 derfloh 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. thepastor

    TSQL Help Please On Update of Tables

    Awesome, Thanks so much George. This has been a great help. And a huge time saver. Not ugly to me, you should see some of the garbage I write. I'm a foxpro prorammer being forced into T-SQL so I need all the help I can get. Thanks again.
  2. thepastor

    TSQL Help Please On Update of Tables

    Wow, this is a great start. And I sure do thank you. This is a process I run on different tables 9 or 10 times a day every day. It's always the same so the only thing that ever changes is the table names. I'd love to be able to pass the name for table1 and table2 as parameters and never...
  3. thepastor

    TSQL Help Please On Update of Tables

    I need to update code1 and code2 in table2 from table1. Code1 and Code2 of table2 must receive the values in table one according to the counts field for example -- The first record of table1 tells me that the first 5 records of table2 that have a matchfld of "fname1" - update code1 with "ABCD"...
  4. thepastor

    Transaction Data Consolidate

    Perfect Olaf. Thank you so much. I had to do tweak or two to take care of same date issues but this saved a tremendous about amount of time and frustration. Thanks to all you folks who helped it's all useful.
  5. thepastor

    Transaction Data Consolidate

    Nope, it can't find mt.tamt or mx.tamt and just for kicks I changed that to mt.mindate and mx.maxdate just to see what happens and it returned a very small subset of what it should and the dates min and max for each record were equal. It needs to return one occurance of each ID and the oldest...
  6. thepastor

    Transaction Data Consolidate

    This is the direction I was thinking Mike, I assume that mt, mint and mx are reitterations of the same table?
  7. thepastor

    Transaction Data Consolidate

    Dan Freeman is close but not there. Here is a small example of data I'm talking about. ID Tdate Tamt 12345 19990101 100.00 12345 20050101 50.00 12345 20070101 125.00 12345 20091010 10.00 11222 20010101 200.00 11222 20020101...
  8. thepastor

    Transaction Data Consolidate

    Table with three fields id transdate transamt Multiple transaction records with same ID and contribution date and countribution amt Need to place Unique ID's in one record and supply the following unique id's, oldest date, newest date, oldest amt, newest amt, transaction count...
  9. thepastor

    tables from arrays

    Thanks folks, the problem wasn't my code after all. The problem was an empty element in the array causing an error in the creation of the table.
  10. thepastor

    tables from arrays

    I have an array called "fldlst" created by afields() and I want to create a new table using that array. Can someone please give me the proper code for that? Thanks;
  11. thepastor

    Set Fox 9 to output Fox 2 Compatible Tables

    Thank you guys for all your help. I really wish this was an option they would have put in.
  12. thepastor

    Set Fox 9 to output Fox 2 Compatible Tables

    Actually, what I'm looking for is a setting in Fox 9 to make it automatically create foxpro 2.x tables whenever you create a new table.
  13. thepastor

    Set Fox 9 to output Fox 2 Compatible Tables

    I really need fox 9 to output fox 2 tables. Is it possible to set something in Fox 9 so this happens automatically?

Part and Inventory Search

Back
Top