Application retrieve sql record for editing

已完成 已发布的 Oct 4, 2007 货到付款
已完成 货到付款

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)

EMAIL

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.

C# 编程 工程 MySQL PHP 软件构架 软件测试 SQL

项目ID: #3353875

关于项目

14个方案 远程项目 活跃的Oct 8, 2007

授予:

atanughosh76

See private message.

$150 USD 在7天内
(128条评论)
7.5

有14名威客正在参与此工作的竞标,均价$108/小时

teknowmagic

See private message.

$85 USD 在7天内
(124条评论)
6.8
amrelgarhy

See private message.

$148.75 USD 在7天内
(77条评论)
6.2
edlukens

See private message.

$124.95 USD 在7天内
(82条评论)
5.5
cdehart

See private message.

$85 USD 在7天内
(74条评论)
5.4
lpitotti

See private message.

$153 USD 在7天内
(8条评论)
3.7
dynamicasystems

See private message.

$127.5 USD 在7天内
(4条评论)
3.2
schenz74

See private message.

$106.25 USD 在7天内
(13条评论)
3.1
Cylindrix

See private message.

$85 USD 在7天内
(8条评论)
2.9
moris7

See private message.

$85 USD 在7天内
(6条评论)
2.9
stevenellio

See private message.

$101.15 USD 在7天内
(9条评论)
2.6
madmaxxvw

See private message.

$85 USD 在7天内
(1条评论)
2.5
bjvailvw

See private message.

$85 USD 在7天内
(6条评论)
3.0
harrycodervw

See private message.

$85 USD 在7天内
(0条评论)
0.0