Skip Navigation

More capable, accountable and affordable. Guaranteed.

Site Wide Message: Posted Sep 8, 2010 10:54:36 AM EDT.Dismiss this message
A big thank you to all site users for helping us win the 2010 Inc 5000 award for fastest growing private company, for the fourth year in a row!
Employers and workers: two universities are interested in how and why you use vWorker. (All information will be kept confidential and only reported in aggregate.)
  1. Employers: Louisiana State University wants to learn about the factors that influence your adoption of online sourcing. Click here to take the survey.
  2. Workers: Erasmus University wants to understand how you use the site. Contributors will receive a final copy of the aggregated data Click here to take the survey.

Delphi /MySQL
Project Id: 1466501
Bookmark in my 'To Do' list
Posted by: DG3 (61 ratings)
(Employer rating 10)
Non-action Ratio: Very Good - 10.00%
Employer Security Verifications: Excellent
Approved on: Jul 31, 2010
7:00:17 AM EDT
Bidding Closes: Aug 14, 2010
6:59:45 AM EDT
Viewed (by workers): 316 times
Deadline: Thursday Aug 5, 2010 10:15:23 AM EDT
(5 days after 7/31/2010 10:15:23 AM)
Phase:
100% of work was accepted by employer. Worker account has been credited.
Payment Model: Pay-for-Deliverables
Max Accepted Bid: Bidding is closed
Project Type: Very Small Business Project: under $100(USD)
Bidding Type: Open Auction
Accepted Bidder Economy Type(s):
- Emerging economy (includes most countries. Examples: Romania, India, China, etc.)
Accepted English fluency(ies): All
ExpertRating Requirement: None
Shortcuts
Communication

Messages summary
Post first reply
Chat log
 During project work

Status reports
Escrow Log
Work acceptance
Assembla Tools
Mediation / Arbitration
 Other

Contact info / receipts
Project phase log
Ratings

(Note:options without links are not enabled for this phase.)

Enter chat room for this project
(0 active users at Sep 9, 2010 3:30:50 AM EDT)

Brief Summary:
  • vWorker.com reminder: You MAY NOT post the final solution for this (and any) project before your bid is accepted and funds are fully escrowed. Anyone who does may have their account permanently suspended. However, you CAN post:
    • On programming projects: A prototype or functional demo...as long as source code is not provided.
    • On graphics projects: A watermarked and low-resolution version of the work.
I need to access a remote Linux/Apache/MySQL database from Delphi desktop software.

I need the following simple Delphi functions:

- bool SQLConnect();  // true if success, false otherwise. In case of error,
  a messagebox must popup with a description of the error.

- bool SQLInsert( '<SQL INSERT QUERY>' );  // true if success,
  false otherwise. In case of error,   a messagebox must popup with a
  description of the error.

- int SQLLastInsertId(); // returns the id of the last inserted record.

- bool SQLUpdate( '<SQL UPDATE QUERY>'  );  // true if success,
  false otherwise. In case of error,   a messagebox must popup with a
  description of the error.

- TStringList SQLSelect( '<SQL SELECT QUERY>' ); // On succes, returns a 
  TStringList containing all fetched records, on failure returns nil. On
  failure,   a messagebox must popup with a description of the error.
Requirements Interview Answers:
To help you bid more accurately, the employer was interviewed about the requirements for this project. Below are their answers. Untitled Page
Project Type: What kind of work do you need done?
Software related (Includes desktop applications and internet websites)
Project Parts: What do you want the worker to do on this project?
Requirements: The worker will analyze the problem and propose a software-based solution to the problem.
Programming: The worker will take the requirements and translate them into the language of the computer (and test it).
User installation: The installer will move the software from the place it was created (which is called the development or QC environment) to where you will use it (which is called the production environment). The installer then tests the software to make sure that the installation was done properly and completely.
Req. Doc. Type: What kind of documentation do you want for this project?
Formal documentation - After talking back and forth, the worker creates a formal document and/or prototype, as follows:
  • Prototype: The analyst will create a non-working mockup of all pages/screens in the final software. Creating a prototype makes it easier for the user to visualize the final software, and reduces misunderstandings.
Program Type: What kind of software should the worker create (and/or install)?
  • A desktop or server program: This software runs on a user's own PC/workstation, or on a server.
Desktop / server program info
Size of application: How many screens/forms need to be created/edited in this application?
Exactly 1.
Programming Language: What programming language(s) do you want your application written in?
I do know the language(s).
Languages(s):
  • Delphi
Operating system(s) What operating systems(s) do you want your application to work on?
I do know the operating system(s):
  • Microsoft Windows -- version(s): XP,Vista,7
    		•
    Database: Will this project include a database?
    Yes, it does include a database.
    Details:
    • MySQL -- version(s): 5
    Installation Program: Does the worker need to create an installation program?
    No. The worker needs to only give me instructions on how to install it.
    Legal: 1) I require complete and fully-functional working program(s) in executable form as well as complete source code of all work done (so that I may modify it in the future).
    2) Deliverables must be in ready-to-run condition as follows (depending on the nature of the deliverables):
    2a) If there are any server-side deliverables (intended to only exist in one place in the Employer's environment) then they must be installed by the Worker in ready-to-run condition (unless specified elsewhere by the Employer).
    2b) All other software (including but not limited to any desktop software or software the employer intends to distribute) must include a software installation package that will install the software in ready-to-run condition on the platform(s) specified in this project (unless specified elsewhere by the Employer).
    3) All deliverables will be considered "work made for hire" under U.S. Copyright law. Employer will receive exclusive and complete copyrights to all work purchased.
    3b) No part of the deliverable may contain any copyright restricted 3rd party components (including GPL, GNU, Copyleft, etc.) unless all copyright ramifications are explained AND AGREED TO by the employer on the site per the worker's Worker Legal Agreement.
    Other Requirements:
    • All deliverables must be uploaded to vWorker.com before the deadline(s) for this project...with no exceptions. If this contract makes it impossible for a competent person to do this, then do not start this project...but instead alert vWorker.com of an un-arbitratable, illegal project.
    • Remember that contacting the other party outside of the site (by email, phone, etc.) on all business projects < $500 (before the employer's money is escrowed) is a violation of both the employer and worker agreements. vWorker.com monitors all site activity for such violations and can instantly expel transgressors on the spot, so we thank you in advance for your cooperation. If you notice a violation please help out the site and report it. Thanks for your help.
    Categories:
    (Note: Like everything else on this page, these categories are part of the original contract for this project.)
    Microsoft Windows, Database, Languages, Requirements, Operating systems / platforms, Delphi, Other (Technology), MySQL, Technology, Software Development, Desktop applications, Tech details
     
    Messages summary
    ( Back to shortcuts )
    All monetary amounts on the site are in United States dollars.
    vWorker.com is a closed auction, so workers can only see their own bids and comments. Employers can view every posting made on their projects.

    2 bids have been posted. Why can't I view bids from other workers who are bidding against me?
    Bidding/comment cannot be viewed until you are logged in.

     
    Ratings
    ( Back to shortcuts )

    Rating Rated Rated For Rated By Rated On  
      10
    (Excellent)     		DG3 Delphi /MySQL IonelR
    (who themselves is rated 9.94 - Excellent)     		August 2, 2010 4:11:52 AM EDT
      great buyer, knows exactly what he needs, very prompt in responding to questions, always a pleasure working with him

    respects, Ionel
      10
    (Excellent)     		IonelR Delphi /MySQL DG3
    (who themselves is rated 10 - Excellent)     		August 2, 2010 3:57:17 AM EDT
      Delivered superb piece of software.
     
    Search
    'All Workers' Competition.
      What is this list?
      1. cricava
        10 avg. over 379 jobs.
      2. Gravity Jack, Inc.
        9.8 avg. over 61 jobs.
      3. Lisa_G
        9.9 avg. over 1864 jobs.
      4. calciustec h
        9.81 avg. over 1540 jobs.
      5. Pop Mihai Sergiu
        10 avg. over 165 jobs.
      6. PSergei
        9.87 avg. over 481 jobs.
      7. DX Silverligh t Team
        9.79 avg. over 315 jobs.
      8. Dali Studio
        9.83 avg. over 181 jobs.
      9. CodeAndMor e
        9.95 avg. over 522 jobs.
      10. Ing. Gervasio Marchand Cassataro
        10 avg. over 187 jobs.

      ...See ALL workers by ranking
    Newest projects.
    See ALL...

    Click here to put this ticker on your own site and/or get live RSS newsfeeds.

    Copyright © 2001-2010 Exhedra Solutions, Inc. All rights reserved. By using this site you agree to its Terms and Conditions. vWorker.com™, "Expert Guarantee"™ AccuTimeCard™ and "More capable, accountable and affordable. Guaranteed."™ are trademarks of Exhedra Solutions, Inc.. Page generated by IISPROD11 at 9/9/2010 3:30:51 AM