#1
  1. No Profile Picture
    Junior Member
    Devshed Newbie (0 - 499 posts)

    Join Date
    Sep 2003
    Posts
    3
    Rep Power
    0

    Question How to get CONNECTED users info?


    How can I get connected users info (name ...) width delphi in Firebird 1.5 RC5
  2. #2
  3. Bug Hunter
    Devshed Newbie (0 - 499 posts)

    Join Date
    May 2003
    Location
    Transylvania (Romania)
    Posts
    309
    Rep Power
    24

    Re: How to get CONNECTED users info?


    Originally posted by CsoTor
    How can I get connected users info (name ...) width delphi in Firebird 1.5 RC5
    Here is an article

    http://community.borland.com/article...,29889,00.html

    Also there is a c example only for it

    http://www.ibphoenix.com/main.nfs?a=...='279'
    My home page: http://www.firebirdsql.org and work place :http://www.reea.net
  4. #3
  5. Bug Hunter
    Devshed Newbie (0 - 499 posts)

    Join Date
    May 2003
    Location
    Transylvania (Romania)
    Posts
    309
    Rep Power
    24
    An example how to use the TIBDatabaseInfo but of course you have to read UserNames property (TStringList)
    to retrieve the dialect of the database you need to use the TIBDatabaseInfo component. This component has a property, DBSQLDialect, that you can access to retrieve the connected database's dialect. Here is a code example that retrieves the connects to a database and retrieves its dialect for display.

    // set database to connect to
    ibdatabase1.DatabaseName := 'employee.gdb';

    // connect to database
    ibdatabase1.Connected := true;

    // retrieve database dialect and display in edit box
    Edit1.Text := IntToStr(ibdatabaseinfo1.DBSQLDialect);
    http://bdn.borland.com/article/0,141...IBDatabaseInfo
  6. #4
  7. No Profile Picture
    Junior Member
    Devshed Newbie (0 - 499 posts)

    Join Date
    Sep 2003
    Posts
    3
    Rep Power
    0
    Thanx

IMN logo majestic logo threadwatch logo seochat tools logo