数据库检查点的插入有2种方式,以默认方式(createquery using Microsoft Query)为例进行说明。
1 选择要插入数据库检查点的位置,然后
[1]Insert >checpoint>Database checkpoint >打开Database Query Wizard对话框(图1);
![](http://bbs.51testing.com/images/default/attachimg.gif)
![](http://bbs.51testing.com/attachments/ext_jpg/20070611_2cadaba125d1583019afDlGNWtxs0PYm.jpg)
图2
[2]点击Next >弹出使用Microsoft Query 的步骤(图2),点击OK button,弹出choose Data Source的对话框,图3
![](http://bbs.51testing.com/images/default/attachimg.gif)
![](http://bbs.51testing.com/attachments/ext_jpg/20070611_23549c578fcfe8de949dZ7yAB31UMKOI.jpg)
2 创建要检查的数据库
[1] 选择New Data Source功能,点击"OK";
[2] 弹出Create New Data Source的对话框,依次输入数据库的名字,选择数据库类型,点击“Connect ”
按钮,打开SQL_Sever Login对话框,选择数据库服务器的名称, 图4;
![](http://bbs.51testing.com/images/default/attachimg.gif)
![](http://bbs.51testing.com/attachments/ext_jpg/20070611_b552fb577253102d0685y4YyXV3XIp5J.jpg)
图4
点击Options按钮(图5_0) ,选择数据库 ;
![](http://bbs.51testing.com/images/default/attachimg.gif)
![](http://bbs.51testing.com/attachments/ext_jpg/20070612_f7100df3379a213bc616GAbt4nYgG2jF.jpg)
图5_0
[3] 选择所要检查数据库的表的名称 (图5_0 ),其他为默认值,点击OK 按钮;
[4] 点击OK 按钮,即可完成对Data source 的创建;
注:如果data source中已经有所需要的数据库,则直接选择即可,无需创建;
3选择需要检查的字段(图5) ,选择后点击Next按钮;
![](http://bbs.51testing.com/images/default/attachimg.gif)
![](http://bbs.51testing.com/attachments/ext_jpg/20070611_d8b78c9ba7aa9f5bc7f6X6yD1OcjWHXd.jpg)
图5
4 在所选的字段中,根据需要创建筛选(图6_1)和排序(图6_2);
![](http://bbs.51testing.com/images/default/attachimg.gif)
![](http://bbs.51testing.com/attachments/ext_jpg/20070611_54c51d67436b53e4fb7fWDHPCGddb3iL.jpg)
图6_1 创建筛选
![](http://bbs.51testing.com/images/default/attachimg.gif)
![](http://bbs.51testing.com/attachments/ext_jpg/20070611_9277f2bc79b644dc8f22Yd8m0uFe2198.jpg)
图6_2创建排序
5 点击“finish”按钮(图7),关闭Microsoft Query,返回到QTP检查点属性对话框(图8)
![](http://bbs.51testing.com/images/default/attachimg.gif)
![](http://bbs.51testing.com/attachments/ext_jpg/20070611_06a5fd856c1baefa8f2ffK7Dw4mt3oRM.jpg)
图7
![](http://bbs.51testing.com/images/default/attachimg.gif)
![](http://bbs.51testing.com/attachments/ext_jpg/20070611_2eb6680b507b8113664bTx8hYqmHDUjm.jpg)
图8
从而完成对数据库检查点的插入。