On 28 October 2011 22:08, Kirill Scherba <[email protected]> wrote:
> Hi, > > I've added code from the "Advanced GdaDataSelect usage" example "Automatic > re-run of the SELECT statement" to my application and it doesn't > work properly. I have an error message When I execute the next > gda_set_set_holder_value (params, NULL, "theid", 4); > in my code, and the data doesn't changed. > The message is: WARNING **: Could not re-run SELECT statement: Can't get > the prepared statement's actual statement > > When I try the next sample in the "Advanced GdaDataSelect usage" - Invalid > parameters I have other message and code doesn't execute properly too. The > message is: Could not execute the SQL command: Parameter 'theid' is invalid > > What's wrong? What's the secret is in the "Advanced GdaDataSelect usage"? > > It works for me, see the simple example attached, which gives the following output when run: ./test id | name | default_served_by | country | city ---+---------------+-------------------+---------+----- 2 | Ed Lamton | 4 | SP | MDR 3 | Lew Bonito | 1 | FR | TLS 4 | Mark Lawrence | NULL | SP | MDR (3 rows) id | name | default_served_by | country | city ---+---------------+-------------------+---------+----- 2 | Ed Lamton | 4 | SP | MDR 3 | Lew Bonito | 1 | FR | TLS 4 | Mark Lawrence | NULL | SP | MDR 9 | Greg Popoff | 2 | SP | MDR (4 rows) To check your problem, could you be more specific about the version of Libgda you use and which database server you use? Also a small test case would be useful. Regards, Vivien
20111101_data_select_rerun.tbz
Description: application/bzip-compressed-tar
_______________________________________________ gnome-db-list mailing list [email protected] http://mail.gnome.org/mailman/listinfo/gnome-db-list
