![]() |
![]() |
![]() |
GNOME Data Access manual | ![]() |
---|
It can be made, more or less, as in the old version, using gda_command_new(), but now, this function needs a few parameters and, in this version, you do not link a command to a connection, so you execute a command in a connection as we'll see later. You can see how to create commands and examples about this here.
Non queries are queries that do not return
data, as insertions, deletions, and so on. The function we use is
It is better not to execute more than one SQL sentence for each command because the result can be unexpected.
A normal query is a query that return data. This is made as a data model, analogous to GdaRecordset in the old version[5].
As you can see in the following example, the function we use to
obtain data from a SQL sentence is
As in the case of non queries, you must not use several semicolon-separated sentences, because you have a special function to do this[6], but it is not recommended.