realbasic-nug
[Top] [All Lists]

Re: Mysql

To: REALbasic NUG <realbasic-nug at lists dot realsoftware dot com>
Subject: Re: Mysql
From: Joshua Demori <rbdemori at earthlink dot net>
Date: Thu, 30 Mar 2006 13:03:51 -0500
Delivered-to: realbasic-nug at lists dot realsoftware dot com
Domainkey-signature: a=rsa-sha1; q=dns; c=nofws; s=dk20050327; d=earthlink.net; b=GoBDwPy+0LYgr5nciertLQkR4jk3E2l23cUCAKQrF0WVttDdXY6TxrbwL7GDyEs7; h=Received:Mime-Version:In-Reply-To:References:Content-Type:Message-Id:Content-Transfer-Encoding:From:Subject:Date:To:X-Mailer:X-ELNK-Trace:X-Originating-IP;
References: <4C735AF6-1BC0-4688-9EB6-DBD3C83B096A at earthlink dot net> <5d7ca37e0603300850s39a8b8b0i935d257ffe8cacd4 at mail dot gmail dot com>
if you run the following sql command it tells if something is successful
a -1 is an error in the last action
any number is the affected number of rows.
this is what I am using to determine if something is successful or not

rs = db.SQLSelect("SELECT ROW_COUNT();")

so basiacily you insert a database record
then run the command listed and go from there...



On Mar 30, 2006, at 11:50 AM, Mathieu Langlois wrote:

The error message (if there is one) from the database's ErrorMessage
property would be useful.

Math

On 3/30/06, Joshua Demori <rbdemori at earthlink dot net> wrote:

It seems if you in a method write to the database once its fine,
twice its fine,
but in a loop it seems to fail on certain records. and it seems to be
at the same spot all the time.
_______________________________________________
Unsubscribe or switch delivery mode:
<http://www.realsoftware.com/support/listmanager/>

Search the archives of this list here:
<http://support.realsoftware.com/listarchives/lists.html>

_______________________________________________
Unsubscribe or switch delivery mode:
<http://www.realsoftware.com/support/listmanager/>

Search the archives of this list here:
<http://support.realsoftware.com/listarchives/lists.html>


<Prev in Thread] Current Thread [Next in Thread>