吴昊的博客

select id from infoid-----------123567810111215(11 行受影响)方法一：select (select max(id)+1 from Info where id<a.id) as beginId,(id-1) as endIdfrom Info a where a.id>(select max(id)+1 from Info where i... Read More

通过ADOQuery或其它数据集组件的Sort属性配合DBGrid的OnTitleClick事件，可以方便地实现此功能。因为Sort属性可以让活动数据集按指定的字段进行排序，也可以选择排序方式（升序/降序)。我改进了一下这功能,在单击标题后分别在标题加上三角(▲)和倒三角形(▼)表示当前排序方式为升序和降序;(gaowenjie)procedure TForm1.DBGri... Read More

function FilterQryByDBG(aQry: TQuery; aDBGrid: TDBGrid; aFilterValue: string): string; //对DBGrid的指定列的过滤var FieldNO: Integer; Condition: string;begin with aQry do begin if not Active then Exit; Fi... Read More