示範滾動刷新

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