示範滾動刷新

It is only used for Delphi teaching. It is not recommended for those who are not Delphi developers to install it. Please watch the YouTube video for related operation instructions. Thank you.

Supports the latest Android 14 version.
Recompile: Embarcadero RAD Studio 12.1 Version 29.0.51961.7529. (Android 64+32)
Only supports: 6/7/8/9/10/11/12/13/14 (note: version 5 is not supported).

Use Delphi 10.2 Tokyo to develop ListView scrolling refresh to automatically add the following information.
Demonstrates dynamically selecting data from a SQLite database, displaying the data in ListView, and automatically refreshing and adding the data below when scrolling to the end.

Test phone: LG Nexus 5X
Mobile environment: Android 6.0.1
Development environment: RAD Studio 10.2.1 Tokyo Version 25.0.27659.1188
Operating system: Windows 10 Pro (64-bit)

SQLite database:

CREATE TABLE [Categories] (
[CategoryID] VARCHAR(30) NOT NULL,
[CategoryName] VARCHAR(30) NOT NULL,
CONSTRAINT [Categories_Index] PRIMARY KEY ([CategoryID]));

CREATE TABLE [Products] (
[ProductID] VARCHAR(30) NOT NULL,
[ProductName] VARCHAR(30) NOT NULL,
[UnitPrice] INTEGER NOT NULL,
[Photo] BLOB NOT NULL,
[Description] VARCHAR(30),
CONSTRAINT [Products_Index] PRIMARY KEY ([ProductID]));

CREATE TABLE [MenuList] (
[CategoryID] VARCHAR(30) NOT NULL,
[ProductID] VARCHAR(30) NOT NULL,
CONSTRAINT [Categories_Index] PRIMARY KEY ([CategoryID], [ProductID]));

SELECT
A.CategoryID, A.ProductID, B.CategoryName,
C.ProductName, C.UnitPrice, C.Photo, C.Description
FROM MenuList A, Categories B, Products C
WHERE
(A.CategoryID = B.CategoryID) AND
(A.ProductID = C.ProductID)
ORDER BY A.CategoryID, A.ProductID

Youtube:
https://www.youtube.com/channel/UCdqhXsMD1Vyvp2769FPKCog
blog:
http://nolanliao1965.pixnet.net/blog
http://nolanliao1965.blogspot.tw/
Facebook:
https://www.facebook.com/NolanLiao1965
https://www.facebook.com/groups/1903734576514424/
Google+:
https://plus.google.com/114820935539769287269/posts
https://plus.google.com/u/0/communities/114911314106887760525
SlideShare:
http://www.slideshare.net/NolanLiao1965/

privacy policy:
https://nolanliao1965.pixnet.net/blog/post/356835736-privacypolicy