On Saturday 31 December 2011 15.51:20 Patrick wrote: > . > > > tsqlstatement <> tsqlresult. Use tsqlstatement for queries which don't > > return a result, use tsqlresult for queries which return a resultset but > > don't need to be scrollable, use tmsesqlquery if the resultset must be > > scrollable. > > Finally, a clear and concise statement as to how / when to use each > component. > > Using a tsqlstatement works for both mysql and postgresql databases. > > Thank you. > Ehem, please read my answer from yesterday: " tmsesqlquery is designed for scrollable resultsets. For SQL statements which don't return data tsqlresult should be used. Set <tsqlstatement>.sql to " insert into messages (touserid, fromuserid, created, message, replytomessageid) values (:touserid, :fromuserid, :created, :message, :replytomessageid); " That will initialize <tsqlstatement>.params, see attachment. Either set params[<n>].DataType at design time or params[n].as* at runtime in order to define the data type. For queries which return data tsqlresult can be used. "
------------------------------------------------------------------------------ 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
