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
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
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
Hi Skip,
I'd say it would be quite easy to open both dbs in LC, do a SELECT on each
one for the primary key and the three fields you're interested in, then
use LC to compare the results. One way to do it might be to put the
results of the first SELECT into an array keyed by the primary key, do
Is there a way to do a live comparison of the two or would it
be best to import data from the two DBs into two separate
tables locally and then do some type of comparison? I am
really only comparing about 3 fields from each DB.
Valentina Studio Pro has a SQL DIFF feature that should be
Hi Lynn,
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.
SKIP
On Sun, Apr 28, 2013
On 29/04/2013, at 7:58 AM, Magicgate Software - Skip Kimpel
s...@magicgate.com wrote:
What would be the best approach for this in LC? One
is a remote MySQL DB and the other is a local Access DB.
I have not done any work with Access, so I don't know what its capabilities
are. Nevertheless,