×
INTELLIGENT WORK FORUMS
FOR COMPUTER PROFESSIONALS

Log In

Come Join Us!

Are you a
Computer / IT professional?
Join Tek-Tips Forums!
  • Talk With Other Members
  • Be Notified Of Responses
    To Your Posts
  • Keyword Search
  • One-Click Access To Your
    Favorite Forums
  • Automated Signatures
    On Your Posts
  • Best Of All, It's Free!

*Tek-Tips's functionality depends on members receiving e-mail. By joining you are opting in to receive e-mail.

Posting Guidelines

Promoting, selling, recruiting, coursework and thesis posting is forbidden.

Students Click Here

Online Database

Online Database

Online Database

(OP)
HI -

I'm looking for a hosted online database provider that will allow us to create a database for the tracking of warranty renewals.

We would like to be able to add a renewal date field that a week before this date a reminder email is sent out.

I have found a couple of online databases but none will allow us to set up a trigger based on a date.

We have no in-house knowledge of database design and need to be able to access it from anyware.

Any Ideas

RE: Online Database

Depends on the number of warranties you need to maintain.
In principle you can use any database for that purpose, and any online database will be available for access anywhere you have internet access. But data in itself will not send emails.

I assume you have a large database, then I'd recommend using one of the major league databases. SQL Server has Notification Services for example, which is meant for that purpose to create notifications based on some conditions.

Bye, Olaf.

RE: Online Database

Quote:

I have found a couple of online databases but none will allow us to set up a trigger based on a date.
That needn't be a problem - you just set up a job that runs every day, sending any emails that are due. Any host that allows you to use cron would be suitable.

Database choice is more a function of volume of data. If you're a small business, MySQL may be powerful enough.

-- Chris Hunt
Webmaster & Tragedian
Extra Connections Ltd

RE: Online Database

Triggers by their nature are not date-based. Triggers in all databases occur only when data is inserted, deleted or updated. What you generally want if you want to take some action based on a date is a scheduled job. These are scheduled to run at specific dates and times (such as daily at 11:00 pm or every Monday at 1:00 am) and thus the actions can be date-based.

"NOTHING is more important in a database than integrity." ESquared

RE: Online Database

I think that's what s/he meant:  the online databases he found won't allow him to schedule jobs.  (Misuse of terminology.)

Red Flag This Post

Please let us know here why this post is inappropriate. Reasons such as off-topic, duplicates, flames, illegal, vulgar, or students posting their homework.

Red Flag Submitted

Thank you for helping keep Tek-Tips Forums free from inappropriate posts.
The Tek-Tips staff will check this out and take appropriate action.

Reply To This Thread

Posting in the Tek-Tips forums is a member-only feature.

Click Here to join Tek-Tips and talk with other members! Already a Member? Login

Close Box

Join Tek-Tips® Today!

Join your peers on the Internet's largest technical computer professional community.
It's easy to join and it's free.

Here's Why Members Love Tek-Tips Forums:

Register now while it's still free!

Already a member? Close this window and log in.

Join Us             Close