Application retrieve sql record for editing
$100-200 USD
货到付款
UPDATE - Added create sql statement attachment.
Also not used for entering records only changing.
Application that will retrieve a record from one sql table for editing.
The sql table is a mailing list, each record has a unique mail id. This mail id would be entered into a ID field on the application.
After enter id into mail id field a lookup into the sql table is done and the matching record is returned to the window for editing.
If the record not saved and a new id is entered a warning box with "Do you want to save this record?". This warning box will have "Yes or No" buttons. Clicking yes will commit the record and move to the next record. When a record is saved 2 additional fields are updated "Date" (Datetime field) with the current date time saved, and Update with the letter Y.
If no changes are made and the save button is pressed the date field is still changed to current date/time along with the Update field changed to Y.
Upon Save the cursor should be placed back into the ID field and all other fields should be blank until another id is entered.
**_Table fields need to be on form in 2 columns :
_
Column 1
**MAILID - Matching id field for record
FIRST_NAME
LAST_NAME
ADDRESS1
ADDRESS2
CITY
STATE
POSTALCODE
COMPANY
**Column 2
**YEARS (Radio button - 0 to 3, 4 to 5, 6+) (values 1,2,3)
DESCRIBE (Radio button - Build , Top , Brk/Own (values 1,2,3)
PHONENUMBER
EXFIELD1
EXFIELD2
EXFIELD3
**_Fields in table but not on form:_
**KEYCODE (do not change/edit)
MEMBERID (do not change/edit)
JOINDATE (do not change/edit)
UPDATE (change to P on save)
DATE (change to current date/time on save)
## Deliverables
1) Complete and fully-functional working program(s) in executable form as well as complete source code of all work done.
2) Deliverables must be in ready-to-run condition, as follows (depending on the nature of the deliverables):
a) For web sites or other server-side deliverables intended to only ever exist in one place in the Buyer's environment--Deliverables must be installed by the Seller in ready-to-run condition in the Buyer's environment.
b) For all others including desktop software or software the buyer intends to distribute: A software installation package that will install the software in ready-to-run condition on the platform(s) specified in this bid request.
3) All deliverables will be considered "work made for hire" under U.S. Copyright law. Buyer will receive exclusive and complete copyrights to all work purchased. (No GPL, GNU, 3rd party components, etc. unless all copyright ramifications are explained AND AGREED TO by the buyer on the site per the coder's Seller Legal Agreement).
* * *This broadcast message was sent to all bidders on Saturday Oct 6, 2007 11:03:48 PM:
I have added missing create table statement, and clarified that this application needs to edit existing records, and will NOT be used to enter records. Also it cannot delete any records either. I will be reviewing all bids on Monday, Oct 7.
## Platform
"Windows XP"
SQL Server 2000 Professional
Database: Mailings
Table: mail
Visual Studio 2005 - C#, I require this so I can make layout changes if desired.
项目ID: #3353875