pstockmedicine_init.sql

Delphi6开发的HIS程序

insert into pstockmedicine
(
pstockmedicineid,
samount,
amount,
created,
updated,
medicinestockid,
price,
total
)
select
null,
0,
minamount,
sysdate,
sysdate,
medicinestockid,
0,
null
from
medicinestock
where minamount > 0;