Find Jobs
Hire Freelancers

Delphi treeview control that works with mysql "Nested set model" table

€30-250 EUR

Closed
Posted over 9 years ago

€30-250 EUR

Paid on delivery
Managing hierarchical data in mysql besides the "Adjacency List Model" can be done also using "Nested set model" (introducing 2 extra columns in the table: "lft" and "rght") This model is described here: [login to view URL] where you can find ready code for adding, deleting nodes, displaying tree etc.. What i need is a simple delphi program with a treeview that will represent the hierarchical data from the table. It should allow user to add nodes, subnodes, delete nodes and moving nodes (drag&drop) from one parent to other parent (including its subnodes). These operation on treeview should then update the database table so the table the the treeview represent the same hierarchical structure. Initial table can be generated using following SQL code: CREATE TABLE nested_category ( category_id INT AUTO_INCREMENT PRIMARY KEY, name VARCHAR(20) NOT NULL, lft INT NOT NULL, rgt INT NOT NULL ); INSERT INTO nested_category VALUES(1,'ELECTRONICS',1,20),(2,'TELEVISIONS',2,9),(3,'TUBE',3,4), (4,'LCD',5,6),(5,'PLASMA',7,8),(6,'PORTABLE ELECTRONICS',10,19),(7,'MP3 PLAYERS',11,14),(8,'FLASH',12,13), (9,'CD PLAYERS',15,16),(10,'2 WAY RADIOS',17,18);
Project ID: 6707589

About the project

7 proposals
Remote project
Active 9 yrs ago

Looking to make some money?

Benefits of bidding on Freelancer

Set your budget and timeframe
Get paid for your work
Outline your proposal
It's free to sign up and bid on jobs
7 freelancers are bidding on average €175 EUR for this job
User Avatar
Good evening, I am an expert Delphi developer. Do you need the sources or just the executable? please accept my best regards Augusto Pellis
€222 EUR in 10 days
4.8 (35 reviews)
6.7
6.7
User Avatar
Hello, I would use a free TVirtualTreeView component which can display multiple columns, allows in-place editing, sorting, etc in your program. I am a programmer with more than 10 years experience using Delphi and other programming languages, also various RDBMS.
€160 EUR in 5 days
5.0 (28 reviews)
6.1
6.1
User Avatar
Dear friend , I have experience with delphi and mysql please can you let me know delphi version that you using Look forward to working with you!! Best Regards winnet
€166 EUR in 10 days
4.8 (31 reviews)
5.8
5.8
User Avatar
Hi, I'm highly rated Delphi code with high skills in various databases includes MySQL. I could develop this sample Delphi application for you. I would like to use free VTV controls for this needs if you don't mind. It's powerful control with very high possibility. I'm excited to work with you. Thanks, Andriy
€150 EUR in 5 days
5.0 (55 reviews)
5.5
5.5
User Avatar
Aucune proposition n'a encore été fournie.
€130 EUR in 3 days
4.9 (5 reviews)
2.5
2.5

About the client

Flag of MACEDONIA
Prilep, Macedonia
5.0
12
Member since Mar 25, 2004

Client Verification

Thanks! We’ve emailed you a link to claim your free credit.
Something went wrong while sending your email. Please try again.
Registered Users Total Jobs Posted
Freelancer ® is a registered Trademark of Freelancer Technology Pty Limited (ACN 142 189 759)
Copyright © 2024 Freelancer Technology Pty Limited (ACN 142 189 759)
Loading preview
Permission granted for Geolocation.
Your login session has expired and you have been logged out. Please log in again.