MikeMon

1 hour ago, Lars Fosdal said:

An alternative could be using a temp table for the inner select?

Hi Lars

Not possible. As a workaround, I created computed (calculated) fields and used them in the group by clause. 

44 minutes ago, Lars Fosdal said:

I've not used Interbase, but if follows std SQL, it could be something like this?

 

SELECT HIREDMONTH, EMPLOYEECOUNT FROM   (
	SELECT extract (month FROM HIRED_DATE) AS HIREDMONTH, count(*) AS EMPLOYEECOUNT 
	FROM employee
	) AS Table1
GROUP BY HIREDMONTH, EMPLOYEECOUNT 

 

Hi Lars

Thank you for your answer again. Unfortunately, the derived table feature (nested select) was introduced in Interbase 2017. I'm still using Interbase XE3. Actually, after doing some research, expressions in the group by clause I mentioned above were also introduced in Interbase 2017.

Hi

In Interbase, does anybody know how to use an expression in the "group by" clause, e.g.:

select extract (month from HIRED_DATE) HIREDMONTH, count(*) EMPLOYEECOUNT from employee group by extract (month from HIRED_DATE)

or

select extract (month from HIRED_DATE) HIREDMONTH, count(*) EMPLOYEECOUNT from employee group by 1

2 hours ago, Lars Fosdal said:

In https://support.microsoft.com/en-us/help/201978/how-to-use-printer-device-fonts there are some clues to doing device font substitution, but if that doesn't work out, I am afraid that you have to raise the issue with the maker of the printer.

 

Hi Lars

Thank you for the link. I'm familiar with the info, but unfortunately, it doesn't help me.

Everything works fine except for the X position. The fonts are used normally and printed on the printer. The Y position works fine. The only problem is the X position. The latest driver X-POS 4.57 has the same problem even on Windows 7. An older driver Vendor Thermal Driver 3.2 works fine on Windows 7. They both use the same font: FontA11 or FontA1x1.

I've had other issues with some built-in fonts and thermal printers before, where the PageWidth, TextHeight and TextWidth functions don't return the correct values, but these things can be assigned programmatically. Whereas in the case of the X, there is nothing one can do.

8 minutes ago, Lars Fosdal said:

Is there a TrueType version of the built in printer fonts available anywhere?

It could be that the MS canvas handling fails to get font info for the built in fonts, if the fonts don't exist in the Windows font registry.

Installing the TrueType may help?

Hi Lars

Thank you for your answer. There are no TT version of the POS printer fonts available.

FYI, the Y in the Printer.Canvas.TextOut and all other font functions work fine, e.g. Printer.Canvas.TextHeight and Printer.Canvas.TextWidth.

Hi

I use the "Printer.Canvas.TextOut(X, Y: integer; const Text: string)" procedure to print to a thermal pos printer. I have an issue with the X position when I use built-in printer fonts, e.g. "FontA11". When I use windows fonts, e.g. Arial, the X position works fine. Basically, with built-in fonts, the X value is being ignored whatever value it is being passed, i.e. TextOut(0, 0, 'Print Something') and TextOut(100, 0, 'Print Something') are printing at the EXACT same position.

The thermal printer driver I am using is "Thermal Printer Drivers 4.57". FYI, "Thermal Printer Drivers 3.0" worked fine but can't be used on Windows 10 computers.

Please, advise

10 minutes ago, Alexander Sviridenkov said:

HTML Component Library contains HTML Label for VCL and all FMX platforms. This is the most powerful HTML label because it supports almost all HTML tags and CSS properties while others supports only small subset.

Hi Alexander

Thank you for your assistance.

Unfortunately, the HTML Component Library costs a lot. TMS is much cheaper with a lot of other components included. Are there any free solutions?

Is there a TLabel-like component in Firemonkey that can have HTML tags in its text (or any other) property? I know there are third-party components (TMSSoftware, etc.) out there.

If there isn't any, would anyone suggest any 3rd-party solutions?

OK. Just found out how: 

How is the Android App Bundle setup on Delphi 10.3.3?

19 hours ago, John Kouraklis said:

@MikeMon Does the solution offered by @pietrt work?

 

If you read the answer on stackoverflow, you'll see that a scrollable container is always required.

 

Hi John

I never tried it because the app is both for Android and iOS. So, I'm using the solution provided by Embarcadero.

19 minutes ago, John Kouraklis said:

Scrollable forms is the way to deal with this.

 

I use OrangeUI in one of my app and they have a way that manages it more smoothly and easier. But this is a totally different framework to use

I believe it should happen automatically and no code should be involved. Anything focused but covered by the popped up keyboard should be scrolled up automatically to be visible.

33 minutes ago, Sherlock said:

Just out of curiosity how does an Android Java or an iOS Swift App do this?

I'm curious, too.

16 minutes ago, Der schöne Günther said:

I believe what you do is what Embarcadero actually recommends:

http://docwiki.embarcadero.com/CodeExamples/Rio/en/FMX.ScrollableForm_Sample

Too complicated for something that should be the norm without using any code.

Is there an out-of-the-box way for the screen to move up when the keyboard pops up and covers the focused control, e.g. edit boxes, memos, etc.? Currently we use a vertical scroll box and plenty of code (onVirtualKeyboardShown & onVirtualKeyboardHidden) we found online.

Hi

I use Interbase XE3. How can I give access to a user to see ONLY the metadata of the tables and fields he/she has privileges for. Currently, he/she can see the metadata of the whole database.

Kindly, advise

Help anybody?

1 hour ago, haentschman said:

...no. Typing mistake?

I'm not talking about SYSDBA. I'm talking about SYSDSO;, the user that needs to be created to set up encryption.

Hi

I'm trying to connect by using IBConsole to an encrypted Interbase XE3 (version 11.0.4.828) database with the SYSDSO username to change the SEP password  but I keep on getting the following exception:

"Your user name and password are not defined. Ask your database administrator to set up an Interbase login".

FYI, when I connect to the server with the same SYSDSO credentials, I can connect just fine. Moreover, to encrypt the database, I've used the same SYSDSO credentials.

What am I missing?

Hi Andrew

What I do is change the computer date to a future date, access the file so that its modified date changes to a future date, revert back to the current date and then install. That works fine. Not the best way, but it works. There should be an easier way. Obviously, everyone is using some sort of a workaround. There should be a 3rd value for the "Overwrite" flag: "Only if Newer". It should act like the "Always" acts now, and the "Always" should act like it says: ALWAYS overwrite.

8 hours ago, Dave Nottage said:

If you're running the app from the IDE, you could use the -cleaninstall option as described here:

 

http://docwiki.embarcadero.com/RADStudio/Rio/en/Running_Your_Android_Application_on_an_Android_Device

 

 

Hi Dave

Thank you for your help again. How about when a user updates the app through the Play Store? is the old file overwritten by the new even if the new has an older date?

How about iOS? How does that work?

Hi

The overwrite flag in the "Deployment" screen doesn't seem to have any affect. The only way the existing files are overwritten is if the new file is newer then the existing file. Sometimes, we need to copy updated versions of databases or files with the launch of new app versions.

What we currently do during development is delete the app data and then uninstall the app, and THEN install the newer version.

Is there something I'm missing? Is there another way?

Kindly, advise

Hi Dave

Thank you for your answer.

I've revised both my SDK and NDK settings to the working settings I had on 10.3.1, i.e. SDK build tools 28.0.3, platform android-28 and NDK platform android-22. It still wasn't running. I unchecked the "Receive Push Notifications" in the "Entitlement List" and it started running fine. After that I used the SDK build tools to 29.0.2 and the SDK platform to android-29 and it worked fine as well.

Thank you Dave once again for your valuable input.

Hi Dave

Thank you for your help. After winding back my build tools to 28.0.3, a blank app is now running OK. 

However, my existing app is still not running. I've attached the logcat log file. The app package name is cy.com.wagamama.ordercy.

I can't pinpoint where the problem is exactly.

log.txt

Hi

After upgrading to Delphi 10.3.2, any Android app, including a blank app, is not running successfully on any Android device. I'm getting the following exception:

  "Unfortunately, Project1 has stopped."

I'm using:

- Android SDK 25.2.5 32bit, build-tools\29.0.2, platforms\android-29

- Android NDK r17b, platforms\android-28

Please, advise