#1
|
|||
|
|||
Issue-Reading a file with vbld_GetFileContents
I need to read the contents of some sql script files one by one and put the content into a separate file.In order to do this I have a step which sets the macro CURR_SQL_SCRIPT_CONTENT to
[vbld_GetFileContents("%PROCFILES_FULLPATH%")] and then I have another step which writes into the target file the macro CURR_SQL_SCRIPT_CONTENT SQL scripts contains brackets like : IF NOT EXISTS (SELECT * FROM [sm].[DefaultSetting] WHERE [ApplicationType] = 1 AND [ValueId] = 111) and I see when reading the SQL file everything inside the brackets is just ignored and therefore is not appearing in the target file. I do not understand what is wrong as in the help it is written vbld_GetFileContents should read everything ok: "vbld_GetFileContents(Filename): Retrieve the contents of a file and double up characters that are treated specially by Visual Build Pro. Bracket characters [ ] and percent sign % characters are normally interpreted by Visual Build Pro as referencing script code and macros within a field. When retrieving the contents of a file into a field, using this function will cause these characters to be treated as literals by VBP. " Any idea how to read everything from SQL script ,including the parts between brackets? |
|
|