SQL Query

[NSR Mick]

I have a table populated with data and one column is year. What I need to do is change all the data in this column to the same value.

Can anyone help with an sql command?
____________________
If you dont like the way that I ride.......Stop trying to keep up!!!

[Kickstart]

Hi

Think that is going to vary with the flavour of SQL you are using. Generally easy to do though.

All the best

Keith
____________________
Traxpics, track day and racing photographs - Bimota Forum - Bike performance / thrust graphs for choosing gearing

[NSR Mick]

It's Sybase SQL Anywhere 8
____________________
If you dont like the way that I ride.......Stop trying to keep up!!!

[Suzuki]

[NSR Mick]

Suzuki my friend you are my hero, spot on.

Thanks for the quick response too.
____________________
If you dont like the way that I ride.......Stop trying to keep up!!!

[Suzuki]

I do it for a living

Glad you're sorted.
____________________
<Simple> no I'm shaven Jon
<Simple> it is a big enough hole.. I'll leave it now
Ride: 1999 Suzuki GSXR600 (yellow/black) IRC: Stats - Relationship Map

[NSR Mick]

Proper weight off my shoulders that one. It is actually bike related, its for a sprint results program that happens to have the date hard coded into the app, so I'm just going to let the app insert the date as 2005 in each entry and then just change them all to 2006 at the end of the day.
____________________
If you dont like the way that I ride.......Stop trying to keep up!!!

[Kickstart]

Hi

Not sure on Sybase. With Oracle you can just add days to a date, so you could do:-

update table_name set date_field = date_field + 365

Default is that it adds days.

All the bst

Keith
____________________
Traxpics, track day and racing photographs - Bimota Forum - Bike performance / thrust graphs for choosing gearing

[NSR Mick]

Thanks for that Kieth, I do infact have the delphi source code for the app so could change the sql within the app. The only problem being is that i dont have some of the modules required to recompile it.
____________________
If you dont like the way that I ride.......Stop trying to keep up!!!

[Kickstart]

Hi

How complex is the system? What is it all written in? Is it a commercial application?

All the best

Keith
____________________
Traxpics, track day and racing photographs - Bimota Forum - Bike performance / thrust graphs for choosing gearing

[NSR Mick]

No its not commercial app, it was written by a mate of mine i dont see anymore using Delphi 6. I'm pretty sure he used some 3rd party add on modules as he was a Delphi programmer by trade.
____________________
If you dont like the way that I ride.......Stop trying to keep up!!!

[Kickstart]

Hi

What does it do? Possible to rewrite it easily?

All the best

Keith
____________________
Traxpics, track day and racing photographs - Bimota Forum - Bike performance / thrust graphs for choosing gearing

[NSR Mick]

It puts sprint time results into a database and then will create a print out of results, not rocket science but could it be rewritten easily? Not by me thats for sure.
____________________
If you dont like the way that I ride.......Stop trying to keep up!!!

[Kickstart]

Hi

Sounds like it could be done fairly easily. Does it need to be done on a laptop at a drag strip, or is it for publishing the results online?

All the best

Keith
____________________
Traxpics, track day and racing photographs - Bimota Forum - Bike performance / thrust graphs for choosing gearing

[NSR Mick]

times are inputed pretty much live, the commentator has a laptop allowing him to view riders previous runs that day, and theres a machine in the paddock so that riders can check how there doing in their class etc, both of these machines view the data via http pages that are generated by the delphi app. the only time the year will be an issue is after all runs are complete and the results printed for the trophy presentation at the end of the day. at no other time is the date in the table seen or used.
____________________
If you dont like the way that I ride.......Stop trying to keep up!!!

[Kickstart]

Hi

Any more details on the http generation? Is it just a static html document generated every so often, or some kind of dynamic page (eg, php / asp script running on a web server).

All the best

Keith
____________________
Traxpics, track day and racing photographs - Bimota Forum - Bike performance / thrust graphs for choosing gearing

[NSR Mick]

Its Dynamic, the pages are generated by the delphi app, give me 10 minutes and I'll pm you an address so you can see how it works.
____________________
If you dont like the way that I ride.......Stop trying to keep up!!!