Re: sql command error

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

Ammar S. Mitoori (msnews08@xxxxxxxxxxxxx) writes:
so now if the file path i want to pass it as a parameter depending on
file path selected from a file dialog control how that can be done ? and
can i retrive the file extension from that path selected by the dialog ?
is there a property or function to do so ? can i retrive also just the
path, just the file name without extension ?


I'm afraid that you lost me entirely there. This is a forum for SQL
programming, and now you starting talking about getting file paths from a
dialog. The only dialogs that appear in SQL Server are those in Service
Broker, but it sounds to me that you are talking about a dialog in a GUI.

I think you should ask that question in a forum devoted to the development
environment for your GUI code.

--
Erland Sommarskog, SQL Server MVP, esquel@xxxxxxxxxxxxx

Books Online for SQL Server 2005 at
http://www.microsoft.com/technet/prodtechnol/sql/2005/downloads/books.mspx
Books Online for SQL Server 2000 at
http://www.microsoft.com/sql/prodinfo/previousversions/books.mspx
.

Relevant Pages

  • Re: Backup SQL server from vbs
    ... It might be that embedded space in your file path "M E", ... >>> I have this script to backup SQL Server from a VBScript but am having ... >>> Dim FolderName ...
    (microsoft.public.sqlserver.setup)
  • Re: Uploading image type using TSQL
    ... Keep in mind that the file path is related to the SQL Server ... Books Online for SQL Server 2005 at ...
    (comp.databases.ms-sqlserver)
  • Re: Error from the DTS on scheduled task
    ... you need to check what permissions the SQL Server ... Agent service account has, as jobs will be executed ... You can test the credentials by logging onto the server desktop itself, ...
    (microsoft.public.sqlserver.dts)
  • Re: Guidance
    ... > Since dBase is addressed with a file path, the SQL Server and Agent ... > need to be running under an account that has permissions on the file and ...
    (microsoft.public.sqlserver.clients)
  • RE: Guidance
    ... Since dBase is addressed with a file path, the SQL Server and Agent account ...
    (microsoft.public.sqlserver.clients)