how ya . . . . ???
hi. . . i ve a bored day for my couple days. . . .
it needs so many days that make me rehealt and refresh. . . and you know what??
>>postek /c 168 200DPI<< makes me head-ache
this printer always scrolls long and after printing has done, and thatalways blinks
i ve to:
*turn off the print.
*scroll barcode paper back
*and turn on again
and the whorse is, it always backs
but in my imagine i can do combine my barcode printer postek /c 168 200DPI with developer 6i
and the idea is:
*first, you build generate data to text
*and then you open it (text data generated) with postlable 0.7 software
*open and connecting text data with postlable 0.7 software
*and done!!! you can printing barcode through postlable 0.7 software easly
follow the step by step :
i imagine that your PC has installed postlable 0.7 software .
1. create procedure in developer 6i to generate your data to text file
PROCEDURE conf_to_text_product IS
OUT_FILE TEXT_IO.FILE_TYPE;
ITEM VARCHAR2(1000);
image_path VARCHAR2(200);
image_extension VARCHAR2(3);
tittle varchar2(100);
intname varchar2(100);
intaddress varchar2(100);
intcity varchar2(100);
intphone1 varchar2(100);
intphone2 varchar2(100);
intfax varchar2(100);
bulan varchar2(100);
stotal number(15);
AppID PLS_INTEGER;pathfilename varchar2(1000);
pathfilenamebarcode varchar2(1000);
cursor c is select product_id,product_name,supp_id,a.cat_id,cat_desc,cost_price,sales_price
from immst_products a,immst_catproducts b
where a.cat_id=b.cat_id
and product_id=:immst_products.product_id
order by product_id;
c_rec c%rowtype;begin
pathfilename:=’C:\data.csv’;
pathfilenamebarcode:=’c:\barcodq.pld’;
OUT_FILE := TEXT_IO.FOPEN(pathfilename,’W’);
ITEM :=’kode,nama barang,kodeQ,kode categori,categori,harga beli,harga jual’;
TEXT_IO.PUT(OUT_FILE,ITEM);
TEXT_IO.NEW_LINE(OUT_FILE,1);open c;
loop
fetch c into c_rec;
exit when c%notfound;ITEM :=’*’||c_rec.product_id||’*’||’,’||c_rec.product_name||’,’||c_rec.supp_id||’,’||c_rec.cat_id||’, ‘||c_rec.cat_desc||’,’||nvl(c_rec.cost_price,0)||’,’||nvl(c_rec.sales_price,0);
TEXT_IO.PUT(OUT_FILE,ITEM);
TEXT_IO.NEW_LINE(OUT_FILE,1);
end loop;TEXT_IO.FCLOSE(OUT_FILE);
AppID := DDE.App_Begin(‘C:\Program Files\PosLabel\PosLabel.exe ‘ ||pathfilenamebarcode,DDE.APP_MODE_MAXIMIZED);
END;
2. place the procedure in when-buton-pressed trigger or anything else trigger that you easly to make
note :
i ve table on my oracle DB
IMMST_PRODUCTS
product_id varchar2(100)
product_name varchar2(100)
supp_id varchar2(10)
cat_id varchar2(10)
cat_desc varchar2(10)
cost_price number(15,2)
sales_price number(15,2)
when i pressed my button, it ll generate data from my product table 2 text, it ll call PosLabel 7 and open barcodq.pld file
and you can print your barcode file through PosLabel 7 software.
any think you need. download here
ice cream gear 