[
https://issues.apache.org/jira/browse/FLEX-19745?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Justin Mclean updated FLEX-19745:
---------------------------------
Labels: easytest (was: )
> Sqlite SQLStatement parameter bug
> ---------------------------------
>
> Key: FLEX-19745
> URL: https://issues.apache.org/jira/browse/FLEX-19745
> Project: Apache Flex
> Issue Type: Bug
> Components: Runtime Exceptions
> Affects Versions: Adobe Flex SDK Previous
> Environment: Affected OS(s): Windows
> Browser: Internet Explorer 7.x
> Language Found: English
> Reporter: Adobe JIRA
> Labels: easytest
>
> Steps to reproduce:
> 1. Create an instance of type SQLStatement
> 2._dbStatement.text = "INSERT INTO Notes (date, message, deleted, sortOrder)
> VALUES (:date,:message,:deleted,:sortorder);";
> 3._dbStatement.parameters[":date"] = oNote.date;
> _dbStatement.parameters[":message"] = oNote.message;
> _dbStatement.parameters[":deleted"] = String(oNote.deleted);
> _dbStatement.parameters[":sortorder"] = oNote.sortOrder;
> _dbStatement.execute();
>
> Actual Results:
> 'Error #3115: SQL Error.', details:'':date', ':message', ':deleted' and
> ':sortorder' parameter name(s) found in parameters property but not in the
> SQL specified.', operation:'execute', detailID:'1003'
> Or when you just disable step 3 except for the executepart:
> 'Error #3115: SQL Error.', details:'Mismatch in parameter count. Found 4 in
> SQL specified and 0 value(s) set in parameters property.
>
> Expected Results:
> No error...
> This works in flex 3 like a charm.
>
>
> Workaround (if any):
--
This message is automatically generated by JIRA.
If you think it was sent incorrectly, please contact your JIRA administrators
For more information on JIRA, see: http://www.atlassian.com/software/jira
