Posted: April 28 2004 at 21:05 | IP Logged

Hey Dave....

Why when I'm trying to copy over one of your fine macros to tweak from the sample db does the Direct SQL method complain about a Developer Password when trying to access the CONTROL table?

the particular macro was the PALM PAD CONTROL......

Posted: April 28 2004 at 21:20 | IP Logged

Heh! I've had that happen before, but, can't remember the fix.

Posted: April 29 2004 at 15:29 | IP Logged

Pete,

It's my fault .  In an attempt to prevent the CONTROL table from being accidently corrupted, I included simple checking to see it the CONTROL table was being modified.  Problem was, it was too simple and I simple searched for the string "CONTROL" anywhere within the SQL and disallowed it.

You could fix the SQL you're trying to import by doing a search and replace for any occurrence of the work "CONTROL" and using something like "CTRL" and then import it in with Direct SQL.

Ive also made a note to improve the checking algorithm so that this won't happen in future versions.

Dave.

Posted: April 29 2004 at 15:57 | IP Logged

Now why didn't I think of that.......okay.......that makes sense now!

Thanks!