ZHEngineer-CSDN博客

原创 Oracle的多个join的区别

1.栏位合并left join、right join、inner join、full joinleft join(左联接)：返回包括左表中的所有记录和右表中联结字段相等的记录 right join(右联接)：返回包括右表中的所有记录和左表中联结字段相等的记录inner join(等值连接)：只返回两个表中联结字段相等的行FULL JOIN ：关键字会从左表 (Person

2013-05-10 16:10:15 603

原创 Record change by another

1.TClientDataSet的Applyupdate提交时，报“Record change by another”的原因之一，客户端字段类型FieldBCD的改成FieldFloat，相应的数据表字段从Integer或Number修改成Float类型； 2.TClientDataSet的IndexFieldNames设置为空，不然保存后记录会跳动；3.TdataSetProvide

2009-12-18 11:51:00 404

原创 1.关联语句inner join on 和 left join on的区别

1.关联语句inner join on 和 left join on的区别inner join on相当于以下语句select a.*,b.* from user a ,UserChannel b where a.UserID=B.UserID 即和select a.*,b.* from user a inner join UserChannel b on a.userid=b.UserID结

2009-12-18 11:43:00 617

ICS & MidWare coding style THIS IS A WORK IN PROGRESS ! 1. Keywords All Delphi keywords are written in lower case except data types. function Demo(const Value : String): String; begin Result := 'This is my demo'; end; 2. Data types Built-in data types are written in lower case except the first letter. See example above. All new data types are created using concatenated words in lower case with each first letter in uppercase with preceding letter ‘T’. If data type is a pointer to something then first letter ‘T’ is replaced by ‘P’. TMyOwnDataRecord = record Street : String; Value : Integer; end; PMyOwnDataRecord = ^TMyOwnDataRecord ;

2018-05-02

空空如也

TA创建的收藏夹 TA关注的收藏夹

TA关注的人

ZHEngineer的专栏

原创 Oracle的多个join的区别

原创 Record change by another

原创 1.关联语句inner join on 和 left join on的区别

OverbyteIcsV7Gold

空空如也