Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
kidjake28
Starting Member
3 Posts |
 Posted - 2010-02-25 : 20:35:50
|
| I'm kind of new but here is my question nontheless:I would like to check if a file exists in SQL using Delphi. Is this possible.I know delphi has this function however I need to check it from a remote sql server.any help appreciated. |
|
|
khtan
In (Som, Ni, Yak)
17689 Posts |
Posted - 2010-02-25 : 20:40:08
|
what do you mean "a file exists in SQL" ?Your question is on Delphi rather than on SQL Server. You will get better answer by posting it over at a Delphi forum.
KH[spoiler]Time is always against us[/spoiler] |
 |
|
|
kidjake28
Starting Member
3 Posts |
Posted - 2010-02-25 : 20:45:22
|
| Well it's not really a delphi question, I think? Let me explain.I want to check to see if an image that is located on the sql server which is remotely located exists. If it does I want sql to import it into the database as a blob. |
|
|
|
khtan
In (Som, Ni, Yak)
17689 Posts |
Posted - 2010-02-25 : 20:56:29
|
you mean the file is located on the same physical server as the SQL Server ?You can use xp_cmdshell and execute a command DIR examplexp_cmdshell 'DIR C:\somefile.ext' and parse the result return
KH[spoiler]Time is always against us[/spoiler] |
|
|
|
kidjake28
Starting Member
3 Posts |
Posted - 2010-02-25 : 22:07:56
|
| Thank you. |
|
|
|
|
|
|
Delph->SQL->FILEEXISTS