Find Jobs
Hire Freelancers

Simple Win32 Application to update 1 field in Sybase SQL Database and create report on changes

$100-500 USD

Cancelled
Posted over 13 years ago

$100-500 USD

Paid on delivery
We need an app that a user can change a specific field (Balance) within a specific table ([login to view URL]) of an existing Sybase SQL Database (Sybase v5 via existing ODBC connection). Currently we can do this using SQL script but we need to make it simple for non IT literate people. However, we also need to track changes for reporting purposes. We need to see : * who made the change (from [login to view URL]) * what time/date the change was made * what MemberID from [login to view URL] was changed * what new amount was entered into [login to view URL] The change logs can be added to a new table within the database so we can query them for reports ## Deliverables I envisage 3 screens: Login --> which queries from table [login to view URL] and requires username(email) & password match. It should also only allow access to employees where field seclevel >= 75 Search Member Form (queries [login to view URL]) --> Which allows to search by fields First Name or Last Name and select member record Edit Form --> This form will show First Name, Last Name, Card Number and AmountDue fields. The only editable field should be [login to view URL] and any changes made to this field should be saved and updated to Log.
Project ID: 3856188

About the project

1 proposal
Remote project
Active 13 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
1 freelancer is bidding on average $102 USD for this job
User Avatar
See private message.
$102 USD in 14 days
0.0 (0 reviews)
0.0
0.0

About the client

Flag of IRELAND
Dublin, Ireland
5.0
29
Payment method verified
Member since Jun 19, 2008

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.