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 th
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 Za
On 4/29/13 6:06 PM, "Lynn Fredricks" 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
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 poss
On 29/04/2013, at 7:58 AM, Magicgate Software - Skip Kimpel
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, here are a couple
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 at
> 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 b