Thank you so much for clarifying. Really appreciate the timely response!

Hello, Can we remove a page from a pdf document using C#? I started to look at the

PrintDocument

object part of the

System.Drawing.Printing;

namespace. In a bit of crunch time, please let me know if this is possible before we take this option of the table. thanks a bunch!

Also, I am using Windows authentication for SQL server, and this same user also has access to the share on network.

Hello, I am trying to load a json file from network location into a table on sql server 2016. The domain account has access to both the file on network as well as the database. I keep receiving this message:

Cannot bulk load because the file "\\\loaddata.json" could not be opened. Operating system error code 5(Access is denied.).

In the above error message, does the user not have access to file or to perform the "bulk load" action? Much appreciated!

I have a catch block in the code which catches all exceptions and writes to log file. How can I make it that the program continues processing the good records instead of not processing the entire batch.

Hello - I had records to be processed at a time, and the 4th record had an issue. The entire program failed, not processing the rest of the records which had no issue. How can I can continue the program processing the good records? Thanks!!

Hello - I am constructing an URL to pass for API call. It has a date value in it.

DateTime.Today.AddDays(0).ToString("yyyy-MM-dd")

Is there some way I can pass the (0) dynamically, reading from App.Config file? I tried --

DateTime.Today.AddDays(ConfigurationManager.AppSettings["CompletedDays"].ToString("yyyy-MM-dd")

which errored out and did not work. Any way to do this? Thanks!

Hello All, Is Azure DevOps free for Azure Boards, Azure Repos, Azure Pipeline for small team of 5 users who can collaborate? Thanks!

Hello All, I am tasked with performing researching of moving on-premise .net websites(4 different websites) to cloud. I have to perform comparison of Azure, AWS, Google Cloud Service. Is there any other solutions? What would be the best way to perform this research and document side-by-side pros and cons? Thank you!!

Hello All, Sorry if this is the incorrect area to post question, but how do i set a timer in powershell script, so that when the authentication expires, to reset it again? Many thanks!!

Hello All, I am really stumped at this behavior of SAP Crystal reports 2016 Support pack 2. I have defined the a parameter as a date. When creating the report, the application is changing this date to a string and hence the date selector is not longer visible. But if i keep the parameter as datetime, then the date selector is visible. Our business user only wants a date value, with no time. Has anyone seen this behaviour? Thanks a bunch!

Hi! We are re-writing existing access DB process into Oracle. With that said, we need to calculate averages upon request. The data is loaded everyday through datawarehouse. We would need to store amount value everyday, maybe into another table, and be able to calculate the average upon request? Just have a table listing the key fields in addition to date and amount? with date and amount changing everyday? Is there any other option to do this? If it were SQL server, I could have explored the SSIS packages. Not sure in Oracle. thank you!

Thank you for your reply.

I did the following:

execute immediate ssql;
SELECT ssql FROM DUAL;

I got the following:
[Error] Execution (313: 1): ORA-06550: line 313, column 1:
PLS-00428: an INTO clause is expected in this SELECT statement

Thank you for reply. Is there any other location we can find the log files, other than the event viewer? ==

move files to ScriptsWeb folder

Get-ChildItem -Path "E:\<.myfolder>INT" | Move-Item -Destination "E:\" -force

Hello All, Since past few days, the powershell script is not working, it does a simple thing of moving files from one location to another location within same server. One location on E drive to another location on E drive. I had a look at the event viewer - application logs, for any errors - I also manually copied a file to location, to see if there was any space or permissions issues all of a sudden. Is there any other location I can look for errors? Many thanks!

Hi, I have debugged a stored proc in Sql Server, which was fairly easy to do. I am trying the same with debugging Oracle procedures, being fairly new having some difficulties. I have researched how to output a cursor value, with no luck. Also, the sql is constructed, and then used in cursor to output results to crystal report. My final sql looks like this, which is a whole bunch of variables:

ssql := s_SEL||s_FROM1||s_WHERE||s_WH_PER||s_WH_CC||s_WH_VEN
||s_UNION||
s_SEL||s_FROM2||s_WHERE||s_WH_PER||s_WH_CC||s_WH_VEN

I tried with no luck:

execute immediate ssql

I just want to see the values of the sql statement. Any help is much appreciated!