Igor Thanks for the suggestions. I think doing it with LiveCode text handling is going to be a very flexible solution and you could just dump the data from the databases after a certain "date" which is set based on the last time they were synchronised.
On Mon, Apr 29, 2013 at 11:32 AM, Ruslan Zasukhin < ruslan_zasuk...@valentina-db.com> wrote: > On 4/29/13 6:06 PM, "Lynn Fredricks" <lfredri...@proactive-intl.com> > wrote: > > > Hi SKIP, > > > >> Is that something that can be scripted? I need to create an > >> automated > >> report of differences and emailed out to the appropriate > >> parties. I briefly looked at the SQL DIFF function that you > >> described but it looks like it is all manually run from Studio Pro. > > > > It should be possible to do it by script with LiveCode, but I would > imagine > > it would take a significant amount of coding. LiveCode has about the best > > text handling you are going to find in a development tool. > > > > Yes, in Studio Pro you have to run it. We don't have scripting supported > > yet. > > Let me add ... > > 1) Valentina DB already have on engine level interesting SQL command > MAIL ... TO ... > > 2) We going add into Valentina Studio Sceduler, > To be able automate different tasks ... > > We have right now scheduler in Valentina Server ... But it do not have SQL > DIFF .. > > > So ... I think with scheduler, in near future it should be possible do > DIFF, > and send result by email ... > > 4) Also Valentina Studio Pro have reports, which can allow produce even > nice > HTML/PDF reports to be sent also ... > > > -- > Best regards, > > Ruslan Zasukhin > VP Engineering and New Technology > Paradigma Software, Inc > > Valentina - Joining Worlds of Information > http://www.paradigmasoft.com > > [I feel the need: the need for speed] > > > > _______________________________________________ > use-livecode mailing list > use-livecode@lists.runrev.com > Please visit this url to subscribe, unsubscribe and manage your > subscription preferences: > http://lists.runrev.com/mailman/listinfo/use-livecode > -- http://www.bluewatermaritime.com _______________________________________________ use-livecode mailing list use-livecode@lists.runrev.com Please visit this url to subscribe, unsubscribe and manage your subscription preferences: http://lists.runrev.com/mailman/listinfo/use-livecode
