相关子查询典型用法: declare @t table(rq varchar(10),hh int,ye dec(6,2)) insert into @t select '2006-01-02' ,1111 ,2.01 union all select '2006-01-05' ,1111 ,3.51 union all select '2006-01-10' ,1111 ,2.55 union all select '2006-01-02' ,2222 ,3.00 union all select '2006-01-04' ,2222 ,2.00 union all select '2006-01-05' ,3333 ,6.54 union all select '2006-01-06' ,3333 ,5.23 union all select '2006-01-07' ,3333 ,8.55
select * from @t a where not exists(select 1 from @t where hh=a.hh and rq>a.rq)
var frmbase: Tfrmbase; //以后应该是可以设置的。风格管理,可以保存在注册表中 const ENTERC0LOR = $00CDBDB4; EXITCOLOR = $00DAF3DD; implementation {$R *.dfm} procedure Tfrmbase.CmpEnter(Sender: TObject); var sProp: PPropInfo; begin sProp := GetPropInfo(Sender.ClassInfo, 'Color'); if sProp <> nil then SetOrdProp(Sender, sProp, ENTERC0LOR); end;
procedure Tfrmbase.CmpExit(Sender: TObject); var sProp: PPropInfo; begin sProp := GetPropInfo(Sender.ClassInfo, 'Color'); if sProp <> nil then SetOrdProp(Sender, sProp, EXITCOLOR); end;
procedure Tfrmbase.pSetComponents; var i: Integer; sColor, sEnter, sExit, sChanged: PPropInfo; vEnter, vExit: TMethod; mEvent: TNotifyEvent; begin for i := 0 to componentcount - 1 do begin sColor := GetPropInfo(Components[i].ClassInfo, 'Color'); sEnter := GetPropInfo(Components[i].ClassInfo, 'OnEnter'); sExit := GetPropInfo(Components[i].ClassInfo, 'OnExit'); sChanged := GetPropInfo(Components[i].ClassInfo, 'OnChange'); if (sChanged <> nil) and (sEnter <> nil) and (sExit <> nil) and (sColor <> nil) then begin SetOrdProp(Components[i], sColor, EXITCOLOR); mEvent := CmpEnter; vEnter.Code := @mEvent; vEnter.Data := Self; SetMethodProp(Components[i], sEnter, vEnter); mEvent := CmpExit; vExit.Code := @mEvent; vExit.Data := Self; SetMethodProp(Components[i], sExit, vExit); end; end;
end;
procedure Tfrmbase.FormCreate(Sender: TObject); begin pSetComponents; end; end.
不错,以上还有些好贴,不过,我有一个拼音首字母的用法,大家用过极品时刻表吗?里面就有首字输入法 我有一个单元。 unit IMCode;
interface
function MakeSpellCode(stText: string; iMode, iCount: Integer): string; { iMode 二进制功能位说明 X X X X X X X X X X X X X X X X 3 2 1 1: 0 - 只取各个汉字声母的第一个字母; 1 - 全取 2: 0 - 遇到不能翻译的字符不翻译; 1 - 翻译成 '?' (本选项目针对全角字符) 3: 0 - 生成的串不包括非数字, 字母的其他字符; 1 - 包括 (控制全角的要输出非数字, 字母字符的; 半角的非数字, 字母字符) }