Are your eeps custom code (therefore internal to the form), or do you have external eeps? If they are internal to the form, Bill's method gets those too. First you do a "browse all from sys_forms3 where sys_data contains 'ColumnName' ", and then you double-click on the sys_data column. Do a search for the ColumnName. When you find a spot, you'll see your eep code. The next step is to figure out where in the form it is! If it's a button, look above the eep code for a line that shows the "Caption". This is how you know which button the field is in.
Whenever I do something like change the name or the datatype or length of a field, I always do 3 things: 1. Use some kind of editor program to search all external programs for occurrence of the column name. 2. Search sys_reports3 where sys_data contains the columnname. 3. Search sys_forms3 ....... Between those 3 things you'll find it all! > I just did that but I do not believe it looked into the fields that have > eeps. So I am half way there. > > It is great when you update a column name and it runs along and updates > reports and forms etc…. But I think because I am adding in a new table > there > is no way of performing that type of function, so I am trying any ideas or > suggestions you all might have and recommend. I know I could use R:something > (Razzak knows the name, its documents your database) but for a one time > shot, on a couple columns it seems ashamed to buy this and then put it on the > shelf. > > > > Sincerely, > > Paul Dewey > > > > >
