Want to win a PS4? Go Premium and enter to win our High-Tech Treats giveaway. Enter to Win

x
?
Solved

Modify SQL

Posted on 2004-10-27
3
Medium Priority
?
164 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
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
3 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

Ask an Anonymous Question!

Don't feel intimidated by what you don't know. Ask your question anonymously. It's easy! Learn more and upgrade.

Question has a verified solution.

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

I think the Typed DataTable and Typed DataSet are very good options when working with data, but I don't like auto-generated code. First, I create an Abstract Class for my DataTables Common Code.  This class Inherits from DataTable. Also, it can …
It’s quite interesting for me as I worked with Excel using vb.net for some time. Here are some topics which I know want to share with others whom this might help. First of all if you are working with Excel then you need to Download the Following …
Are you ready to place your question in front of subject-matter experts for more timely responses? With the release of Priority Question, Premium Members, Team Accounts and Qualified Experts can now identify the emergent level of their issue, signal…
Is your data getting by on basic protection measures? In today’s climate of debilitating malware and ransomware—like WannaCry—that may not be enough. You need to establish more than basics, like a recovery plan that protects both data and endpoints.…
Suggested Courses

636 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