I want to add the path and file name of PDF files to a SQL DB record. The file will be available for viewing when the record is looked up. I don't need the file itself in the database, just the path to the file and the filename. I just need some sample scripts on how to get the path and file name and apply that info into the database field called PathFile. The database name, if it matters, is Donors.
How do I get path and file name into a MS SQL Server DB field?
If you can't tell I am a complete novice at this. Keep it basic if you can.
Thanks in advance for you assistance.