-
Recent Posts
Recent Comments
Archives
Categories
Meta
Author Archives: admin10
Syspro Scripting
I have a customer that I track the production of every Stock Code that is processed through the Production Floor. This is done outside of Syspro via a custom program. The issue they have run into is that Syspro users … Continue reading
Posted in Uncategorized
Comments Off
SQL Server – Output comes in handy
I was looking for a single query that will snag a field, update it and return the new value. I stumbled across the OUTPUT clause. Dim Sql As String = “Update ArControl Set NextCustomer = Right(’0000000′ + CONVERT(VARCHAR,NextCustomer + 1),7) … Continue reading
Posted in Uncategorized
Comments Off
SQL Age Calculation
FLOOR(DATEDIFF(day,DOB,GETDATE())/365.242199)
Posted in Uncategorized
Comments Off
VB.NET and PDF files
We had a project that required reading data from within the contents of a PDF file. After some research we found ABCpdf from webSupergoo that works as advertised. (HS-PDFWatcher)
Posted in Uncategorized
Comments Off
VB.NET and FTP
I wrote a routine to download some ASCII files from a host IBM AS400 via FTP. I used a wrapper class for .NET 2.0 FTP. I will have to check to see if .NET 4 has a better implementation for FTP. … Continue reading