SQL Error ...

[TheBoss]

Ive currently been messing around with 2.3 files, .. i was copying and pasting in the STDItems DB when this error happend .. any one no how too fix it ? ...

Many Thanks

TB

http://img186.imageshack.us/my.php?image=29458050ec7.jpg

 

[Fire]

a suggestion is to avoid this, clear out the database and import it as a dump, or csv... im guessing that you were trying to apply the changes live to multiple rows at the same time...

 

[Dookie]

No need to be that drastic Fire.

Get a SQL window up (QueryAnalyzer or right click table and select Open Table > Query), then delete whatever SQL script is already there and replace it with this:

DELETE FROM TBL_STDITEMS
WHERE FLD_ID = 1015

Note: If you use QueryAnalyzer make sure you select the correct database from the drop down box at the top. That will delete the field your working on, you'll have to add it back in again.

Also i take no responsibility if something goes wrong (It shouldn't if you do it right)

 

[TheBoss]

No need to be that drastic Fire.

Get a SQL window up (QueryAnalyzer or right click table and select Open Table > Query), then delete whatever SQL script is already there and replace it with this:

DELETE FROM TBL_STDITEMS
WHERE FLD_ID = 1015

Note: If you use QueryAnalyzer make sure you select the correct database from the drop down box at the top. That will delete the field your working on, you'll have to add it back in again.

Also i take no responsibility if something goes wrong (It shouldn't if you do it right)

Thanks mate worked a treat +1

TB

 

[Gemma]

also the error can pop up now and then if u miss a field when ur adding items etc so watch out for that