On Friday 30 December 2011 09.41:45 liu...@21cn.com wrote: > > ok ! > > but found another bug . (odbcdatabase ) > > when fisrt get > > tsqlresult1.cols[0].asinteger result ok > > then > > next > > tsqlresult1.cols[0].asinteger > > tsqlresult1.cols[0].asinteger > > tsqlresult1.cols[0].asinteger > > ... > > result =484808 > > > > and same for > > tsqlresult1.cols[i].asstring > > > > when result ='' > > 。 > > may be odbc griver bug. > > if get like this > > tsqlresult1.cols[i].asinteger<--- > > tsqlresult1.cols[i+1].asinteger > > tsqlresult1.cols[i].asinteger<--- > > then > > > > Could not get field data for field 'id' (index 1). ODBC error details: > > Record 1: SqlState: 07009; NativeError: 0; Message: [Microsoft][ODBC SQL > > > so i must get value order by order > and get only one times . > but tmsesqlquery is all ok > may be tsqlresult's bug? > tsqlresult is not scrollable and has a buffer for the current record only. cols[0] is the first field, cols[1] the second field and so on. tsqlresult.next loads the next record. tmsesqlquery is scrollable and has buffers for all records of the resultset.
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