Unfortunately, I receive the same results with the simplified UPDATE example.
I am running against Sybase Adaptive Server Enterprise 12.5 and Revolution 2.1 on a Windows 2000 platform. The Sybase server is local.
To insure that the problem is not caused by something in my code, I have created an entirely new stack with three fields ("fname", "mname" and "lname"), and three buttons (Query, Update and Clear). The Query button calls a hard coded select statement. It correctly populates the three fields, with "mname" being null in the selected row. The Update button calls your simplified update statement.
Once again, I observe the same "non" behavior reported in my previous email.
A check of the Record Set within the Database Query Builder shows the select statement used by the Query button, not the update statement.
I have checked the ODBC manager and verified the connection.
I have run the new stack with the 'Cache result set' checkbox in the Query Builder ticked and un-ticked. When ticked, the mname field shows "NULL", when unticked, it shows a bold vertical bar.
Through the "Sybase Central" utility, I have confirmed that the my user id has full update permission on the table in question.
I would most sincerely appreciate any thoughts from the group on this. My evaluation/application development efforts have ground to a halt....
Many thanks,
Melvin Cox
----Original Message Follows----
From: Jan Schenkel <[EMAIL PROTECTED]>
Reply-To: How to use Revolution <[EMAIL PROTECTED]>
To: How to use Revolution <[EMAIL PROTECTED]>
Subject: Re: Database - Update from Data Entry/Query form
Date: Tue, 25 Nov 2003 02:58:14 -0800 (PST)
MIME-Version: 1.0
Received: from mc6-f15.hotmail.com ([65.54.252.151]) by mc6-s21.hotmail.com with Microsoft SMTPSVC(5.0.2195.6713); Tue, 25 Nov 2003 02:58:53 -0800
Received: from mail.runrev.com ([207.36.15.228]) by mc6-f15.hotmail.com with Microsoft SMTPSVC(5.0.2195.6713); Tue, 25 Nov 2003 02:58:22 -0800
Received: from www.runrev.com (localhost [127.0.0.1])by mail.runrev.com (Postfix) with ESMTPid B3112930061; Tue, 25 Nov 2003 05:56:45 -0500 (EST)
Received: from web60505.mail.yahoo.com (web60505.mail.yahoo.com[216.109.116.126])by mail.runrev.com (Postfix) with SMTP id 32D63930059for <[EMAIL PROTECTED]>;Tue, 25 Nov 2003 05:56:43 -0500 (EST)
Received: from [212.239.164.95] by web60505.mail.yahoo.com via HTTP;Tue, 25 Nov 2003 02:58:14 PST
X-Message-Info: KtxBqYfPyq0AQOVkNELSQNeLabFFKthN
Delivered-To: [EMAIL PROTECTED]
Message-ID: <[EMAIL PROTECTED]>
In-Reply-To: <[EMAIL PROTECTED]>
X-BeenThere: [EMAIL PROTECTED]
X-Mailman-Version: 2.1.1
Precedence: list
List-Id: How to use Revolution <use-revolution.lists.runrev.com>
List-Unsubscribe: <http://lists.runrev.com/mailman/listinfo/use-revolution>,<mailto:[EMAIL PROTECTED]>
List-Archive: <http://lists.runrev.com/pipermail/use-revolution>
List-Post: <mailto:[EMAIL PROTECTED]>
List-Help: <mailto:[EMAIL PROTECTED]>
List-Subscribe: <http://lists.runrev.com/mailman/listinfo/use-revolution>,<mailto:[EMAIL PROTECTED]>
Sender: [EMAIL PROTECTED]
Errors-To: [EMAIL PROTECTED]
Return-Path: [EMAIL PROTECTED]
X-OriginalArrivalTime: 25 Nov 2003 10:58:22.0593 (UTC) FILETIME=[0B0A9710:01C3B343]
--- Melvin Cox <[EMAIL PROTECTED]> wrote: > Jan: > > Thanks once again for your informed assistance. > > Unfortunately, I can NOT get any update to run from > my test application. > > I have simplified my script to its barest elements, > and have attempted to > run the revExecuteSQL statement with a hard coded > SQL statement. > > I have confirmed the correctness of the generated > update statement, through > a 3rd Party isql utility, using the same user id and > password. > > The syntax appears correct: 'update people set mname > = 'Joseph' where 0 = 0 > and pid = 'GILMORE,C'' > > As there is absolutely NO sign of network activity, > it appears that the SQL > is never sent to the database server. The database > error log is clear of > all warnings. > > My testing for errors via a > "revDatabaseConnectResult" statement returns the > following message: "revdberr,invalid cursor id". > > Question: Is it necessary to include a databaseID, > when referencing an > existing query? > > I'm flabbergasted! > > > > M.C. >
Hi Melvin,
I would get rid of the "0 = 0" bit in the WHERE
clause. And try from a button :
--
put "UPDATE people SET mname = 'Joseph' " & \
"WHERE pid = 'GILMORE,C' ;" into tQuery
revExecuteSQL "SomeQuery", tQuery
--
(where SomeQuery is a query with the correct
connection info, and which is also set to remain open
until the stack closes)If that doesn't work and you don't get an error, there's something else in the way. Out of curiosity, which database are you using ? If it's MySQL, you should tick the 'Cache result set' checbox in the Query Builder.
Jan Schenkel.
=====
"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 _______________________________________________ use-revolution mailing list [EMAIL PROTECTED] http://lists.runrev.com/mailman/listinfo/use-revolution
_________________________________________________________________
Share holiday photos without swamping your Inbox. Get MSN Extra Storage now! http://join.msn.com/?PAGE=features/es
_______________________________________________ use-revolution mailing list [EMAIL PROTECTED] http://lists.runrev.com/mailman/listinfo/use-revolution
