Database - Update from Data Entry/Query form

[Jan Schenkel]

--- 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)

__________________________________
Do you Yahoo!?
Protect your identity with Yahoo! Mail AddressGuard
http://antispam.yahoo.com/whatsnewfree