Paul, You can uncompress your forms (see RFormPacker76.RBL or RFormPacker80.RBL to make this easy), and then:
select * from sys_forms3 where sys_data contains 'columnname' AND sys_data contains 'tablename' Unfortunately, it might be hard to write the where clause that says "what forms ought to have the new column named xxxx but don't?" Bill On Tue, Apr 22, 2008 at 8:11 AM, Paul InterlockInfo <[EMAIL PROTECTED]> wrote: > I am adding several new tables to a database that is up every day > running. Now I thought about dupping information during the transition but > ….. So my question to the members here is. > > > > > > > > You add a table add new column (name also) you have forms, reports, eeps > etc……. Is there an easy way to find all the places without running some > form or report and getting the error message that column does not exist? > All because I failed to update that form and insert new table/column and > reports. Heck, some of these we use but once in a blue moon but then it > fails. > > > > > > > > Example Client Table has clientid,fname,l,name,car Now we create a > new table that is Vehicle it has Car_Id,Make,Model but my report or form > had only the first table and I forgot this form/report had this tidbit > information from the first table. I would like to avoid all of these > mishaps. I recall somewhere I could find this but I cannot put my finger on > it now when I need it. Old Age, I guess. I hate turning %) > > > > > > > > Sincerely, > > Paul Dewey > > > > > > New Horizon Interlock Inc. > > New Horizon Safety Diagnostics Inc. > > www.interlockinfo.com > > *Saving Lives - One Breath at A Time* ™ > > > > This e-mail message is intended only for the named recipient(s) above and > is covered by the Electronic Communications Privacy Act 18 U.S.C. Section > 2510-2521. This e-mail is confidential and may contain information that is > privileged or exempt from disclosure under applicable law. If you have > received this message in error please immediately notify the sender by > return e-mail and delete this e-mail message from your computer. > > >
