Đã hoàn thành

Need Delphi 10.3.3 code to Update records in a SQLite DB

My Application uses a SQLite DB. The table in the DB is called tblLocations. For this assignment there is only one field that needs to be updated in tblLocations:

LockerCount (integer)

If holds a number that is associated to another field called LockerName(string) that is in the same table.

Within my application I use a TAdvListView component (delevoped by TMS), which is named lvDeviceListAdd. lvDeviceListAdd has a total of 10 columns which gets populated by a different table of the DB. However for this request there is only 1 column that you need to use as part of the updating process:

Column Name: Locker Name

Possible content for 'Locker Name':

1) Locker Name may be empty (null), and therefore lvDeviceListAdd will be completely empty.

2) Sometimes the Locker Name column will only contain one row with a value (one value; one record in the tblLocation that needs updating).

3) Other times Locker Name column will have the same value N times, where N = number of rows (e.g. could be 2 times, 10 times, 50 times, etc.).

4) Other times the Locker Name column has several rows with a different value N (rows) times.

5) Other times the Locker Name column has several rows with some having the same value while others will have a different value - N (rows) times.

Example 1: lvDeviceListAdd has no lockername listed.

Example 2: lvDeviceListAdd has LockerName containing 'BinA' and only one row.

Example 3: lvDeviceListAdd has LockerName containing 'BinA', 'BinB, 'BinC' and the consist of 3 rows.

Example 4: lvDeviceListAdd has LockerName containing 'BinA', 'BinB', 'BinA', 'BinX', ...'BinX123' and consist of 125 rows.

Note: lvDeviceListAdd does NOT have a column linked to LockerCount.

The DB has a field called 'LockerName', a string.

So the process is set by finding the match in column 7 of lvDeviceListAdd to the field name 'LockerName' of the table tblLocations and depending on the number of times the same value has been found, update the integer field called 'LockerCount' by 1 for each row matching.

Mention 'Apples and Oranges' at the beginning of your bid so I know you've read this entire request.

In general - I believe it will look like this:

UPDATE tblLocations SET LockerCount = LockerCount + 1 Where LockerName = [login to view URL][i].[login to view URL][7];

Set in some type of loop. At the end of the loop, perform a show message:

ShowMessage ('All Locker Counts have been updated.');

If lvDeviceListAdd is empty, do:

ShowMessage ('Nothing to Update.');

Your code will be tested before payment is submitted. Allow me the time to test before you ask for payment.

Thank you,


Kĩ năng: Delphi, Kiến trúc phần mềm, SQLite

Xem nhiều hơn: need delphi component freelance, hid delphi source code, need someone program code, update records excel, delete records sqlite database using php, need delphi, need div layout code, code update sheet excel, access update records script, php update records web service, vba code update sheets excel, visual basic delphi source code, delphi opengl code, delphi code update, delphi 10.3 update

Về Bên Thuê:
( 74 nhận xét ) Atlanta, United States

ID dự án: #30121731

Được trao cho:


Apples and Oranges Hi, I can make an app in delphi to update your LockerCount column. - = - = - = - = - = - = - = - = - = - = -

$70 USD trong 2 ngày
(13 Đánh Giá)

8 freelancer chào giá trung bình$123 cho công việc này

(78 Nhận xét)

Apples and Oranges Hi, I am a senior developer and work in Delphi 10.3. I design and develop front end and back end applications using VCL & FMX controls with databases like SQLite, Interbase, MySQL and SQL Server. Thêm

$200 USD trong 7 ngày
(6 Nhận xét)

Apples and Oranges Hi, I can do it in 2 days within your budget. Please contact me and send your db and source app so I can start immediately. Thanks

$200 USD trong 2 ngày
(3 Nhận xét)

Hi There...! Note : I give you 25% off on my all services. So grabs this special limited discount offer. Let’s get to the Project. I came to know that your Looking a developer which have rich knowledge about sql d Thêm

$30 USD trong 1 ngày
(10 Nhận xét)

Hello, If the project is deleted please open my portfolio link and hire me  https://www.freelancer.com/u/saminakiran2?w=f&ngsw-bypass=ust Hire me through my profile and lets discuss your  project details . My name is Thêm

$100 USD trong 2 ngày
(3 Nhận xét)
(0 Nhận xét)

Appels and oranges Dear Sir I'm senior software developer And I develope with Delphi since 1995 Delphi 1 Also I'm very old developer if you have no problem with my age cause I'm 59 years Old So if you look for v Thêm

$167 USD trong 7 ngày
(0 Nhận xét)