How do I include the ROLE in IBDatabase
lazarus / 16-Databases

----------------------------------------------------------------------
RedOctober · 2018-02-09 18:33

Platform:  Laz 1.8.1  Fpc 3.0.5, IBX 2.1.0  on Windows Server
Essentials 2016

Simplest question on the internet... most difficult to find answer or
confirmation...

I need to include the role in my TIBDatabase login, but there is no
property for that.  Is it simply a case of including it in the
parameters, like so...
Code: Pascal  [Select][+][-]window.onload = function(){var x1 =
document.getElementById("main_content_section"); if (x1) { var x =
document.getElementsByClassName("geshi");for (var i = 0; i ... fb_db:
TIBDatabase...    fb_db.Params.Add('USER_NAME=' + usr_nm); 
 fb_db.Params.Add('PASSWORD=' + pwd_txt);   fb_db.Params.Add('ROLE=' +
role);...

----------------------------------------------------------------------
taazz · 2018-02-09 19:05

Quote from: RedOctober on February 09, 2018, 07:33:59 pm Platform: 
Laz 1.8.1  Fpc 3.0.5, IBX 2.1.0  on Windows Server Essentials 2016

Simplest question on the internet... most difficult to find answer or
confirmation...

I need to include the role in my TIBDatabase login, but there is no
property for that.  Is it simply a case of including it in the
parameters, like so...
Code: Pascal  [Select][+][-]window.onload = function(){var x1 =
document.getElementById("main_content_section"); if (x1) { var x =
document.getElementsByClassName("geshi");for (var i = 0; i ... fb_db:
TIBDatabase...    fb_db.Params.Add('USER_NAME=' + usr_nm); 
 fb_db.Params.Add('PASSWORD=' + pwd_txt);   fb_db.Params.Add('ROLE=' +
role);... 
Code: Pascal  [Select][+][-]window.onload = function(){var x1 =
document.getElementById("main_content_section"); if (x1) { var x =
document.getElementsByClassName("geshi");for (var i = 0; i  
fb_db.Params.Add('sql_role_name=' + role);

----------------------------------------------------------------------
RedOctober · 2018-02-09 19:27

Thanks taazz.  Is there a convention or Firebird requirement for lower
case parameter names?

----------------------------------------------------------------------
taazz · 2018-02-09 22:48

Quote from: RedOctober on February 09, 2018, 08:27:13 pmThanks taazz. 
Is there a convention or Firebird requirement for lower case parameter
names?
I have no idea, it depends on the underline library I guess, for
example the IBX4Lazarus library will lowercase the parameter name 
before searching for its isc_dpb_xxxxxx constant, which makes your
input, case agnostic, you can use camel, lower, upper or what ever
case you like.

----------------------------------------------------------------------
tonyw · 2018-02-12 16:02

The easiest way to set the role name in IBX is to double click on the
TIBDatabase component. This brings up the Database Editor and this
allows you to set common parameters such as the character set and the
role name without having to worry about their parameter names.