ok im trying to do a script that will put a number out of a reg file and insert it and build a sql script.
will i got all that figured out but my problem is the sql script needs to have blank lines in it
heres my script
MarkID.bat
_________________________________________
C:\\tools\\BuildRegFromTemplate.exe c:\\tools\\OfficeID.dat c:\\tools\\Siteid.txt
findstr \"SITEID\" c:\\tools\\siteid.txt > c:\\tools\\siteid2.txt
c:\\tools\\cut -c11-13 c:\\tools\\siteid2.txt > c:\\tools\\StoreNum.txt
del c:\\tools\\siteid.txt /q
del c:\\tools\\siteid2.txt /q
set /P storeid=<c:\\tools\\StoreNum.txt
FOR /f %%i in (\"%storeid%\") do set storeid=%%i
del c:\\temp\\storenum.txt
Echo INSERT INTO EMPLOYEE >> c:\\office\\db\\upgs\\upg.000
(EMPNO,HIREDATE,PROFILE,JOBCLASS,FULLNAME,POSACCESS,ACCOUNT_ID,STATUS,TEL1,SOCIALSEC,EXTERNAL_CODE,SITE_ID,ADDITIONALINCOME,ISBELONGTOHOST,ISSENDTOHOST,USERNAME,POSPASSWORD,EMPINITIALS,EMPCOLOR_RGB) >> c:\\office\\db\\upgs\\upg.000
Echo VALUES >> c:\\office\\db\\upgs\\upg.000
Echo (50,'08/07/2009',1,61300,'Marketing',1,0,'F','(432)580-8850',999988777,50,%storeid%,'F','F','F',50,9876,'Mar',0) >> c:\\office\\db\\upgs\\upg.000
Echo INSERT INTO EMPLOYEEJOB >> c:\\office\\db\\upgs\\upg.000
Echo (EMPLOYEE_ID,JOBCLASS_ID,HOUR_COST,JOB_STATUS) >> c:\\office\\db\\upgs\\upg.000
Echo VALUES >> c:\\office\\db\\upgs\\upg.000
Echo (50,61300,0,'E') >> c:\\office\\db\\upgs\\upg.000
Echo INSERT INTO EMPSITE >> c:\\office\\db\\upgs\\upg.000
Echo (EMP_ID,SITE_ID) >> c:\\office\\db\\upgs\\upg.000
Echo VALUES >> c:\\office\\db\\upgs\\upg.000
Echo (50,%storeid%) >> c:\\office\\db\\upgs\\upg.000
Echo INSERT INTO USERMENU >> c:\\office\\db\\upgs\\upg.000
Echo (USERID,MENUID) >> c:\\office\\db\\upgs\\upg.000
Echo VALUES >> c:\\office\\db\\upgs\\upg.000
Echo (50,2) >> c:\\office\\db\\upgs\\upg.000
Echo $$RUN UTIL_EncryptEmpPasswords$$ >> c:\\office\\db\\upgs\\upg.000
Call c:\\office\\exe\\dbupgrader.exe
___________________________________________________
ok that part works good but the problem im having is when it makes the upg.000 file it makes it like this.
__________________________________________________
INSERT INTO EMPLOYEE
(EMPNO,HIREDATE,PROFILE,JOBCLASS,FULLNAME,POSACCESS,ACCOUNT_ID,STATUS,TEL1,SOCIALSEC,EXTERNAL_CODE,SITE_ID,ADDITIONALINCOME,ISBELONGTOHOST,ISSENDTOHOST,USERNAME,POSPASSWORD,EMPINITIALS,EMPCOLOR_RGB)
VALUES
(50,'08/07/2009',1,61300,'Marketing',1,0,'F','(432)580-8850',999988777,50,218,'F','F','F',50,9876,'Mar',0)
INSERT INTO EMPLOYEEJOB
(EMPLOYEE_ID,JOBCLASS_ID,HOUR_COST,JOB_STATUS)
VALUES
(50,61300,0,'E')
INSERT INTO EMPSITE
(EMP_ID,SITE_ID)
VALUES
(50,218)
INSERT INTO USERMENU
(USERID,MENUID)
VALUES
(50,2)
$$RUN UTIL_EncryptEmpPasswords$$
___________________________________________________
The problem there needs to be a blank line before eatch INSERT command or it thinks its one script when its really 5 seperate scrips its needs to look like this.
___________________________________________________
INSERT INTO EMPLOYEE
(EMPNO,HIREDATE,PROFILE,JOBCLASS,FULLNAME,POSACCESS,ACCOUNT_ID,STATUS,TEL1,SOCIALSEC,EXTERNAL_CODE,SITE_ID,ADDITIONALINCOME,ISBELONGTOHOST,ISSENDTOHOST,USERNAME,POSPASSWORD,EMPINITIALS,EMPCOLOR_RGB)
VALUES
(50,'08/07/2009',1,61300,'Marketing',1,0,'F','(432)580-8850',999988777,50,218,'F','F','F',50,9876,'Mar',0)
INSERT INTO EMPLOYEEJOB
(EMPLOYEE_ID,JOBCLASS_ID,HOUR_COST,JOB_STATUS)
VALUES
(50,61300,0,'E')
INSERT INTO EMPSITE
(EMP_ID,SITE_ID)
VALUES
(50,218)
INSERT INTO USERMENU
(USERID,MENUID)
VALUES
(50,2)
$$RUN UTIL_EncryptEmpPasswords$$
____________________________________________________
is there a way to add the blank lines in? please please help this one has me stuck.
