TRANSFORM first(FieldValue)
SELECT ContactID
FROM [SELECT a.FieldName, b.ContactID, b.FieldID, b.FieldValue
FROM CustomField AS a, ContactFieldValue AS b
WHERE a.RecordID = b.FieldID]. AS TmpTable
GROUP BY ContactID
PIVOT FieldName;
视图名: V_CustomValue
请问 这个视图如何动态创建啊?谢谢!http://topic.csdn.net/u/20090730/16/ad9866a9-29dd-46a1-874b-767f5b413a93.html 同
SELECT ContactID
FROM [SELECT a.FieldName, b.ContactID, b.FieldID, b.FieldValue
FROM CustomField AS a, ContactFieldValue AS b
WHERE a.RecordID = b.FieldID]. AS TmpTable
GROUP BY ContactID
PIVOT FieldName;
视图名: V_CustomValue
请问 这个视图如何动态创建啊?谢谢!http://topic.csdn.net/u/20090730/16/ad9866a9-29dd-46a1-874b-767f5b413a93.html 同
解决方案 »
- EXE 中增加数据----RAR自解压
- 实现B/S架构的小型企业管理系统
- 记录类型文件里写入Ticon类型问题,散分.
- 为什么用XP.Style.v2.6.0.1.FS.For.D3-7做出界面后,菜单不能显示?
- 怎样在ListVire中对选中项进行向上,向下移动?
- 很菜的问题:在Delphi6的情况下怎么用Rave做报表?
- DBGRID中显示的列多于数据集的列,请高手帮忙解决(100分)
- 请问那里有做类似CAD功能的插件或源代码呀?我在线等待,你要多少分我尽量满足!!!急!!!!!!!!!
- 在Delphi中怎样取到指定时间的分钟和系统时间的分钟数相同?
- query的结果,可以用recordcount得到,存储过程的结果怎么得到??//牛虻
- 求关于球面运动的物体碰撞的检测思路
- 求补丁d5adoupdate2.exe,网上联接都失效了,多谢大家
http://www.google.cn/codesearch/p?hl=zh-CN&sa=N&cd=7&ct=rc#GnrWj4uf5gs/ImportAccess.pas&q=file:.pas$%20CreateQueryDef&l=453 procedure TForm1.Button3Click(Sender: TObject);
const
dbUseJet = $00000002;
var
connection: OleVariant;
DBEngine : OleVariant;
DataBase : OleVariant;
QueryDef : OleVariant;
accessfile: string;
sql: string;
begin
accessfile := 'x:\db1.mdb'; connection := CreateOleObject('Access.Application');
DBEngine := connection.DBEngine;
DBEngine.DefaultType := DBUseJet;
DataBase := DBEngine.OpenDatabase(accessfile);
sql := ' TRANSFORM first(FieldValue) '
+ ' SELECT ContactID FROM [SELECT a.FieldName, b.ContactID, b.FieldID, '
+ ' b.FieldValue FROM CustomField AS a, ContactFieldValue AS b WHERE '
+ ' a.RecordID = b.FieldID]. AS TmpTable GROUP BY ContactID PIVOT FieldName';
QueryDef := Database.CreateQueryDef('V_CustomValue',sql);
connection.Close();
end;