SQL2000数据库
数据库名drugs
product表(ypid,ypname,sccs,scrq,bzrq)
class表(id,lb)
p_class(xh,ypid,id)
并设置了主键product表(ypid),class表(id)p_class(xh)
外键p_class(ypid,id)
------------------------------------------------------------------------------------------------------------------------------------
工具PB9.0
在DB Profile->ODB ODBC->Utilities->Create ODBC Data Source->文件数据源->SQL Server->数据源名称
rugs.dsn(并设置了路径)->Done
创建到SQL Server新的数据源
名称
rugs.dsn
描述:
服务器
local)
Windows NT验证
更改默认数据库为
rugs
完成(测试连接:成功)
--------------------------------------------------------------------------------------------------------------------------------------
在DB Profile->ODB ODBC->new
Profile Name
rugs
Data Source
rugs
User ID:
Password:
完成 并连接
将以下内容复制到APP的open事件中
// Profile Drugs
SQLCA.DBMS = "ODBC"
SQLCA.AutoCommit = False
SQLCA.DBParm = "ConnectString='DSN=Drugs;UID=;PWD='"
Connect using sqlca;
open(w_main)
---------------------------------------------------------------------------------------------------------------------------------
新建DATAWINDOWS->GRID->SQL SELECT->并指定了product,class,p_class表的ypid,ypnamd,lb,sccs,scrq,bzrq字段->保存为q_pc
数据表d_drug
在这里还可以看到数据
--------------------------------------------------------------------------------------------------------------------------------------
w_main的open事件内容:
dw_1.settransobject(sqlca);
dw_1.retrieve()
dw_1的dataobject设置为d_drug
编译后出现错误:
Data Window Error
select error:SQLSTATE=S0002
[Sybase][ODBC Driver][Adaptive Server Anywhere]Table or view not foud: Table 'class' not found
dw_1数据窗口中只显示字段,无数据
--------------------------------------------------------------------------------------------------------------------------------------
请求解决......谢谢
