On Wednesday 08 August 2012 10:04:08 liuzg2 wrote: > δΊ 2012-08-08 14:18, Martin Schreiber ει: > > Am 08.08.2012 07:01, schrieb liuzg2: > >>> On Wednesday 08 August 2012 03:18:40 liuzg2 wrote: > >>>>> On Tuesday 07 August 2012 10:51:32 liuzg2 wrote: > >>>>>> ftbcd: begin > >>>>>> Res:=SQLGetData(ODBCCursor.FSTMTHandle, fno, SQL_C_DOUBLE, > >>>>>> @do1, SizeOf(Double), @StrLenOrInd); > >>>>>> > >>>>>> >>> cu1:= do1; > >>>>> > >>>>> What is the value of do1? > >>>> > >>>> do1=1.1854570043828581e+292 > >>> > >>> And what is the actual field value in the database? What is the value > >>> of "Res"? How is the field type defined in the database? > >> > >> i can not found this value .i open this query use 'where ...' one > >> by one . never raise error. > >> numeric(14,4) > > > > What is the value of "Res"? There probably should be a test of "res" > > before assigning cu1. Git master > > cc0a3ecf9fd28c7574fe2b57d6201983aa072cc2 has it, please try again. > > > > Martin > > res is 0 > but still error
A bug in ODBC driver? It should not set res to 0 (=OK) and return 1.1854570043828581e+292, it certainly is no numeric(14,4) value. > i set dbo_bcdtofloatif true ,but still read as ftbcd > dbo_bcdtofloatif uses ftfloat if the field can not be represented as currency. numeric(14,4) can be represented as currency AFAIK. Martin ------------------------------------------------------------------------------ Live Security Virtual Conference Exclusive live event will cover all the ways today's security and threat landscape has changed and how IT managers can respond. Discussions will include endpoint security, mobile security and the latest in malware threats. http://www.accelacomm.com/jaw/sfrnl04242012/114/50122263/ _______________________________________________ mseide-msegui-talk mailing list mseide-msegui-talk@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/mseide-msegui-talk
