Modify SQL

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
LVL 5
thenrichAsked:
Who is Participating?
 
moduloCommented:
PAQed with points refunded (500)

modulo
Community Support Moderator
0
 
thenrichAuthor Commented:
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
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.