用blob进行存储! 把图片的DD转化成二进制,进行存储就行了 PB有两个专门的SELECTBLOB和UPDATEBLOB可以查询和修改blob类型,例子:int fhblob Emp_id_picfh = FileOpen("c:\emp_100.bmp", StreamMode!)IF fh <> -1 THEN FileRead(fh, emp_id_pic) FileClose(fh) UPDATEBLOB Employee SET emp_pic = :Emp_id_pic WHERE Emp_num = 100 USING Emp_tran ;END IFIF Emptran.SQLNRows > 0 THEN COMMIT USING Emp_tran ;END IF 查询======== Blob Emp_id_picSELECTBLOB Emp_pic INTO :Emp_id_pic FROM Employee WHERE Employee.Emp_Num = 100 USING Emp_tran ;p_1.SetPicture(Emp_id_pic)这样明白了吗?
把图片的DD转化成二进制,进行存储就行了
PB有两个专门的SELECTBLOB和UPDATEBLOB可以查询和修改blob类型,例子:int fhblob Emp_id_picfh = FileOpen("c:\emp_100.bmp", StreamMode!)IF fh <> -1 THEN
FileRead(fh, emp_id_pic)
FileClose(fh)
UPDATEBLOB Employee SET emp_pic = :Emp_id_pic
WHERE Emp_num = 100
USING Emp_tran ;END IFIF Emptran.SQLNRows > 0 THEN
COMMIT USING Emp_tran ;END IF
查询========
Blob Emp_id_picSELECTBLOB Emp_pic
INTO :Emp_id_pic
FROM Employee
WHERE Employee.Emp_Num = 100
USING Emp_tran ;p_1.SetPicture(Emp_id_pic)这样明白了吗?