Hi Dave, did you solve the problem? How ? El 13/6/2016 14:23, "Fernando D. Bozzo" <[email protected]> escribió:
> Hi Dave: > > You can use FoxBin2Prg for that. Just need to copy/change the metadata in > plain text and regenerate your DBC and DBF > > I think that it's easier to look and change 2 plain text files than fight > with a lot of functions. > > > Best Regards.- > > > El 13/6/2016 12:38, "Dave Crozier" <[email protected]> escribió: > >> Laurie, >> Thought you'd cracked it there but the copy procedures command does >> nothing at all, simply creates a zero byte file. Alan's solution works so >> I'll go with that and check each table for all triggers. The program I am >> amending is a constant DBC backup program that has been working for years >> but never had to bother with triggers before! >> >> Thanks guys. >> >> Dave >> >> >> -----Original Message----- >> From: ProFox [mailto:[email protected]] On Behalf Of Laurie Alvey >> Sent: 13 June 2016 11:22 >> To: ProFox Email List <[email protected]> >> Subject: Re: Copying Triggers >> >> Have you looked at COPY PROCEDURES TO <filename> followed by APPEND >> PROCEDURES FROM <filename>? With a bit of editing of the output file, it >> might do what you want. >> >> Laurie >> >> On 13 June 2016 at 10:11, Dave Crozier <[email protected]> wrote: >> >> > Ladies and Gentlemen, >> > Anyone know if there is a way to copy triggers over to a new table >> > without having to enquire into the DBC container? >> > >> > I have found that the triggers are held against each table in the DBC >> > in the record with "objectname field" set to the name of the table, >> > being held in the table "Property field" (Memo) so you can get at the >> > contents of the triggers but I don't really want to have to do this if >> > there is a table copy command or equivalent that does it for you. I am >> > not simply being lazy here as copying this memo field over using >> > scatter/gather doesn't always seem to transfer the correct trigger >> > info over into the destination table. >> > >> > We have recently started making use of triggers to automatically >> > insert records into a M$ table mirror of the VFP Table to aid in >> > converting over from VFP tables to M$ SQL tables and the inability to >> > copy triggers over has bit me in the proverbial "ass". We have a small >> > tag call to a SQL master object that updates the SQL table whenever >> > the VFP base table is updated (Insert/Update and Delete). >> > >> > Dave >> > >> > [excessive quoting removed by server] _______________________________________________ Post Messages to: [email protected] Subscription Maintenance: http://mail.leafe.com/mailman/listinfo/profox OT-free version of this list: http://mail.leafe.com/mailman/listinfo/profoxtech Searchable Archive: http://leafe.com/archives/search/profox This message: http://leafe.com/archives/byMID/profox/cagq_jum8rd4yehtd8wplep+e4snoi_ggeaduv_hobkao2br...@mail.gmail.com ** All postings, unless explicitly stated otherwise, are the opinions of the author, and do not constitute legal or medical advice. This statement is added to the messages for those lawyers who are too stupid to see the obvious.
