Jump to content


Makeing change to the "SQL" in a stored procedure


  • Please log in to reply
2 replies to this topic

#1 Guest_jaalfaro_*

Guest_jaalfaro_*
  • Guests

Posted 28 December 2006 - 09:33 AM

We're making some changes to the scripts that generate code to automatically encrypt certain data. However, we are having a problem getting to the sql query code from a query. In the code, you seem to call a function to get the code

CREATE PROCEDURE <%=bulkOp.SpName%>
<%
sql = bulkOp.SQL(false, true);for (var k=0; k<bulkOp.Parameters.Count; k++) [/B]
{
bulkOpAttr = bulkOp.Parameters.Item(k);

I can't seem to find anywhere to alter how this is generated. Is this code coming from somewhere else, like not in the scripts? How can I go about doing this.

Essentially, we are putting a suffix on a column to indicate if its encrypted and if so we do things like strip the suffix from the name in the generated code and add some additional functionality to setup the encrytion. Right now, I'm unable to find away to alter the text in the select string. Thanks.

#2 Guest_jaalfaro_*

Guest_jaalfaro_*
  • Guests

Posted 24 January 2007 - 01:15 PM

Any ideas?

#3 Guest_Paul_*

Guest_Paul_*
  • Guests

Posted 26 January 2007 - 04:20 AM

Please send me your modified script at support@alachisoft.com

or

Reply script text on this fourm.




0 user(s) are reading this topic

0 members, 0 guests, 0 anonymous users