Hans J. Ellingsgaard
Members-
Content Count
81 -
Joined
-
Last visited
Everything posted by Hans J. Ellingsgaard
-
Refresh Current Record To Access Value Of Newly Inserted AutoInc Field
Hans J. Ellingsgaard replied to Nathan Wild's topic in Databases
I can not see why this should be a problem, you got your ID and stick to it until your record is finally posted to the database. You use it as a primary key on your mastertable and a foreign key on the detail table. The generator is running outside the transactions, and you are guaranteed to get a unique value each time you request for an ID. -
You can load Excel sheets into a FDMemTable via Microsoft's odbc drivers.
-
You could use the Constraints property of the form instead of using the Event. Self.Constraints.MaxHeight := Screen.WorkAreaHeight; Self.Constraints.MaxWidth := Screen.WorkAreaWidth;
-
Firebird transactions with Firedac
Hans J. Ellingsgaard replied to Alberto Fornés's topic in Databases
Is there a reason why you can‘t use generators? -
Is anyone using IBX (Interbase Express) and compatibility question
Hans J. Ellingsgaard replied to Jasonjac2's topic in Databases
If I remember correctly, IBX does not officially support Firebird. I would rather go with the FireDAC framework instead. The FireDAC framework also seems to have much higher priority than IBX from Embarcadero.- 15 replies
-
- ibx
- interbase express
-
(and 2 more)
Tagged with:
-
If you place the dll files manually into the windows system folders, you'll need to run regsvr32 to register them in Windows. If you use the installer it will register them for you. If you place them in your programs root folder, there is no need for registration.
-
With sql databases always use the query component, you have much more control with it.
-
One way to get around that datetime field, is to create a View on the datbase, where you cast your datetime field to a date field, and then connect the table component to the view instead of the query. Is there a specific reason why you want to use a table compnent instead of a query?
-
If you use a FDQuery instead of FDTable, you could cast your datetime field to date. Then you can filter on that date field.
-
Have you checked in wich folder your dll file is located?
-
If you use the StartTransaction command, you have to finish it off with CommitTransacton or a Rollback. If you're not using a StartTransaction, the FDConnection will start it for you and make a commit when your datasets are closed.
-
How to run Interbase developer in 10.4 and 11
Hans J. Ellingsgaard replied to Gary's topic in Databases
Yes, the developer edition can run via tcp. Have you checked wich port it's using? You can do that with netstat. You should also be able to telnet the portnumber.. -
How to run Interbase developer in 10.4 and 11
Hans J. Ellingsgaard replied to Gary's topic in Databases
If you connect via tcp/ip, it should not matter where your Interbase binaries are located, as long as the interbase service is running. You also need to check wich port it is running on. Normaly it's on port 3050. -
Delphi 10.4, FireDac, StartTransaction causes ODBC error.
Hans J. Ellingsgaard replied to Kyle Miller's topic in Databases
Your problem might have something to do with nested transactions. If your db or your odbc driver don't support nested transactons, make shure there is no ongoing transaction on the same connectionm, before you call StartTransaction. Something like this: if FDConnection1.InTransaction then FDConnection1.Commit; FDConnection1.StartTransaction; -
A primary key is a ground rule of relational daatabases.
-
Copy Encrypted InterBase Database to another machine
Hans J. Ellingsgaard replied to corneliusdavid's topic in Databases
Your problem could come from the gds32.dll client file. If it's in the windows\system32 folder it will be overwritten with each installation. Not all of them have been backward compatible. -
FireDAC: Need help understanding "ConnectedStoredUsage"
Hans J. Ellingsgaard replied to Der schöne Günther's topic in Databases
It works fine the opposite way - active at designtime and closed at runtime. I guess that most users use it that way. I allways make shure that all my queries are closed at programstart, and then open them via code. -
I have converted from IBX to FireDAC without any problems with the datetime fields. What database are you using?
-
Delphi IDE on AMD cpu?
Hans J. Ellingsgaard replied to Mike Torrettinni's topic in Delphi IDE and APIs
The Ryzen 5 processor is more than capable of running VM's on your PC. If it's not for gaming, go for a business PC, they have better hardware quality. -
Target machine actively refused connection
Hans J. Ellingsgaard replied to bazzer747's topic in Databases
Have you checked if your interbase service is running? You can try to connect to it with tke IB Consol that comes with the Interbase installation. -
Try - except - finally generates no debug-breakpoint in Exception scope
Hans J. Ellingsgaard replied to Rollo62's topic in RTL and Delphi Object Pascal
Could it be this problem you have run into? https://www.ideasawakened.com/post/rad-studio-10-4-2-is-now-available-with-possible-cure-for-the-blue-dot-problem -
Check in your project folders to see if there is a dbgrid.pas or dbgrid.dcu file and remove it, if it's there.
-
Best Practices for FireDAC FetchMode/RecordCount Settings
Hans J. Ellingsgaard replied to Larry Hengen's topic in Databases
Is there anything that prevent you from indexing all the fields in the join and where clause? There is a good chance that it would give you a significiant boost on your query performance. -
Best Practices for FireDAC FetchMode/RecordCount Settings
Hans J. Ellingsgaard replied to Larry Hengen's topic in Databases
If you make a select count query on an indexed field, it should only take a ms to execute. The resultset will only have one record. If your table only have 1500 records, the dataset.RecordCount should also respond quckly (not as quick as the record count thoug). There must be something else that goes wrong. What database are you using? Have you tried to run the queries directly in a db manager? -
Best Practices for FireDAC FetchMode/RecordCount Settings
Hans J. Ellingsgaard replied to Larry Hengen's topic in Databases
A count(*) should always be done an an index field, or the point of using it is gone in the first place.