SELECT TRIM("fEwcDivision") FROM "TempData_TableC002700" WHERE TRIM("fEwcDivision") <> '' GROUP BY TRIM("fEwcDivision")
数据库:POSTGRES 8.2.5
在数据库管理器中查询数据正常,结果查询出26条非空,且不重复(有效字符非重复,比如“AA”和“AA ”算相同)
但是用在VB语言中提交语句给ODBC处理,结果返回大出所料,全部是NULL(26条) 请高人帮分析分析!
数据库:POSTGRES 8.2.5
在数据库管理器中查询数据正常,结果查询出26条非空,且不重复(有效字符非重复,比如“AA”和“AA ”算相同)
但是用在VB语言中提交语句给ODBC处理,结果返回大出所料,全部是NULL(26条) 请高人帮分析分析!
效果还是一样!是不是数据库有问题呢??
CREATE TABLE "TempData_TableC002700"
(
"fEwcDatMasID" integer NOT NULL DEFAULT 0,
"fEwcDatNo" integer NOT NULL DEFAULT 0,
"fEwcRow" integer NOT NULL DEFAULT 0,
"fEwcDIA" character varying(2) NOT NULL DEFAULT ''::character varying,
"fEwcPage" character varying(4) NOT NULL DEFAULT ''::character varying,
"fEwcFR" character varying(4) NOT NULL DEFAULT ''::character varying,
"fEwcGaiMasID" integer NOT NULL DEFAULT 0,
"fEwcCircuit" character varying(8) NOT NULL DEFAULT ''::character varying,
"fEwcDivision" character varying(8) NOT NULL DEFAULT ''::character varying,
"fEwcDivNo" integer NOT NULL DEFAULT 0,
"fEwcDivCheck" character(1) NOT NULL DEFAULT '0'::bpchar,
"fEwcDekID1" character varying(3) NOT NULL DEFAULT ''::character varying,
"fEwcDekID2" character varying(3) NOT NULL DEFAULT ''::character varying,
"fEwcDestination1" character varying(28) NOT NULL DEFAULT ''::character varying,
"fEwcDestination2" character varying(28) NOT NULL DEFAULT ''::character varying,
"fEwcClrMasID" character varying(4) NOT NULL DEFAULT '0'::character varying,
"fEwcCutPrint" smallint NOT NULL DEFAULT 0,
"fEwcMark" double precision NOT NULL DEFAULT 0,
"fEwcLength" double precision NOT NULL DEFAULT 0,
"fEwcForcePrint" character(1) NOT NULL DEFAULT '0'::character varying,
"fEwcSetFlag1" character(1) NOT NULL DEFAULT '0'::bpchar,
"fEwcForeRGB1" integer NOT NULL DEFAULT 0,
"fEwcBackRGB1" integer NOT NULL DEFAULT 0,
"fEwcSetFlag2" character(1) NOT NULL DEFAULT '0'::bpchar,
"fEwcForeRGB2" integer NOT NULL DEFAULT 0,
"fEwcBackRGB2" integer NOT NULL DEFAULT 0,
"fEwcSetFlag3" character(1) NOT NULL DEFAULT '0'::bpchar,
"fEwcForeRGB3" integer NOT NULL DEFAULT 0,
"fEwcBackRGB3" integer NOT NULL DEFAULT 0,
"fEwcSetFlag4" character(1) NOT NULL DEFAULT '0'::bpchar,
"fEwcForeRGB4" integer NOT NULL DEFAULT 0,
"fEwcBackRGB4" integer NOT NULL DEFAULT 0,
"fEwcSetFlag5" character(1) NOT NULL DEFAULT '0'::bpchar,
"fEwcForeRGB5" integer NOT NULL DEFAULT 0,
"fEwcBackRGB5" integer NOT NULL DEFAULT 0,
"fEwcSetFlag6" character(1) NOT NULL DEFAULT '0'::bpchar,
"fEwcForeRGB6" integer NOT NULL DEFAULT 0,
"fEwcBackRGB6" integer NOT NULL DEFAULT 0,
"fEwcSetFlag7" character(1) NOT NULL DEFAULT '0'::bpchar,
"fEwcForeRGB7" integer NOT NULL DEFAULT 0,
"fEwcBackRGB7" integer NOT NULL DEFAULT 0,
"fEwcSetFlag8" character(1) NOT NULL DEFAULT '0'::bpchar,
"fEwcForeRGB8" integer NOT NULL DEFAULT 0,
"fEwcBackRGB8" integer NOT NULL DEFAULT 0,
"fEwcSetFlag9" character(1) NOT NULL DEFAULT '0'::bpchar,
"fEwcForeRGB9" integer NOT NULL DEFAULT 0,
"fEwcBackRGB9" integer NOT NULL DEFAULT 0,
"fEwcSetFlag10" character(1) NOT NULL DEFAULT '0'::bpchar,
"fEwcForeRGB10" integer NOT NULL DEFAULT 0,
"fEwcBackRGB10" integer NOT NULL DEFAULT 0,
"fEwcSetFlag11" character(1) NOT NULL DEFAULT '0'::bpchar,
"fEwcForeRGB11" integer NOT NULL DEFAULT 0,
"fEwcBackRGB11" integer NOT NULL DEFAULT 0,
"fEwcSetFlag12" character(1) NOT NULL DEFAULT '0'::bpchar,
"fEwcForeRGB12" integer NOT NULL DEFAULT 0,
"fEwcBackRGB12" integer NOT NULL DEFAULT 0,
"fEwcSetFlag13" character(1) NOT NULL DEFAULT '0'::bpchar,
"fEwcForeRGB13" integer NOT NULL DEFAULT 0,
"fEwcBackRGB13" integer NOT NULL DEFAULT 0,
"fEwcSetFlag14" character(1) NOT NULL DEFAULT '0'::bpchar,
"fEwcForeRGB14" integer NOT NULL DEFAULT 0,
"fEwcBackRGB14" integer NOT NULL DEFAULT 0,
"fEwcPrint" character(1) NOT NULL DEFAULT '0'::bpchar,
"fEwcPrintOver" character(1) NOT NULL DEFAULT '0'::bpchar,
"fEwcCutPrintOver" character(1) NOT NULL DEFAULT '0'::bpchar,
"fEwcDemPrintOver" character(1) NOT NULL DEFAULT '0'::bpchar,
"fEwcUpDivision" character varying(4) NOT NULL DEFAULT ''::character varying,
"fEwcUpDivPosition" smallint NOT NULL DEFAULT 0,
"fEwcDownDivision" character varying(4) NOT NULL DEFAULT ''::character varying,
"fEwcDownDivPosition" smallint NOT NULL DEFAULT 0,
"fEwc01DivPosition" smallint NOT NULL DEFAULT 0,
"fEwc02Division" character varying(4) NOT NULL DEFAULT ''::character varying,
"fEwc02DivPosition" smallint NOT NULL DEFAULT 0,
"fEwc03Division" character varying(4) NOT NULL DEFAULT ''::character varying,
"fEwc03DivPosition" smallint NOT NULL DEFAULT 0,
"fEwc04Division" character varying(4) NOT NULL DEFAULT ''::character varying,
"fEwc04DivPosition" smallint NOT NULL DEFAULT 0,
"fEwc05Division" character varying(4) NOT NULL DEFAULT ''::character varying,
"fEwc05DivPosition" smallint NOT NULL DEFAULT 0,
"fEwc06Division" character varying(4) NOT NULL DEFAULT ''::character varying,
"fEwc06DivPosition" smallint NOT NULL DEFAULT 0,
"fEwc07Division" character varying(4) NOT NULL DEFAULT ''::character varying,
"fEwc07DivPosition" smallint NOT NULL DEFAULT 0,
"fEwc08Division" character varying(4) NOT NULL DEFAULT ''::character varying,
"fEwc08DivPosition" smallint NOT NULL DEFAULT 0,
"fEwc09Division" character varying(4) NOT NULL DEFAULT ''::character varying,
"fEwc09DivPosition" smallint NOT NULL DEFAULT 0,
"fEwc10Division" character varying(4) NOT NULL DEFAULT ''::character varying,
"fEwc10DivPosition" smallint NOT NULL DEFAULT 0,
"fEwc11Division" character varying(4) NOT NULL DEFAULT ''::character varying,
"fEwc11DivPosition" smallint NOT NULL DEFAULT 0,
"fEwc12Division" character varying(4) NOT NULL DEFAULT ''::character varying,
"fEwc12DivPosition" smallint NOT NULL DEFAULT 0,
"fEwc13Division" character varying(4) NOT NULL DEFAULT ''::character varying,
"fEwc13DivPosition" smallint NOT NULL DEFAULT 0,
"fEwc14Division" character varying(4) NOT NULL DEFAULT ''::character varying,
"fEwc14DivPosition" smallint NOT NULL DEFAULT 0,
"fEwc15Division" character varying(4) NOT NULL DEFAULT ''::character varying,
"fEwc15DivPosition" smallint NOT NULL DEFAULT 0,
"fEwc16Division" character varying(4) NOT NULL DEFAULT ''::character varying,
"fEwc16DivPosition" smallint NOT NULL DEFAULT 0,
"fEwc17Division" character varying(4) NOT NULL DEFAULT ''::character varying,
"fEwc17DivPosition" smallint NOT NULL DEFAULT 0,
"fEwc18Division" character varying(4) NOT NULL DEFAULT ''::character varying,
"fEwc18DivPosition" smallint NOT NULL DEFAULT 0,
"fEwc19Division" character varying(4) NOT NULL DEFAULT ''::character varying,
"fEwc19DivPosition" smallint NOT NULL DEFAULT 0,
"fEwc20Division" character varying(4) NOT NULL DEFAULT ''::character varying,
"fEwc20DivPosition" smallint NOT NULL DEFAULT 0,
"fEwc21Division" character varying(4) NOT NULL DEFAULT ''::character varying,
"fEwc21DivPosition" smallint NOT NULL DEFAULT 0,
"fEwc22Division" character varying(4) NOT NULL DEFAULT ''::character varying,
"fEwc22DivPosition" smallint NOT NULL DEFAULT 0,
"fEwc23Division" character varying(4) NOT NULL DEFAULT ''::character varying,
"fEwc23DivPosition" smallint NOT NULL DEFAULT 0,
"fEwc24Division" character varying(4) NOT NULL DEFAULT ''::character varying,
"fEwc24DivPosition" smallint NOT NULL DEFAULT 0,
"fEwc25Division" character varying(4) NOT NULL DEFAULT ''::character varying,
"fEwc25DivPosition" smallint NOT NULL DEFAULT 0,
"fEwc26Division" character varying(4) NOT NULL DEFAULT ''::character varying,
"fEwc26DivPosition" smallint NOT NULL DEFAULT 0,
"fEwc27Division" character varying(4) NOT NULL DEFAULT ''::character varying,
"fEwc27DivPosition" smallint NOT NULL DEFAULT 0,
"fEwc28Division" character varying(4) NOT NULL DEFAULT ''::character varying,
"fEwc28DivPosition" smallint NOT NULL DEFAULT 0,
"fEwc29Division" character varying(4) NOT NULL DEFAULT ''::character varying,
"fEwc29DivPosition" smallint NOT NULL DEFAULT 0,
"fEwc30Division" character varying(4) NOT NULL DEFAULT ''::character varying,
"fEwc30DivPosition" smallint NOT NULL DEFAULT 0,
"fEwcDeleteKbn" character(1) NOT NULL DEFAULT ''::bpchar,
"fEwcMikakunin" integer NOT NULL DEFAULT 0,
"fEwcCreateDate" timestamp without time zone NOT NULL DEFAULT now(),
"fEwcCreateName" character varying(40) NOT NULL DEFAULT ''::character varying,
"fEwcUpdateDate" timestamp without time zone NOT NULL DEFAULT now(),
"fEwcUpdateName" character varying(40) NOT NULL DEFAULT ''::character varying
)
WITHOUT OIDS;
ALTER TABLE "TempData_TableC002700" OWNER TO postgres;
建表代码,没有关键字段,是临时使用的表!
再说我在pgAdmin3中用同样的语句能得到26条非NULL数据,但是用VB通过ODBC就返回26条NULL数据
SELECT "fEwcDivision" FROM "TempData_TableC002700" WHERE TRIM("fEwcDivision") <> '' GROUP BY "fEwcDivision" 在使用数据集合的时候再处理处理,吧"AA" 和 "AA " 再比较处理保留"AA"
这样虽然没有发挥数据库优势,好歹也是功能上哒到了,如果有人知道怎么用数据库处理数据,请告诉我,我再去修改查询语句!