SQL input |
Post Reply | Page 12> |
Author | |
Hamlet
Newbie Joined: 19-November-2005 Location: United States Status: Offline Points: 0 |
Post Options
Thanks(0)
Posted: 16-January-2006 at 8:29pm |
No problem.
|
|
geoff
Newbie Joined: 15-January-2006 Status: Offline Points: 2 |
Post Options
Thanks(0)
|
Hamlet
Could you post back your experience. I would like to know what you experienced. I'll do the same but this isn't something that I specifically am working on currently. |
|
Hamlet
Newbie Joined: 19-November-2005 Location: United States Status: Offline Points: 0 |
Post Options
Thanks(0)
|
Thanks. I will have to give it a try. For me, I really just want to run select statements - but it will be nice to be able to run the others as well. |
|
geoff
Newbie Joined: 15-January-2006 Status: Offline Points: 2 |
Post Options
Thanks(0)
|
Thanks for the quick posted reply
|
|
ProductCart
Admin Group ProductCart Team Joined: 01-October-2003 Status: Offline Points: 135 |
Post Options
Thanks(0)
|
Here is a file that can perform this task. As you know, database changes cannot be undone. Be careful and backup the database! |
|
geoff
Newbie Joined: 15-January-2006 Status: Offline Points: 2 |
Post Options
Thanks(0)
|
I agree with Hamlet.
Having to go outside of Productcart for custom queries is a quiet abstract. Also when the MS SQL is hosted on a shared server, it is a fair amount of trouble to configure Enterprise manager. You have at least two customers who are interested..... |
|
Hamlet
Newbie Joined: 19-November-2005 Location: United States Status: Offline Points: 0 |
Post Options
Thanks(0)
|
You could limit the querys to "select" statements and not allow Create, Update or Insert Statements (or others that you think would be disruptive). |
|
ProductCart
Admin Group ProductCart Team Joined: 01-October-2003 Status: Offline Points: 135 |
Post Options
Thanks(0)
|
There is a big difference between the two. If you run a query directly using MS Access or EM, then you are operating outside ProductCart. In that scenario, ProductCart is clearly not involved, as it is in no way "enabling" you to perform that task. It is something that you are doing at your own risk. |
|
Hamlet
Newbie Joined: 19-November-2005 Location: United States Status: Offline Points: 0 |
Post Options
Thanks(0)
|
I am not sure I understand how using access or EM will have less room for error.
|
|
ProductCart
Admin Group ProductCart Team Joined: 01-October-2003 Status: Offline Points: 135 |
Post Options
Thanks(0)
|
This is something that we have considered, but which we have decided not to add to the system up to this point. The main concern is that it provides too much room for error, and could easily lead to disruptive results if used improperly. For now, we ask you that you use MS Access or a MS SQL tool such as Enterprise Manager to run custom queries.
|
|
Post Reply | Page 12> |
Tweet
|
Forum Jump | Forum Permissions You cannot post new topics in this forum You cannot reply to topics in this forum You cannot delete your posts in this forum You cannot edit your posts in this forum You cannot create polls in this forum You cannot vote in polls in this forum |