Search results for query: *

Yes, Olaf, that worked perfectly! Dave I didn't get to try yours but I think I know what it's doing there. Thank you again everyone for the quick responses, I appreciate it!

I have a table in foxpro that I need to update for one column (called market). In column "Market", there are entries that all follow the same naming convention: a 2 letter code plus numbers (i.e. AB115) I need to make an adjustment to all these codes so that the 115 says 116 (AB115-->...

Thank you gys, ultimately I found the "stuff" command to be the easiest to work with. I appreciate everyone's feedback and insight. I'm a newbie to FoxPro so it's a little tricky. Slowly but surely i'm getting there.

I have a column (let's call it 'column1') that contains codes that follow this pattern (651xxx) i'm trying to update the first three characters so that all the data will read 652xxx. I've tried using strtran but I can't seem to get the syntax right. ANy help on this would be appreciated

Thanks guys, I appreciate all the input. I'm still having a little difficulty getting it to work. I'm pasting my code below to see if maybe anyone can make sense of everything (p.s. I've changed the names of the dbf files just for the sake of corporate). Bear with me please as I'm a little...

Hi all, We have a program written that opens up a few tables and sets relations to each other so that we can better organize and edit markets in our databases. How can you set the program so that it creates a backup of each database should you ever make a deletion and potentially need to go...