لوحة القادة

السلام عليكم..... أخي أيمن ...لا شكر على واجب..و إن شاء الله تبقى الإفادة قائمة على الدوام. To get the file name do this : DECLARE X NUMBER(3); V_FILE_NAME VARCHAR2(250); begin X := INSTR(V_FILE_PATH,'\',-1,1); --SEARCH THE POSITION OF THE LAST (\) V_FILE_NAME := SUBSTR(V_FILE_PATH,X+1); --FILE NAME WITH EXTENTION END; good luck !

السلام عليكم..... It's ok aiman..i put this fmb as an example on the code to make a sample folder named final..so you will not put it's default value..as i said before,, you will send the folder name(which is the id of the record) as an argument when you call the procedure COPY_SELECTED_FILE(V_FILE_PATH,:TARGET,:id); then you will put the procedure code as i wrote before : procedure copy_selected_file(p_file_path varchar2, p_target varchar2, p_sub_foder varchar2) is Batch_File_Name VARCHAR2(1024) := 'C:\AMMAR.BAT'; File_ID TEXT_IO.FILE_TYPE; BEGIN file_name:= GET_FILE_NAME(FILE_FILTER=> 'ALL_FILES (*.*)|*.*|'); FILE_ID := TEXT_IO.FOPEN(BATCH_FILE_NAME,'W'); TEXT_IO.PUT_LINE(FILE_ID,'CD "'||P_TARGET||'" '||CHR(10)|| 'MD "'||P_TARGET||'\'||P_SUB_FOLDER||'"'||CHR(10)|| 'COPY "'||P_FILE_PATH||'" '||'"'||TARGET||'\'||P_SUB_FOLDER||'" /y'); TEXT_IO.FCLOSE(File_ID); HOST(Batch_File_Name); END; GOOD LUCK :

السلام عليكم... You have just to modify the procedure like this: PROCEDURE COPY_SELECTED_FILE(P_FILE_PATH VARCHAR2, P_TARGET VARCHAR2, P_SUB_FOLDER VARCHAR2) IS Batch_File_Name VARCHAR2(1024) := 'C:\AMMAR.BAT'; File_ID TEXT_IO.FILE_TYPE; BEGIN FILE_ID := TEXT_IO.FOPEN(BATCH_FILE_NAME,'W'); TEXT_IO.PUT_LINE(FILE_ID,'CD "'||TARGET||'" '||CHR(10)|| 'MD "'||TARGET||'\'||SUB_FOLDER||'"'||CHR(10)|| 'COPY "'||FILE_NAME ||'" '||TARGET||'\'||SUB_FOLDER||' /y'); TEXT_IO.FCLOSE(File_ID); HOST(Batch_File_Name); END; --This will copy your file to the new sub_folder which will be created --automatically ! --Note : You can do this more professionally by making the sub_folder name equals to the (id) of the data block record of your form. so...when you call the procedure from when-button-pressed you call it like this : COPY_SELECTED_FILE(V_FILE_PATH,:TARGET,:id); example : the id of your record is 123 . then all your files that you have selected will be in afolder named 123 ! good luck !