Hans J. Ellingsgaard

I had some similar experiences where I couldn't get it to work satisfactorily. We have customers with all sizes of phones and tablets. I ended up writing most of the positioning and sizes of controls in code, only controls that are aligned to client are not set in code.

No, as far as I know, you have to download it to the phone and install it under the Encryption & credentials window. I had this problem with a client, that couldn't acces there webservice with some older handheld terminals, after they got a new DigiCert certificate. If we manually installed the certificate, some of the terminals were working again, but for the oldest version of terminals, it wasn't even possible to install the certificate, as it was not compatible with the Android version. After some research we ended up buying a certificate from GoDaddy, that was compatible with the older Android devices.

Yes, Digicert is a well known provider of certificates, but I would check it anyway. When searching for errors, should work is not good enough, double check everything to make shure that it really works. Some older Android devices does not get there certificates updated, and Digicert has issued some new certificates, that's not working on older devices. You can check the certificates from here: Open your device's Settings app. Tap Security & privacy More security settings Encryption & credentials. Under "Credential storage":

Have you checked if your certificate is under known certificates on your Android device? If it's not, you'll have to install it.

If you have multiple instanses of the server on same computer, you will need to use different ports for each instance. The first instance normally get port 3050 and the next 3051, if you not specifically choose some other ports. Can it be that you have multiple instances running and you connect to the first installed via port 3050?

Do you use as embedded or as a server?

Use FDQuery or FDCommand component instead of a FDTable, to run that script.

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?

If you store the values as a Timestamp field, you can show it in the grid with entrance_time.AsDateTime

IBExpert has a tool to compare the metadata of two databases, and generate a update script with the differences.

Can't you design the badge in a report designer, like Fast Report, and print directly to the printer driver?

When you are defining all the fields in runtime, why not also create the table in runtime?

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?

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.

Is port 3050 open on the server? Have you tried to connect from the client to the server with IB Consol?

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.