Database - Update from Data Entry/Query form

Melvin Cox melcox at hotmail.com
Wed Nov 26 02:59:01 CST 2003


Thanks for the suggestion.

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 *             0x0012E91A

Revolution      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               05181818

Revolution      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 *             0012F17C

Revolution      6c0-578	EXIT  SQLAllocStmt  with return code 0 (SQL_SUCCESS)
		HDBC                051812F8
		HSTMT *             0x0012F17C ( 0x05181818)

-------------------------------------------------------------------------------------------------------------


Melvin Cox


----Original Message Follows----
From: Brian Maher <plsntbreez at mac.com>
Reply-To: How to use Revolution <use-revolution at lists.runrev.com>
To: How to use Revolution <use-revolution at lists.runrev.com>
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 
<use-revolution at lists.runrev.com>;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 
<use-revolution at lists.runrev.com>;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 <use-revolution at lists.runrev.com>;Tue, 25 Nov 2003 
16:01:08 -0800 (PST)
X-Message-Info: KtxBqYfPyq0vHQ+HEwhIyFv1NqoEGjzx
Delivered-To: use-revolution at lists.runrev.com
In-Reply-To: <LAW10-F56v9mF7ma2Mx00012ce8 at hotmail.com>
References: <LAW10-F56v9mF7ma2Mx00012ce8 at hotmail.com>
Message-Id: <9DD206C0-1FA3-11D8-9A35-000A95B02D84 at mac.com>
X-Mailer: Apple Mail (2.606)
X-BeenThere: use-revolution at lists.runrev.com
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:use-revolution-request at lists.runrev.com?subject=unsubscribe>
List-Archive: <http://lists.runrev.com/pipermail/use-revolution>
List-Post: <mailto:use-revolution at lists.runrev.com>
List-Help: <mailto:use-revolution-request at lists.runrev.com?subject=help>
List-Subscribe: 
<http://lists.runrev.com/mailman/listinfo/use-revolution>,<mailto:use-revolution-request at lists.runrev.com?subject=subscribe>
Sender: use-revolution-bounces at lists.runrev.com
Errors-To: use-revolution-bounces at lists.runrev.com
Return-Path: use-revolution-bounces at lists.runrev.com
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
use-revolution at lists.runrev.com
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



More information about the use-livecode mailing list