QTP与数据库

David_D_Liu

运行一个脚本案例之前必须运行一个数据库脚本（不仅SQL语句，而是一个SQL脚本文件）来准备测试数据，请问能够将运行这个SQL脚本文件也写进我的测试脚本里吗？让每次执行案例之前都自动化执行SQL脚本文件，如何实现？

多谢指教。

Hunter

同样期待ing

风过无息

QTP可以实现DOS下的一些操作,可以实现楼主的功能.,论坛里的.楼主先找找看.

Jor

将SQL脚本写成QTP的脚本，做成一个qfl，每次都先运行一下 行么？

gp_jl

建议先用VB写个执行sql脚本的函数，命名为 x.vbs，然后再你需要执行这个脚本的用例中加入：
ExecuteFile "e：\x.vbs"

caodongjian

楼上的方法.好像可能.以前看过.但没做过

joseph_wh

5 楼的方法是最方便的。

joseph_wh

Description
Executes the VBScript statements in the specified file. Once the file runs, the definitions (functions, subroutines, classes, etc.) in the file are available from the global scope of the action's script.

Note: You cannot debug a file that is called using an ExecuteFile statement, or any of the functions contained in the file. In addition, when debugging a test that contains an ExecuteFile statement, the execution marker may not be correctly displayed.

Syntax
ExecuteFile File

Example
The following example executes the MyFunction VBS file in order to use the SomeFunction function in the action script.

ExecuteFile "MyFunctions.vbs"

x = SomeFunction ' Defined in MyFunctions.vbs

gy21st

Dim oShell
Set oShell = WScript.CreateObject ("WSCript.shell")
oShell.run "sql脚本文件"
Set oShell = Nothing

hellen_ma

study

danmy

跟你的数据库有关，sqlserver就运行 isql，oracle就运行sqlplus

xiaofei0604

学习  学习

暗涧幽火

哦，有没有资料啊？

mstiunicon

原帖由 gy21st 于 2007-12-12 21:35 发表
Dim oShell
Set oShell = WScript.CreateObject ("WSCript.shell")
oShell.run "sql脚本文件"
Set oShell = Nothing

应该是这样写的呢

想飞的猪儿

无从下手