Comments by Quecumber256 (Top 11 by date)

Thank you.
Can you give me a hint on how to use a similar query where it takes the strPC variable and if it finds a match returns the PCID number?

This worked once when I had a prefilled data table. I cleared the DB table and entered in just one record. Then it started giving me the aforementioned error.

All data is stored in a data set that is loaded from an Access database.

In the beginning PCID was an auto number field, but if both tables are empty then you can't establish relationships between them. For some reason when you add some data into a row that contains an auto number field and save it to the data table contained in the data set the auto number field inside the data set is not incremented. The auto number field will contain a zero. The second column will contain the item I entered. Hence incrementing the ID keys manually.

When the tables are loaded into the data set both are empty. If I add an item to the PC data table it should auto increment to one, but when I look at the information stored in the data set the row returned in 0 PC item. Instead of 1 PC item. Table 2 is related to table 1 using the PCID field. So if there is no ID in table1 in the data set how can I relate it to table 2's PCID field unless I generate them myself.

If I'm following this right. I want to find the last number used in the PCID field. In this case the PCID field is calculated based on the last one in the table. For example: 1 - Item1, 2 - Item2 and so on. If I use the Max() function it would return 2; I add one to that to get the next ID number in the sequence 3.

Yes, it is a long integer. At first I wanted to use an AutoNumber field, but updating the DataSet inside memory and them transferring that information back to the database proved to be more trouble than me incrementing the ID number myself.

SA,
Strange answer: Was the question somehow unclear? I'm proceeding on the assumption that is was.

To clarify: Using the Shell32.dll I read the metadata from: After_the_Storm_23-Jan-2013.docx. Shell32.dll returned the following metadata:

0: Name: After_the_Storm_23-Jan-2013
1: Size: 11.4 KB
2: Item type: Microsoft Office Word Document
3: Date modified: 1/23/2013 4:49 PM
4: Date created: 1/23/2013 4:49 PM
5: Date accessed: 1/23/2013 4:49 PM
6: Attributes: A
7: Offline status:
8: Availability: Available offline
9: Perceived type: Document
10: Owner: MyPCName\User
11: Kind: Document
12: Date taken:
13: Contributing artists:
14: Album:
15: Year:
16: Genre:
17: Conductors:
18: Tags:
19: Rating: Unrated
20: Authors: Unused_Email_Address@someplace.com
21: Title:
22: Subject:
23: Categories:
24: Comments:
25: Copyright:
26: #:

To me this is binary data contained inside the file itself. I want to create an application where I can change the information in tag number 20 from Authors: Unused_Email_Address@someplace.net to Authors: Current_Email_Address@theotherplace.com.

This information is placed inside the file when it is created by the application itself. In this case MS-Word. If the data can be written; it can be modified or changed. My educated guess would be that the writing of metadata would be a function inside the System.IO Namespace, but so far I haven't been able to find any information on how developers can write their own metadata into the files their applications create, or if it is even possible using Microsoft Visual Studio Professional 2008.

Thanks,
MRM