I understand RDA.SubmitSQl is for Submitting SQL statements for execution on a database in Microsoft SQL Server on a remote server.
What if I sumbit a Query like this : RDA.SubmitSQL("Select Max(CustID) From CustomerTable");
So can I get this value back to my local client to use?
Please help me out.
Thanks.
James
Hello,
I am using VS 2005, C# and .NCF2.0. I have some questions on rda.submitsql wondering if someone can answer them:
1) I know rda.submitsql cannot return values. How do I know if the statement was executed?
2) Is it possible to submit a table for an update/insert/delete? Unfortunately, I cannot use rda.push.
3) Is it possible to use parameters to update multiple records in a table? If yes, can you please direct me to an example?
I want to limit the connections to IIS. Any guidance would be greatly appreciated.
Thanks!
My application create quite a lot log file to submit to the server under WiFi coverage to monitor the application. (log is just txt file). as time goes on, submitsql method throw OutOfMemoryException. I agree my log file is quite big, 80K each and 6 log files to submit.
My log submitter is an instance object. I also tried static object but it doesn't help either.
I do dispose my rda object when it is out.
Is any way I can fix this?