Search results for query: *

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.

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

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

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.

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

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

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

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

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.

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;

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

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.

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