Re: [gnome-db] is it valid to have /*## ...*/ in the middle of nowhere?





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



[Date Prev][Date Next]   [Thread Prev][Thread Next]   [Thread Index] [Date Index] [Author Index]