2008/9/27 paragasu
<paragasu gmail com>
i used to see a GdaQuery SQL _expression_ like
SELECT * FROM account WHERE id=##/*name: 'account' type:'gint' */
but is it valid to have SQL
SELECT * FROM account WHERE ##/*name: 'account' type:'gchararray' */
(**note: without id= )
The point is, i want to create a search box. With one gtk_entry and
few radio button
for the user to select what information they want to find (name, last
name, email or SCN etc)
so, later i can substitute the _expression_ to something like
id=2
name LIKE 'john%'
does it work this way?
Yes, it should work. Please note that in V4, it is easier to work directly with the in-memory representation of a statement without having to use SQL at all.
Vivien