Re: SQLIte, Result from revExecuteSQL
Dave- Tuesday, October 30, 2007, 5:19:00 PM, you wrote: When the command returns the result is set to 1. I've looked in the docs but it I can't seem to find anything that tells me what that means? BZ #3275. Supposedly fixed in 2.9.0-dp-1. -- -Mark Wieder [EMAIL PROTECTED] ___ use-revolution mailing list use-revolution@lists.runrev.com Please visit this url to subscribe, unsubscribe and manage your subscription preferences: http://lists.runrev.com/mailman/listinfo/use-revolution
SQLIte, Result from revExecuteSQL
Hi, I am using revExecuteSQL to execute a INSERT INTO SQL statement, as in: revExecuteSQL theDatabaseID,mySQLCode put the result into myResult When the command returns the result is set to 1. I've looked in the docs but it I can't seem to find anything that tells me what that means? Anyone know Thanks a Lot All the Best Dave ___ use-revolution mailing list use-revolution@lists.runrev.com Please visit this url to subscribe, unsubscribe and manage your subscription preferences: http://lists.runrev.com/mailman/listinfo/use-revolution
Re: SQLIte, Result from revExecuteSQL
On 10/31/07, Dave [EMAIL PROTECTED] wrote: When the command returns the result is set to 1. I've looked in the docs but it I can't seem to find anything that tells me what that means? Anyone know The command was successful, otherwise you'd have an SQL error message in 'the result'. I can't remember in this case if successful execution is always 1 or an integer. So what you might be after: revExecuteSQL theDatabaseID,mySQLCode if (the result is not an integer) then --add code to handle error message end if HTH ___ use-revolution mailing list use-revolution@lists.runrev.com Please visit this url to subscribe, unsubscribe and manage your subscription preferences: http://lists.runrev.com/mailman/listinfo/use-revolution
Re: SQLIte, Result from revExecuteSQL
Hi, The other database handlers return empty to mean ok. I had a problem executing a CREATE TABLE SQL statement and it returned a 1 and didn't work correctly. When I found and fixed the problem it then returned empty, so I am wondering if a similar problem exists here - it doesn't seem like the record(s) are being added correctly. All the Best Dave On 31 Oct 2007, at 00:48, Kay C Lan wrote: On 10/31/07, Dave [EMAIL PROTECTED] wrote: When the command returns the result is set to 1. I've looked in the docs but it I can't seem to find anything that tells me what that means? Anyone know The command was successful, otherwise you'd have an SQL error message in 'the result'. I can't remember in this case if successful execution is always 1 or an integer. So what you might be after: revExecuteSQL theDatabaseID,mySQLCode if (the result is not an integer) then --add code to handle error message end if HTH ___ use-revolution mailing list use-revolution@lists.runrev.com Please visit this url to subscribe, unsubscribe and manage your subscription preferences: http://lists.runrev.com/mailman/listinfo/use-revolution ___ use-revolution mailing list use-revolution@lists.runrev.com Please visit this url to subscribe, unsubscribe and manage your subscription preferences: http://lists.runrev.com/mailman/listinfo/use-revolution
Re: SQLIte, Result from revExecuteSQL
Dave, I think that 1 means 1 record successfully inserted. Try a query to insert 2 records in the same query and check if it returns 2... Andre On 10/30/07, Dave [EMAIL PROTECTED] wrote: Hi, I am using revExecuteSQL to execute a INSERT INTO SQL statement, as in: revExecuteSQL theDatabaseID,mySQLCode put the result into myResult When the command returns the result is set to 1. I've looked in the docs but it I can't seem to find anything that tells me what that means? Anyone know Thanks a Lot All the Best Dave ___ use-revolution mailing list use-revolution@lists.runrev.com Please visit this url to subscribe, unsubscribe and manage your subscription preferences: http://lists.runrev.com/mailman/listinfo/use-revolution -- http://www.andregarzia.com All We Do Is Code. ___ use-revolution mailing list use-revolution@lists.runrev.com Please visit this url to subscribe, unsubscribe and manage your subscription preferences: http://lists.runrev.com/mailman/listinfo/use-revolution