I think the reason the image isn't moving over is because I am inserting fake data and have to use NEWID() for the ID field so the Images and ID...

The Left Join did bring over the data from the data table, but did not bring over the image for the image table.

The way I understand it is the INSERTED table is the row of data that has just been added to the original table. it's temporary. The "images" column is the...

Hi,

No, It is ID in one table and Images in the other. (That's how the programmers set it up.)

There is always a [Front Alarm Status]

Thank you both. I got it working!

Thank you, I will try this.

Thank you, that helped.

Hi,

I just tried changing the intervals to 10 milliseconds. It did not change the number of data points, it changed the number of tick marks and labels. 🙁

Thank You I will try this

Thank You for the information mister.magoo.

Do you have a suggestion of how I can accomplish this?

I have the folder with the .avi files in the same directory as the...

Update:

I have moved the .avi files to the same directory as the database.

If I open IE on the SQL Box that the databases are on and enter file///f:/TSD%20Movies/Heat123.avi...

Thank you all for your input.

The link sounds like it might be the way to go.

The dvr is on site (in the customer's network).

The reason I am asking is because our customer has requested to be able to view the movie that is associated with the data in the database. As far as...

You are right, I am using vb.

Thanks