hello all,
i have nav 5 sql database attached to server i need to design .net application that can execute some sql select query
only select query (no insert or update or delete)
i need to know this application can cause any problem in the database ?
thanks
No, it will not cause any problems. Remember that the users of this application should technically be licensed under, I think it’s called DCO now. It’s essentially a NAV user that doesn’t use the NAV client directly.
Without knowing what is retrieved from the database, at what times, at what frequencies, there is no way to say whether it will cause problems. From a data point of view maybe, but select queries can definitely cause performance problems if they interfere with daily processing.
thank you very much matt & den ster