Hans J. Ellingsgaard
Members-
Content Count
81 -
Joined
-
Last visited
Everything posted by Hans J. Ellingsgaard
-
Use Interbase Developer license on 2 Windows PCs?
Hans J. Ellingsgaard replied to GrumpyNoMore's topic in Databases
You will need to open port 3050 in the firewall on the server. -
That should mean it is Ok with spaces in the path, but AFAIK SQLite is a file based db, not a RDBMS, so just to be 100% safe, I would try to place the db file in a path without spaces.
-
You have a connection path with spaces, are you shure the db component can handle spaces? Not all do.
-
I think this shold be dealt with at the OS level with user rights. What happens if the user open the file explorer, and start browsing folders from there?
-
Storing and Displaying DateTime Values in SQLite DB
Hans J. Ellingsgaard replied to new_x's topic in Databases
If you store the values as a Timestamp field, you can show it in the grid with entrance_time.AsDateTime -
Recommendation for library/components for Interbase structure changes
Hans J. Ellingsgaard replied to dcroghan's topic in Databases
IBExpert has a tool to compare the metadata of two databases, and generate a update script with the differences. -
Using Dymo LabelWriter from Delphi
Hans J. Ellingsgaard replied to Cherns's topic in Delphi Third-Party
Can't you design the badge in a report designer, like Fast Report, and print directly to the printer driver? -
TFDMemTable - how to clear structure?
Hans J. Ellingsgaard replied to Jacek Laskowski's topic in Databases
When you are defining all the fields in runtime, why not also create the table in runtime? -
Android Create SQLLite Database at Runtime.
Hans J. Ellingsgaard replied to Robert Gilland's topic in Databases
Is there a path delimiter after the DocumentFolderPath? -
Just a guess, but I think you haven't defined the request type in your code. What does your code look like?
-
Looking for outsourcing FMX development
Hans J. Ellingsgaard replied to Bob Baudewyns's topic in Job Opportunities / Coder for Hire
I didn't understand Rick_Delphi's reaction either, when you are asking for an invoice it should be very clear that you are willing to pay for the service. -
The problem is your join in the query. Sometimes FireDAC is smart enough to write an update script that's ignoring the join fields, but if not, then you have to write the update query yourself. If I remember correctly there is a description of how to do it in Cary Jensen's book. ( I saw you mentioned it in an another post)
-
Have you checked if the user has write rights on the folder where the inifile is placed?
-
It can also happen if you have DB aware components that reference to that field. It could be on a different form.
-
client pc database connection problem with interbase server
Hans J. Ellingsgaard replied to muratcelik64's topic in Databases
Is port 3050 open on the server? Have you tried to connect from the client to the server with IB Consol?- 15 replies
-
Have you tried using a FDQuery with a where clause, where you select just one record, instead of a FDtable component?
-
Do you use a FDQuery for insert? If that's the case do you hava a "select * from" in the sql command, or do you use an "insert into command"? You could try to write a direct insert command and use a FDCommand component to see wath's happening.
-
Is that search based on a table component? If that's the case you'll end up loading all records into memory. You can instead make a search with a query and a where clause.
-
My guess is that your tables has a lot of records, or each of your records holds a lot of data, and when you opens it, with a table or query, you get all the records into memory. If that's the case, you will need to limit the number of records with a where clause in your query. You could also limit the number of fields for each record in an overview, and then select all fields only for an active record.
-
Do you use query or table components?
-
The table component is not well suited for large datasets. It's better to use a query, and do the filtering with sql.
-
You can usa an API like https://www.ipify.org to get your public ipaddress. When that is said, this sound strange. Do you have a printer that can be called directly with a public ipaddress, do you not have a vpn or some other secure connection to the office network?
-
DBGrid repaint or refresh when dataset is refreshed
Hans J. Ellingsgaard replied to ChrisChuah's topic in Databases
The client dataset has a bookmark method you can use. Also use dataset.disablecontrols; / dataset.enablecontrols before and after refresh, as Attila suggests, to avoid flickering in the dbgrid. -
When you use the tcp/ip connection, you must define the server. If you are running you DB on same computer as program, you can use the 127.0.0.1 ip address.
-
DBGrid selected row does not highlight the selected row when ClientDataSet is Closed and Open again
Hans J. Ellingsgaard replied to ChrisChuah's topic in Databases
I think that Lajos is correct about that bookmarks are lost when closing the query in FireDAC, but if I remember correctly, it did work in Client Dataset.