Find Jobs
Hire Freelancers

Need Delphi 10.3.3 code to Update records in a SQLite DB

$30-250 USD

Færdiggjort
Slået op næsten 3 år siden

$30-250 USD

Betales ved levering
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, RB
Projekt-ID: 30121731

Om projektet

8 forslag
Projekt på afstand
Aktiv 3 år siden

Leder du efter muligheder for at tjene penge?

Fordele ved budafgivning på Freelancer

Fastsæt dit budget og din tidsramme
Bliv betalt for dit arbejde
Oprids dit forslag
Det er gratis at skrive sig op og byde på jobs
Tildel til:
Brug Avatar.
Apples and Oranges Hi, I can make an app in delphi to update your LockerCount column. - = - = - = - = - = - = - = - = - = - = -
$70 USD på 2 dage
4,9 (13 anmeldelser)
4,4
4,4
8 freelancere byder i gennemsnit $123 USD på dette job
Brug Avatar.
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. As you already pointed out , the solution is going to look like that update statements are executed for the matches. Please feel free to contact and discuss in details. I want to see the code and analyse that. Regards, Muhammad
$200 USD på 7 dage
4,9 (6 anmeldelser)
4,0
4,0
Brug Avatar.
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 på 2 dage
5,0 (3 anmeldelser)
3,7
3,7
Brug Avatar.
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 development .you need delphi code that update the record in sql lite bd . According to your post description, you need the job done very quickly with an affordable budget. Your requirements are fully clear to me and I am applying only because I meet all the requirements that you are looking for. I have been working as a full stack sql developer for more than 10 years and I know all the ins and outs of sql development and customization Project should be 100% correct and Complete that will be my first guarantee service in this project. Moreover, I will be available for you for any kind of future edits and customizations. Sometimes my ten years back clients search for me till now only because of my excellent service. I am mostly in love with communication. I like to be in touch with my clients 24/7 so that they can catch me at any time when they need me. I am looking for the clear final requirements docs of your project so that I can start working immediately. If you need to discuss with me for any kind of suggestions or information, please knock me anytime. I am looking forward to hearing from you. Thanks Sohail jamil
$30 USD på 1 dag
5,0 (10 anmeldelser)
3,3
3,3
Brug Avatar.
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 Samina Kiran! I am a professional research writer. I am interested in this project Need Delphi 10.3.3 code to Update records in a SQLite DB.I have completed many similar projects before. Please contact me for further discussion. I'll be happy to share my previous work samples with you.  I believe in providing the best quality work that will satisfy the client’s specifications. I ensure 100% free plagiarism work. Lets connect and hire me today for your project!   "https://www.freelancer.com/u/saminakiran2?w=f"
$100 USD på 2 dage
4,7 (3 anmeldelser)
3,1
3,1
Brug Avatar.
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 very experienced Delphi developer I think you can find one older And experienced with Delphi from Delphi 1 to Rad Studio 10.4.2 If I understood you need fonction that update column in your listview with the result of many times the lookname is present in table. I can do this work for you in 7 open days If you hire me and I'm Okk to don't discuss the price with you only when the work is done and valided. My bid price can change after. If you are interested that I work for you contact me in private chat and, we discuss the work and price Best regards.
$167 USD på 7 dage
0,0 (0 anmeldelser)
0,0
0,0

Om klienten

Flag for UNITED STATES
Atlanta, United States
5,0
74
Betalingsmetode verificeret
Medlem siden dec. 12, 2005

Klientverificering

Tak! Vi har sendt dig en e-mail med et link, så du kan modtage din kredit.
Noget gik galt, da vi forsøgte at sende din mail. Prøv venligst igen.
Registrerede brugere Oprettede jobs i alt
Freelancer ® is a registered Trademark of Freelancer Technology Pty Limited (ACN 142 189 759)
Copyright © 2024 Freelancer Technology Pty Limited (ACN 142 189 759)
Indlæser forhåndsvisning
Geolokalisering er tilladt.
Din session er udløbet, og du er blevet logget ud. Log venligst ind igen.