1) I have a been successful in fetching data from the database (MySql) for the person table.
When i tried to insert a row in that table using SaveDataEntity, i am getting some SQL exceptions.
Which says that there is syntax error in the query, but i have written no query, have simply set data in the Person object created.
Code snippet is pasted below for your refrence.
Person $p := new Person;
$p.firstName := 'Jack';
$p.lastName := 'Mill';
SqlOpen('mysql-datasource', false);
// Long $awid := SaveDataEntity($p, 'mysql-datasource');
SaveDataEntity($p, 'mysql-datasource');
SqlCommit();
Can you please point out what could be the cause.
2) I have created a new table in the database and want to perform database operations on it. How do i map the new table with the new dataclass. As i do not see my dataclass listing in the dropdownlist for mapping in the database tool provided with the datastore extension.
3) I have been successful in calling the stored procedure through our Appway script, but retriving the return data from the store procedure is a bit cumbersome. Can you suggest any simpler way to handle the OUT data from the stored procedure in the Appway script.
I have 3 querries.
1) I have a been successful in fetching data from the database (MySql) for the person table.
When i tried to insert a row in that table using SaveDataEntity, i am getting some SQL exceptions.
Which says that there is syntax error in the query, but i have written no query, have simply set data in the Person object created.
Code snippet is pasted below for your refrence.
Person $p := new Person;
$p.firstName := 'Jack';
$p.lastName := 'Mill';
SqlOpen('mysql-datasource', false);
// Long $awid := SaveDataEntity($p, 'mysql-datasource');
SaveDataEntity($p, 'mysql-datasource');
SqlCommit();
Can you please point out what could be the cause.
2) I have created a new table in the database and want to perform database operations on it. How do i map the new table with the new dataclass. As i do not see my dataclass listing in the dropdownlist for mapping in the database tool provided with the datastore extension.
3) I have been successful in calling the stored procedure through our Appway script, but retriving the return data from the store procedure is a bit cumbersome. Can you suggest any simpler way to handle the OUT data from the stored procedure in the Appway script.
Any help would be appreciated.
Thanks,
Varnita.