The ODBC Trace output from my test stack confirms that only the Select statement (not the Update statement) is being sent to the data server. Curious!
The only mention of "Error" is as follows:
-------------------------------------------------------------------------------------------------------------
Revolution 6c0-578 ENTER SQLErrorW
HENV 05181250
HDBC 051812F8
HSTMT 05181818
WCHAR * 0x0012E8E4 (NYI)
SDWORD * 0x0012E91C
WCHAR * 0x0012E4E4
SWORD 511
SWORD * 0x0012E91ARevolution 6c0-578 EXIT SQLErrorW with return code 100 (SQL_NO_DATA_FOUND)
HENV 05181250
HDBC 051812F8
HSTMT 05181818
WCHAR * 0x0012E8E4 (NYI)
SDWORD * 0x0012E91C
WCHAR * 0x0012E4E4
SWORD 511
SWORD * 0x0012E91A
Revolution 6c0-578 ENTER SQLFetch
HSTMT 05181818Revolution 6c0-578 EXIT SQLFetch with return code 100 (SQL_NO_DATA_FOUND)
HSTMT 05181818
Revolution 6c0-578 ENTER SQLFreeStmt
HSTMT 05181818
UWORD 1 <SQL_DROP>Revolution 6c0-578 EXIT SQLFreeStmt with return code 0 (SQL_SUCCESS)
HSTMT 05181818
UWORD 1 <SQL_DROP>Revolution 6c0-578 ENTER SQLAllocStmt
HDBC 051812F8
HSTMT * 0012F17CRevolution 6c0-578 EXIT SQLAllocStmt with return code 0 (SQL_SUCCESS)
HDBC 051812F8
HSTMT * 0x0012F17C ( 0x05181818)-------------------------------------------------------------------------------------------------------------
Melvin Cox
----Original Message Follows----
From: Brian Maher <[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 19:00:59 -0500
MIME-Version: 1.0 (Apple Message framework v606)
Received: from mc7-f4.hotmail.com ([65.54.253.11]) by mc7-s11.hotmail.com with Microsoft SMTPSVC(5.0.2195.6713); Tue, 25 Nov 2003 16:01:52 -0800
Received: from mail.runrev.com ([207.36.15.228]) by mc7-f4.hotmail.com with Microsoft SMTPSVC(5.0.2195.6713); Tue, 25 Nov 2003 16:01:15 -0800
Received: from www.runrev.com (localhost [127.0.0.1])by mail.runrev.com (Postfix) with ESMTPid 1D95893005E; Tue, 25 Nov 2003 18:59:40 -0500 (EST)
Received: from smtpout.mac.com (smtpout.mac.com [17.250.248.87])by mail.runrev.com (Postfix) with ESMTP id A5741930059for <[EMAIL PROTECTED]>;Tue, 25 Nov 2003 18:59:37 -0500 (EST)
Received: from mac.com (smtpin07-en1 [10.15.16.44])by smtpout.mac.com (Xserve/MantshX 2.0) with ESMTP id hAQ019MH019677for <[EMAIL PROTECTED]>;Tue, 25 Nov 2003 16:01:09 -0800 (PST)
Received: from [141.154.74.73] (pool-141-154-74-73.bos.east.verizon.net[141.154.74.73]) (authenticated bits=0)by mac.com (Xserve/smtpin07/MantshX 3.0) with ESMTP id hAQ018Pd002304for <[EMAIL PROTECTED]>;Tue, 25 Nov 2003 16:01:08 -0800 (PST)
X-Message-Info: KtxBqYfPyq0vHQ+HEwhIyFv1NqoEGjzx
Delivered-To: [EMAIL PROTECTED]
In-Reply-To: <[EMAIL PROTECTED]>
References: <[EMAIL PROTECTED]>
Message-Id: <[EMAIL PROTECTED]>
X-Mailer: Apple Mail (2.606)
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: 26 Nov 2003 00:01:16.0460 (UTC) FILETIME=[69A5DEC0:01C3B3B0]
Hi Melvin,
Turn on ODBC tracing and see what SQL statement (and errors, if any) are being generated.
Sincerely, Brian Maher
_______________________________________________ use-revolution mailing list [EMAIL PROTECTED] http://lists.runrev.com/mailman/listinfo/use-revolution
_________________________________________________________________
Set yourself up for fun at home! Get tips on home entertainment equipment, video game reviews, and more here. http://special.msn.com/home/homeent.armx
_______________________________________________ use-revolution mailing list [EMAIL PROTECTED] http://lists.runrev.com/mailman/listinfo/use-revolution
