Re: MOD Operator - Visual Basic Discussion Boards

Re: VB 2005 - sharing a COM dll problem

LittleEd23-Mar-07 4:08

23-Mar-07 4:08

thks

I am running .NET 2.0.50727

1. was using RegAsm ver 1.?? previously. Now using ver 2.0.50727.42 and I can register - I have done this now as indicated with the /tbl & /codebase as indicated on 2 machines with success.

Recall I am trying to use the objects in excel(.exe) through the VBA interface.

I find:

1. If I regsiter in an arbitrary directory on a client machine some interesting effects. When i try and instantiate I get "run-time error '-2147024894 (8007002)' File or assembly name "MyClass", or one of its dependencies, was not found"

2. If I regsiter in the excel.exe directory on a client machine, i try and instantiate I get
"run-time error '-2146234105 (80131107)' The format of the file "MyClass" is invalid.

had a sniff around, these errors have been seen before but I haven't found a solution to them.

In an attempt to "back-engineer" I have built some simple classes on a non-local machine (a machine that throw errors when I try and use classes from my local machine)... and after registration they work perfectly (!) on my local machine. Interestingly classes I build on the non-local machine do not function of the excel version of the non-local machine.

So although not solved some progress. Going to check Excel versions across machines and that .NET frameworks are consistent.

cheers

Re: VB 2005 - sharing a COM dll problem

Dave Kreskowiak23-Mar-07 13:26

Dave Kreskowiak

23-Mar-07 13:26

LittleEd wrote:
o although not solved some progress. Going to check Excel versions across machines and that .NET frameworks are consistent.

My next two suggestions! Big Grin | :-D

Dave Kreskowiak
Microsoft MVP - Visual Basic

Re: VB 2005 - sharing a COM dll problem

LittleEd26-Mar-07 5:09

LittleEd

26-Mar-07 5:09

OK think we are there ...

Client machines were looking to run (& debug) using a V1 release under NET. It was quite a pain finding how to amend this setting.

Tried editing the registry

HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\VisualStudio\8.0\AD7Metrics\Engine\{449EC4CC-30D2-4032-9256-EE18EB41B62B}

and adding & setting this entry:

CLRVersionForDebugging=V2.0.50727

..with no effect.

Stumbled upon a solution: edit (or create if necessary) excel.config.exe.xml file to look like

<configuration>
<startup>

<supportedruntime version="v2.0.50727">
<requiredruntime version="v2.0.50727">

& I placed a copy in the same dir as the excel.exe file. All COM classes now available, debugger works fine etc.

Should be *careful* on backward compatability issues but that's not a concern for me.

thanks for your interest,
GH
Laugh | :laugh:

Re: VB 2005 - sharing a COM dll problem

LittleEd21-Mar-07 13:13

LittleEd

21-Mar-07 13:13

I should have added that i've tried to register the type library itself - the code ran fine but the still app didn't let me instantiate objects

the code I used was in the spirit of the link below
http://www.devx.com/vb2themax/Tip/18443

Smile | :)

MOD Operator

codemunkeh21-Mar-07 8:16

codemunkeh

21-Mar-07 8:16

OK, there doesn't seem to be a concise definition of this anywhere, particularly on MS's pathetic excuse for help.

With the Mod operator, I've always thought that it return everything after the decimal point. Eg,
12 / 5 = 2.4
Therefore I'd expect
12 Mod 5 = 4

In practice, the result seems to be a random number, dependant on the current temparature in Kelvin, the number of times you have double clicked in the last six seconds and a random number between 12 and 47. From some testing...

12 Mod 5 = 2 ?? Mad | :mad:

In fact, from the source code on MSDN, they say that
10 Mod 3 = 1

All I really need it for is working out if a Byte is even or not. If anyone can dare to explain, I'm sure it'll be useful.

Yet another spam post on yet another forum!
I am the lazy one, who sleeps as it suits him, codes what he wishes, and has many years to look forward to.
I love being a student.

Re: MOD Operator

Don Trainer21-Mar-07 8:25

Don Trainer

21-Mar-07 8:25

MOD Returns the remainder left over after the first number is divided by the second number

12/5 is 2 with a remainder of 2 Therefore 12 MOD 5 is 2

10/3 is 3 with a remainder of 1 Therefore 10 MOD 3 is 1

and so forth.

Don

Re: MOD Operator

codemunkeh21-Mar-07 8:30

codemunkeh

21-Mar-07 8:30

So it's the actual difference...dang. Been thinking in decimal too long. Well that was clever - especially since it's only taken me 3 years to notice...
Ooo...this could have new uses.

Thanks muchly.

Yet another spam post on yet another forum!
I am the lazy one, who sleeps as it suits him, codes what he wishes, and has many years to look forward to.
I love being a student.

Re: MOD Operator

Don Trainer21-Mar-07 8:34

Don Trainer

21-Mar-07 8:34

Yuppers such as a quick and dirty way to check to see if the current minute is a multiple of 5 without all the fancy if minute/5 = int(minute/5) and so forth. Use it for all sorts of cool stuff.

Glad to be of help...

Re: MOD Operator

TwoFaced21-Mar-07 8:35

TwoFaced

21-Mar-07 8:35

The documentation says it computes the remainder. http://en.wikipedia.org/wiki/Remainder[^] Seems like the documentation was spot on to me Smile | :)

Workflow Tracking When Workflow is hosted as a Web Service

Don Trainer21-Mar-07 8:16

Don Trainer

21-Mar-07 8:16

Hey out there,
I have a Sequential workflow I have written and published as a web service. I need to implement tracking for the workflow. However, every example I have found shows hosting the workflow inside another ASPNet application. I have tried multiple iterations and variations on this theme and nothing seems to work correctly. I don't get any faults running the WF, however, Microsofts "WorkflowMonitor" sample app crashes with a "GetWorkflow" error every time I fire up the workflow. I then have to MANUALLY clean up the tracking database before it will run properly again.

Does anyone out ther have a SIMPLE VB.Net based example of doing this?

Thanks,
Don Trainer

Progressbar and SOAP service

Liottru21-Mar-07 7:57

Liottru

21-Mar-07 7:57

Hi to all,

I have create a little client to test a webservice called EuroCv.eu
The problem is the connection and the time of the connection to the server. I need to create a simple progressbar to show the progress of the request to the server.

Is it possible?

Thanks

How can I check some hardware presence in puter?

JUNEYT21-Mar-07 7:33

JUNEYT

21-Mar-07 7:33

Hello!

I would like to know how can I check the following listed below in runtime: I need these before user runs the application.

a. If a keyboard exists in puter
b. If a mouse exists in puter
c. What is the current screen resolution
d. What is the total available memory
3. Operating System (addressing numeric values)

Thank you. Unsure | :~

What a curious mind needs to discover knowledge is noting else than a pin-hole.

Re: How can I check some hardware presence in puter?

The ANZAC21-Mar-07 11:18

The ANZAC

21-Mar-07 11:18

You can access the last three in my.computer but the first two i'm not sure.

Posted by The ANZAC

Typed dataset not generating update and delete statements

steve_rm21-Mar-07 4:19

steve_rm

21-Mar-07 4:19

Hello,

VS 2005.

I have created a typed dataset. I have dragged some tables from the server explorer on to the designer.

However, one of my tables it doesn't auto generate the update and delete statements. I have tried configuring the table adapter. I have clicked the advanced options and checked all 3 options. And on methods to generate I have checked all 3 options again. I click next and it will tell you what statement it will generate, but the delete and update are not included.

Also, when I use this in code for finding by the primary key, it doesn't have a method for it.
i.e

<br />
datarow = me.dataset.software.findBySerialID(serialID)<br />

The method FindBySerialID doesn't exist.

Does anyone know why this is happening.

Thanks in advance,

Steve

to call a webservice using javascript, vb.net inline code

shyamts21-Mar-07 2:40

shyamts

21-Mar-07 2:40

Hi.,

How to call a webservice using javascript in vb.net, inline code using Ajax. I am using Atals, i have two textbox, first text box is autocomplete, autocomplete done using ajax, after the first text box is filled, the second text box should be filled depending on the first text box values.

Please guide me with examples.

Thanks and Regards
Shyam

Re: to call a webservice using javascript, vb.net inline code

Dave Kreskowiak21-Mar-07 3:23

Dave Kreskowiak

21-Mar-07 3:23

This is a question better suited for the ASP.NET or Web Development forums.

Dave Kreskowiak
Microsoft MVP - Visual Basic

XML is driving me insane in vb.net ! Please help

JUNEYT21-Mar-07 1:39

JUNEYT

21-Mar-07 1:39

I am posting the same problem 2nd time. Sorry for that but the strange thing is happening in the function. It suppose to display a message but it is giving me "An error occurred creating the form. See Exception.InnerException for details. The error is: Object reference not set to an instance of an object." error message. It loads the file there in no problem. Either keys and values exist in the file also. The message boxes display nothing. What is causing the problem? Thank you. Cry | :((

Here is my code:

The file is under application.startuppath /bin/debug directory


Private Function GetCnfgParameter(ByVal MyKey As String) As String

   Dim DocXml As New XmlDocument
   Dim NodeXml As XmlNode = Nothing

   DocXml.Load(Path.Combine(Application.StartupPath, "app.xml"))
   NodeXml = DocXml.DocumentElement.SelectSingleNode("//configuration/AppDefaultValues/add[@key=""" & MyKey & """]")
        If TypeName(NodeXml.Attributes.GetNamedItem("value")) <> "Nothing" Then
            NodeXml = NodeXml.Attributes.GetNamedItem("value")
            MsgBox(NodeXml.Value)
        Else
            'No @ mykey attribute in attributes collection
            MsgBox("Could not find the @mykey attribute as in a <add mykey=''> element.")
        End If

        Return NodeXml.Attributes.GetNamedItem("value").Value

        NodeXml = Nothing

    End Function

What a curious mind needs to discover knowledge is noting else than a pin-hole.

Re: XML is driving me insane in vb.net ! Please help

coolestCoder21-Mar-07 1:53

coolestCoder

21-Mar-07 1:53

JUNEYT wrote:
NodeXml = DocXml.DocumentElement.SelectSingleNode("//configuration/AppDefaultValues/add[@key=""" & MyKey & """]")

This line is prone to "Object reference not set to an instance of an object" error. You will have to check whether NodeXml is nothing before using it further.

JUNEYT wrote:
TypeName

What is this used for ? and what does it returns ?

JUNEYT wrote:
<> "Nothing"

If you are trying to compare returned value for nothing / null then you will have to write -

not ({expression} is nothing)

not ({expression} = nothing)

Use the 'is' keyword if the return of the {expression} is a reference type else use '='

"A good programmer is someone who looks both ways before crossing a one-way street." -- Doug Linder

coolestCoder

Re: XML is driving me insane in vb.net ! Please help

JUNEYT21-Mar-07 2:04

JUNEYT

21-Mar-07 2:04

Thank you very much I solved the problem. The back slash was causing it.

cheers! Big Grin | :-D

What a curious mind needs to discover knowledge is noting else than a pin-hole.

Urgent 002

Sarfaraj Ahmed21-Mar-07 1:24

Sarfaraj Ahmed

21-Mar-07 1:24

Also,

I got two Table Name Volume and VolumeLessons .
I have used a Query to make a SingleTable name Query_Volume_VolumeLessons, now this table is inside my code or Prject not in SQL SERVER DataBase.

Now I need to pull data from Query_Volume_VolumeLessons to make another two table name Query_Volume_Sector and Query_Volume_Themes for further work and then lots of thing....................

Please help me

Sarfarj Ahmed

Re: Urgent 002

Tirthadip21-Mar-07 1:59

Tirthadip

21-Mar-07 1:59

In my opinion instead of making a table, populate a dataset with your query as because you can easily loop through your dataset to do your operation....

Tirtha

"A man can ride on your back only when it is bent....."

Re: Urgent 002

Sarfaraj Ahmed21-Mar-07 2:24

Sarfaraj Ahmed

21-Mar-07 2:24

Thanks for your reply

I have alredy added a DataSet name Publications where I have add three tables.
Table(0) is Query_Volume_VolumeLessons
Table(1) is Query_Volume_Sectos
Table(2) is Query_Volume_Themes

Also put data on Table(0) from SQL SERVER DataBase

Now How can I put data to Table(1) From Table(0) , using a sqlQuery

Thanks

Sarfarj Ahmed

Re: Urgent 002

PlayByTheRules21-Mar-07 2:23

PlayByTheRules

21-Mar-07 2:23

Sarfaraj Ahmed wrote:
Urgent 002

This is a useless subject line. Please use more appropriate subject lines in future. Hint: No appropriate subject line will include the word "urgent"

Re: Put data to Table(1) from Table(0)

Sarfaraj Ahmed21-Mar-07 2:26

Sarfaraj Ahmed

21-Mar-07 2:26

Thanks for ur Email
Can you help me?

Sarfarj Ahmed

SUBJECT LINE

leckey21-Mar-07 5:36

leckey

21-Mar-07 5:36

This is the 6th post you've title with "urgent" or "please help." Many people will avoid answering these questions with such subjects.

_________________________________________
You can't fix stupid, but you can medicate crazy.

Use Ctrl+Left/Right to switch messages, Ctrl+Up/Down to switch threads, Ctrl+Shift+Left/Right to switch pages.