Sql

Al_Mac

UPDATE tablename SET fieldname = 1 WHERE field name = n AND fieldname = 'a';

Same statement in the few different SQL verions I've come across.
:beer:

kingpuck

how is your remote access set up? I think you might be better trying to fix that, I assume you are paying a fee for support of the database and they might be a bit funny if you start messing about with it.

I have seen on occasions before where this has been the case and the comapny supporting the software have refused to fix the problem without adding an additonal charge because no-one was supposed to touch it.

statman

You are probably right about that . They usually log in using remote admin (Radmin) but as that isn't working it is leaving me completely stuck! Surely just a change of a 0 to a 1 isn't going to do any harm??

BoltonMinx

All SQL commands are the same, yes, but you still need to access the RDBMS using some method.. thats why I asked what type of SQL software the OP has. Running an UPDATE statement is also pretty dangerous if you dont know what you're doing

statman

Well as you can see I don't really know what I am doing. It may be easier to try to sort the Radmin out and let them dial in! The problem there is I will have to call someone out to do that which may take a while (or cost a lot).

kingpuck

I have never used radmin but I can't imagine it's that hard to fix.

Is the software running? are the cables from the modem ok, is it getting a dialtone if you try and ringout?

check the drivers for your modem to make sure that they didn't get corrupt when your server crashed and make sure that the software is pointing to the right device for listening to the incoming calls.

It could just be a case that the settings have been reset to default or that somehow the program has stopped listening for incomming connections.

beaker141

statman wrote:

Well as you can see I don't really know what I am doing. QUOTE]

Careful now !

I can help if it is Oracle database. Although like many have suggested here it can be dangerous, not necessarily if you don't know what you are doing, but because of things such as constraints and perhaps triggers. Triggers are sometimes used to detect a value changing, and then change a load of related items elsewhere in different tables. If you are not familiar with the structure of the tables, and the logic of how it all relates together I would be tempted to leave well alone until your guys can dial in.

If you want to try messing, then providing any triggers that are implemented are done so correctly, ie only commit, when you commit, then you can test things out a bit to see the effect of your action.

In a SQLplus session, or some other tool you may have, you should be able to run update queries, then do a select query to see what the data now looks like, and then type rollback; to undo the update you just performed. A word of caution with Oracle, if you exit without issuing a rollback then it will auto commit the change you have made.

wolfman

statman wrote:

Our new software update seems to have decided to attach an item to every product code we use. The software house have said it may be because the item id is 0 (which it is). In my ignorance I am thinking that if I get into the table and change the item id to lets say 1 then the connection will stop happening. Am I oversimplyfying it?

I'd leave playing around with the database if you're not an expert, especially changing id's, changing them may cause relational problems. Do you know which table and record, and what effect it will have?

Also if you did make any changes and made the situation worse how would that stand with the support team? If I were you I'd try and get your server online again.

I'd dispense any advice on making changes from other people until you've given them a more detailed description of what is required, and also more detail about the database, such as it's schema.

statman

thanks to all, I think I'd better gather some more info and report back tomorrow as I don't want to do more harm than good.

student100

statman wrote:

Surely just a change of a 0 to a 1 isn't going to do any harm??

LOL! Depends what the 0 or the 1 represents...

http://www.dilbert.com/comics/dilbert/archive/dilbert-20050508.html