[Webinar] Streamline your web hosting managementRegister Today

x
?
Solved

Modify SQL

Posted on 2004-10-27
3
Medium Priority
?
165 Views
Last Modified: 2010-04-23
Who can I modify the following SQL and add a parameter to modify the internalprops field so it's not copied directly?

SQL = "INSERT INTO cto_objects  " & _
            "       ( project,iobjname,objname, " & _
            "         objtype,status,path," & _
            "         description,filename,objpath, " & _
            "         internalprops,externalprops,ctoprops ) " & _
            "   SELECT '000000',:newname ,:newExtName, " & _
            "          objtype, status,:newname ||'.IKM', " & _
            "          description,filename,objpath, " & _
            "          internalprops,externalprops,ctoprops " & _
            "    FROM cto_objects " & _
            "    WHERE ( cto_objects.project = :project ) AND " & _
            "          ( cto_objects.iobjname = :iobjname ) "

thx
TOM
0
Comment
Question by:thenrich
2 Comments
 
LVL 5

Author Comment

by:thenrich
ID: 12425668
Found the solution myself:

SQL = "INSERT INTO cto_objects  " & _
                       "       ( project,iobjname,objname, " & _
                       "         objtype,status,path," & _
                       "         description,filename,objpath, " & _
                       "         internalprops,externalprops,ctoprops ) " & _
                       "   SELECT '000000',:newname ,:newExtName, " & _
                       "          objtype, status,:newname ||'.IKM', " & _
                       "          description,filename,objpath, " & _
                       "          replace(internalprops,'|' || :o_seq ||';','|' || :n_seq || ';'),externalprops,ctoprops " & _
                       "    FROM cto_objects " & _
                       "    WHERE ( cto_objects.project = :project ) AND " & _
                       "          ( cto_objects.iobjname = :iobjname ) "

Going to ask for this question to be deleted.
0
 

Accepted Solution

by:
modulo earned 0 total points
ID: 12752411
PAQed with points refunded (500)

modulo
Community Support Moderator
0

Featured Post

Get your problem seen by more experts

Be seen. Boost your question’s priority for more expert views and faster solutions

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Well, all of us have seen the multiple EXCEL.EXE's in task manager that won't die even if you call the .close, .dispose methods. Try this method to kill any excels in memory. You can copy the kill function to create a check function and replace the …
Calculating holidays and working days is a function that is often needed yet it is not one found within the Framework. This article presents one approach to building a working-day calculator for use in .NET.
SQL Database Recovery Software repairs the MDF & NDF Files, corrupted due to hardware related issues or software related errors. Provides preview of recovered database objects and allows saving in either MSSQL, CSV, HTML or XLS format. Ensures recov…
There may be issues when you are trying to access Outlook or send & receive emails or due to Outlook crash which leads to corrupt or damaged PST file. To eliminate the corruption from your PST file, you need to repair the corrupt Outlook PST file. U…

590 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question