Question about all this new SQL stuff

[lukerduker123]

Howdy! So, after having a friend that's computer literate explain SQL to me in the dumbest of terms, I have to ask a rather strange question! Is it possible to use the SQL function to EDIT a scenario? That is, can I create a tank company in SQL and replace another company with it? I hope that makes sense!

[zovs66]

No you can't do that.

[zovs66]

To do what you are asking you don't use SQL. You can do one of two things.

1. Use ScenHack to change one (or more than one) unit to another unit.
2. Use the Editor and change one unit to another unit (r).

The SQL in ScenHack is just to query (ask) for some information, not edit/change data.

[DRG]

It's all about the information in a scenario not changing it and it's really more of a development tool we added because it would be useful if you were looking for a specific battle or designer and the search feature can zero in on things like that quickly but a lot of the more detailed SQL work wouldn't be of interest to the average gamer unless you wanted to find all the scenarios that used a specific tank or unit or how many times a particular unit graphic was used but it can have many uses depending on how curious you are and how much time you want to expend finding out things.

EDIT-------------Like this


select count(*) from sData uName
where ( LOWER(uName) like "%sherman%")

will reveal that "shermans" are used 740 times in *MY* scenario folder

and if you ask


select count(*) from sData uName
where (( LOWER(uName) like "%sherman%") or ( LOWER(uName) like "%m4%"))

the answer is 1831

and this

select count(*) from sData icon
where icon =125

tells me graphic 125 ( a Cromwell ) is used 84 times in the scenarios in my folder

And this

select distinct ScenNum, sTitle, Unit, uName from sData
where icon =125

will tell me exactly where they are

The number of scenarios has grown past the point anyone with a normal memory could remember or find ones but you might remember a keyword and that may be all you need to find one you played years ago but can't remember the number of it

[lukerduker123]

Ah, I get it now! Thanks. It's a shame that there isn't a way to easily copy and paste certain units from one scenario to another, but that's the way the cookie crumbles, I reckon.