Search results for query: *

Hello All, I have an application where I am fed some data by some equipment and log this data to a table. One of my inputs is a unique number which allows me to identify a record, but it is not a primary key because under certain circumstances my input may be a constant = '?????'. So I may get...

Hello all, I have a query that I am working on and I need to add another field to it, but I am unsure how to do it. Here is my current working query. I need to add in a count of CartonID's where the CartonID = '?????????'. Any ideas how to do this? SELECT ContNum, DoorNum...

I have a table with two columns one is the date and one is the time so for example one records date might be '06/20/08' and its time might be '08:52:32:140'. I need a stored procedure to return back the counts of another field where the date and time is later than some date/time input parameter...

Hi All, I have two questions, but that are somewhat related. First one is more important. I have to write a stored procedure that is overall pretty simple, but I am just not sure the best way to do it. I originally wrote one and it seemed to work, but I figured there was a better and/or more...

Hi all, I have a question about whats the best way to keep track of a records number. I am probably going to phrase this poorly, so thanks for sticking with me. Lets say I have 5 records. I insert them to a table and one of the columns in my table is a record number, so values in this case...

Hey all, I have this Stored Procedure that works well but for some reason the first @@RowCount does not seem to work. Instead of giving me @Reject, '03' , and '000' it gives me all nulls when I search for a UCC_bc that does not exist in UCC. The other RowCounts work fine, but I can not see what...

Hey all, I am new to doing if then else's in SQL and I am having a tough time. The Errors I am receiving are the following: Msg 156, Level 15, State 1, Procedure Lane_Destination_R2, Line 72 Incorrect syntax near the keyword 'THEN'. Msg 102, Level 15, State 1, Procedure Lane_Destination_R2...

Hi all, I have a program that is supposed to log data to a sql table based on a serial port receiving data. When I get a start of text and return I call this routine below. I set some other parameters up previously by a button click, as shown even lower. The problem I am having is that when I...

Hi all, I have a requirement where I get a time in "HH:MM AM/PM" format so for example I might get three times of "11:55 AM" , "12:39 AM" and "1:05 PM" sent over to me. I have to log this to a table and sort it in descending order. The problem is that the "1:05 PM" is then placed below the...

Hi all, Does anyone have a good example or guide that shows how to programmably fill a datagridview? I have always used the wizard, but now I have a requirement to use a datagridview to view data in varying tables. If anyone has anything on this I would appreciate it. It seems that there is...

Hi all, I was wondering how I could create a new table in SQL using a stored procedure. I have a program that needs to create a new table based on a number so for instance I would like to have TableName be a variable which I could enter Table_123 as the name. My problem is that, I can not get...

This is probably simple. I want to write a text file everytime I throw an exception for a few different subroutines. In this text file I would like to record what routine threw the exception, how can I do this? For example here is a function I want to use: Public Shared Sub LogTxtError(ByVal...

Hey all, I know typically this site is best used when some piece of existing code is not working properly and you can correct it, but I have more of a conceptual problem I guess. I have a requirement to add some additional functionality to an existing system where we will generate a report...

I have an application where a program sends some data out a socket to a barcode printer. It works fine until they kill the power to the printer. After this happens I can not seem to reconnect automatically. How would I know that they have turned the power off or how can it automatically...

I have a requirment to read in data from a serial port. This seems to be a pretty standard thing but for some reason I do not seem to get any data from the serial port. I placed a break on the SetText(myserialport.ReadExisting()) line but when the device sends data it doesnt seem to see...

I have a program that I did not write but all of a sudden it is giving a run-time error when we try to load. This program has run for about 7 years without issue. Today I have a run time error "'-2147024882 (8007000e)' System Error &H80004005 (-2147467259). Unspecified error" I added some error...

Hey all, I have a form that looks at a folder and takes text files in and parses them. The parse is simple. On the form load I have to make sure the folder is empty and take any files that might be in there. I then move them to an archive directory. However, I get an error when I try to move...

I have a subroutine in my program that takes data in from a PLC and parses it. The first piece of data I get is a barcode from a scanner. If the scanner can not read the barcode it will send me a "?". When I see this I open a new form , a dialog, called Noreadbox which waits for a user to...

Hi all, I have a datagridview with 4 columns. The first column is barcode and I have a button and a textbox. I would like to have a user enter a barcode and on the button click highlight that row. Is the filter the best thing to use in this situation? I have seen a few people write code to...

I have a requirement for a project to take text files from a specific folder and load that data into a sql table then move that file to an archive folder. I do not know what the file name is going to be but I know the data inside will be in the format "Barcode|Carrier". The people delivering...