On Friday 30 December 2011 19:14:59 Patrick wrote: > I am learning how to use a postgresql database. I can read / write the > database via sql statements. > > I would like to use a tmsesqlquery that has parameters. So far I have not > had any success. > > Is there an example somewhere of what I need to construct / do to > successfully use a parametized query. > Did you use MSEgui sqldb components with other database (Firebird, MySQL, Sqlite3) before? Postgres works the same. A simple project:
Place a tmsepqconnection (conn), tmsesqltransaction (trans), tmsesqlquery (query), tmsedatasource (dataso), tdbnavigator (navigator) and a tdbstringgrid (grid) on the form, all from tab DB. Set conn.transaction to trans, query.database to conn, dataso.dataset to query, navigator.datasource to dataso, grid.datalink.datasource to dataso. Setup the connection properties in conn. Enter the query statement (ex. "select * from table1;" without quotes) in query.SQL. Activate grid.options dsgo_autofields. Check if query.controller.options dso_autoapply and dso_autocommitret are set, it is the default in MSEgui git master version. Set query.active to true. If the table has a primary key the parametrized insert, update and delete statements were built automatically. Please write what you want to achieve with the query. Martin ------------------------------------------------------------------------------ Ridiculously easy VDI. With Citrix VDI-in-a-Box, you don't need a complex infrastructure or vast IT resources to deliver seamless, secure access to virtual desktops. With this all-in-one solution, easily deploy virtual desktops for less than the cost of PCs and save 60% on VDI infrastructure costs. Try it free! http://p.sf.net/sfu/Citrix-VDIinabox _______________________________________________ mseide-msegui-talk mailing list mseide-msegui-talk@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/mseide-msegui-talk