Sep 08, 2014; 16:40
Marc Pinnell
SQL 'delete' Inline and found_count
Thinking I have done this before but it isn't working. Can this not be done?
$sqlStatement = 'DELETE FROM table WHERE kdate = "2010-10-17";';
inline(
-Database = 'someTable',
-sql = $sqlStatement
);
found_count;
'<br />';
error_currenterror;
/inline;
This code returns:
0
No error
Yet a review of the table in Navicat shows that the statement actually removed at least 2 rows. What I am trying to report is the number of rows removed.
marc
Marc Pinnell
1027 Design
PO Box 990872
Redding, CA 96099-0872
530.941.4706
fax: 866.232.5300
www.1027Design.com
#############################################################
Attend the Lasso Developer Conference 2014!
October 1-3, 2014 at Treefrog HQ, Newmarket, Ontario, Canada
http://www.lassosoft.com/LDC-newmarket-2014
#############################################################
This message is sent to you because you are subscribed to
the mailing list Lasso Lasso@lists.lassosoft.com
Official list archives available at http://www.lassotalk.com
To unsubscribe, E-mail to: <Lasso-unsubscribe@lists.lassosoft.com>
Send administrative queries to <Lasso-request@lists.lassosoft.com>
Sep 09, 2014; 11:44
Ke Carlton
Re: SQL 'delete' Inline and found_count
Sep 08, 2014; 16:48
Marc Pinnell
Re: SQL 'delete' Inline and found_count