My sincere thanks for the assistance provided.
Happy Thanksgiving,
Melvin Cox
---------------------------------------------------------------------------------
Jan Schenkel janschenkel at yahoo.com Wed Nov 26 04:13:57 EST 2003
--------------------------------------------------------------------------------
--- Brian Maher <plsntbreez at mac.com> wrote:
Hi Melvin,
You may want to send the entire trace log to the RunRev folks for analysis along with your sample stack.
There is definitely a problem.
Brian
Well, I looked over his test stack ; is that close enough ? :-)
I guess the confusion is mainly my fault, as I was the one to point out revExecuteSQL as a way of executing queries. (*) - The revExecuteSQL command is explained in the Transcript Dictionary ; its first parameter is a databaseID (aka connectionID). - The revExecuteWithQuery command on the other hand, is not documented ; its first parameter is the name of a query whose connection you need.
So in Melvin's stack, the script should have called either -- put revConnectionOfQuery("PeopleUpdate") \ into tConnectionID revExecuteSQL tConnectionID, tSQLQuery -- or -- revExecuteWithQuery "PeopleUpdate", tSQLQuery --
Now, apart from this confusion, there are a few things I'd like to mention.
- The undocumented database calls can be found by reviewing the frontscript named "revDatabase". -> Open the message box -> Click on the 6th button in its toolbar -> This brings you to the list of Front Scripts -> Doubleclick the line "revDatabase" MAKE SURE YOU DON'T SAVE ANY ACCIDENTAL CHANGES !
- Make sure the query you're referring to, actually exists ; in Melvin's test stack, there was no query "PeopleUpdate" defined using the Database Query Builder.
- When you're using these undocumented database calls, always put quotes around the name of queries, so instead of : revRefreshQuery PeopleUpdate you should script : revRefreshQuery "PeopleUpdate"
- Oh, and always make sure to check 'the result' after calling a command. In this case, it would have happily informed you : revdberr, invalid connection id and maybe then my brains would have kicked in :)
So in short, my apologies for leading you astray ; I hope that the above helps you out and may prevent future errors.
Best regards,
Jan Schenkel.
(*) That's why you pay Rev for support incidents ; on this free list, sometimes you may get the wrong answer ; mistakes happen ; for penitention, I'll go and make that new version of my report test stack now...
=====
"As we grow older, we grow both wiser and more foolish at the same time." (La Rochefoucauld)
_________________________________________________________________
Groove on the latest from the hot new rock groups! Get downloads, videos, and more here. http://special.msn.com/entertainment/wiredformusic.armx
_______________________________________________ use-revolution mailing list [EMAIL PROTECTED] http://lists.runrev.com/mailman/listinfo/use-revolution