AW: SubWCRev program no more supporting VBA in V1.9x ?
From: Matthias Schäfer <Matthias.Schaefer_at_kopfweb.de>
Date: Thu, 30 Mar 2017 10:50:57 +0000
Dear Mr. Kueng,
thanks for your quick reply. I have further information for you:
The Script is perfectly working with 1.7x version. Updated to 1.9.x SubWCRevCOM.exe causes the "error":
· Excel freezing
· SubWCRevCOM.exe consuming 12 to 13 % CPU Power constantly
· SubWCRevCOM.exe memory grows and grows ... up to 1.3 Gigabytes (then I stopped the process, otherwise it would grow further and bigger).
I made an error handling for the complete script, so it is ensured that the VBA Code is not causing the problem (Please remember that its working fine for years now with V1.7x).
Because there is no documentation for VBA (except some snippets from internet and sourcecode etc.) I was not able to find out how to check out the result out of "oSvn.GetWCInfo ActiveWorkbook.FullName, 1, 1". Do you have an idea how it has to look like in VBA?
There are two instances to control the errors:
· "On Error GoTo NoSVN" (to the end of script) --> for the whole script (if there is any error the whole script is stopped!)
· "If oSvn.IsSvnItem = True Then" --> The second instance, that checks if the file is in SVN-control. (If the data is no SVN-Item the script stops, too)
o Even if the file has no SVN-Control the SubWCRecCom.exe is opened and seems to struggle. That must have something to do with this code:
I reckon, that when the object is created in VBA with this command, the SubWCRec.exe is started. Then there is an not identified error, but the SubWCRev still runs with memory overflow without being stopped. Excel is working after killing the process SubWCRev manually.
Something must be changed, because if I replace the SubWCRevCOM.exe to Version 1.7x it is working great. Rest of files in this case are still on 1.9.5.
Mit freundlichen Grüßen / Best regards
KOPF GmbH / Kapbachstr. 6 / 76829 Landau / Germany
Tel.: +49 6341 91767-33 / Fax : +49 6341 91767-50
Geschäftsführer: Oliver Kopf - HRB Landau Nr. 3090 - Amtsgericht Landau
On 22.03.2017 12:08, Matthias Schäfer wrote:
> we do have a problem regarding the COM device (SubWCRev.exe) in V1.9x.
> In VBA we are creating/using |SubWCRev.object ||and several methods
> are based on it, have a look at your documentation:|
> Unfortunately this works for 1.7.8 version, but not longer for 1.9x
> The question is, have you changed the SubWCRev.exe including the
> support of VBA |SubWCRev.object? The examples website is showing only
> C# commands, too.|
> |In earlier days there was an example of VBA based code and program.
> Could it be possible that VBA is no longer supported in 1.9x
VBA is still supported, as is any other language capable of using COM objects.
> |Is VBA code changed? The documentation has no info regarding VBA code.|
Nothing has changed regarding VBA.
> |Have a look to the code crashing the |SubWCRev.exe:
the code screenshot doesn't show the whole script. Also I don't know
what 'IsProp' and 'UpdateProp' do - SubWCRev doesn't provide those.
What I can see is that you don't check the return value of
'oSvn.GetWCInfo' - if that returns S_FALSE, then there was an error
while fetching the svn status and all subsequent calls to oSvn will
return false data.
Also: you mentioned that it doesn't work anymore. But what exactly
doesn't work anymore? Which part of your script? What happens and what
do you expect to happen instead?
What happens if you run
$ svn st path
where 'path' is the string from ActiveWorkbook.FullName ?
that link seems to be 'internal' as you mentioned. Not really useful to
-- ___ oo // \\ "De Chelonian Mobile" (_,\/ \_/ \ TortoiseSVN \ \_/_\_/> The coolest interface to (Sub)version control /_/ \_\ http://tortoisesvn.net ------------------------------------------------------ http://tortoisesvn.tigris.org/ds/viewMessage.do?dsForumId=4061&dsMessageId=3224565 To unsubscribe from this discussion, e-mail: [users-unsubscribe_at_tortoisesvn.tigris.org].
This is an archived mail posted to the TortoiseSVN Users mailing list.