Forum > Databases

IBExpress - best practise to change to "active"?

(1/4) > >>

Nicole:
I am new to IBExpress and portate old cold into it (coming from FireDAC, which did some tricks automatically).
So I am not sure about the basics of IBExpress.

This I have at the moment and it works at design-time:
ibdatbase
ibconnection
tbtransaction
ibdatasource
ibdataset

=> DBGrid

Above this DBGrid are Buttons, which generate SQL select-Codes for my database.
Their results I want to see at runtime.

What I want to do at the shortest way:
1) change the SQL code
2) display the updated DBGrid

my questions
a) Where is the best place to change the SQL-request?
b) What has to be set to "active" or "connect" either for the first request or for an update of the SQL?
c) How can I avoid, that the password is requested every time?

Thanks.

HeavyUser:

--- Quote from: Nicole on August 16, 2022, 09:11:09 pm ---I am new to IBExpress and portate old cold into it (coming from FireDAC, which did some tricks automatically).
So I am not sure about the basics of IBExpress.

This I have at the moment and it works at design-time:
ibdatbase
ibconnection
tbtransaction
ibdatasource
ibdataset

=> DBGrid

Above this DBGrid are Buttons, which generate SQL select-Codes for my database.
Their results I want to see at runtime.

What I want to do at the shortest way:
1) change the SQL code
2) display the updated DBGrid

my questions
a) Where is the best place to change the SQL-request?

--- End quote ---
The dataset is the only place where you can change the sql.

--- Quote from: Nicole on August 16, 2022, 09:11:09 pm ---b) What has to be set to "active" or "connect" either for the first request or for an update of the SQL?

--- End quote ---
You set the datasets active := false change the sql and then set it to true again.

--- Quote from: Nicole on August 16, 2022, 09:11:09 pm ---c) How can I avoid, that the password is requested every time?

--- End quote ---
on ibdatabase there is a property named loginPrompt set it to false.

Nicole:
Thank you for your answer.
Unfortunately it does not work for me.

At design-time the dataset asks for the keyword on setting it to active.
After I key it in another time, it works fine.

At runtime, I do not see this login-request, but the error message:

[Window Title]
Fehler

[Content]
Projekt project_Tiger hat Exception-Klasse »External: ACCESS VIOLATION« ausgelöst mit der Meldung:
Access violation reading from address $00000000000000C0.

 In Datei 'frame_waren_.pas' in Zeile 37:
DataModule1.IBDataSet_Waren.Active:=true;

[Ok]

HeavyUser:

--- Quote from: Nicole on August 17, 2022, 09:49:27 am ---Thank you for your answer.
Unfortunately it does not work for me.

At design-time the dataset asks for the keyword on setting it to active.
After I key it in another time, it works fine.

At runtime, I do not see this login-request, but the error message:

[Window Title]
Fehler

[Content]
Projekt project_Tiger hat Exception-Klasse »External: ACCESS VIOLATION« ausgelöst mit der Meldung:
Access violation reading from address $00000000000000C0.

 In Datei 'frame_waren_.pas' in Zeile 37:
DataModule1.IBDataSet_Waren.Active:=true;

[Ok]

--- End quote ---
attach a sample application that  demonstrates the problem to take a closer look.

Nicole:
How shall this work?
The environment of the db is in a VM of more than 100 GB and the data inside are confidential.

Navigation

[0] Message Index

[#] Next page

Go to full version