473,387 Members | 1,687 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,387 software developers and data experts.

type mismatch

jg
in VB 2005 the class myClass, I have

Dim someStringArrary() As String
---
sub New()
MyBase.New()
... 'values assigned to elements of someStringArrary
End Sub

......

Function xxx() As String()
return someStringArrary
End Function

Function getxxxSz() As Integer
Return
End Function

In vbscript I have
set objMyClass = CreateObject(("myClass.myClass") " work fine so far
....
Dim strResults()
strResults = objMyClass.xxx " give me type mismatch
I even tried in vbscript
Dim strResults(), sz
sz = objMyClass.getxxxSz()
ReDim strResults(sz) ' I tried with and without this statement'
strResults = objMyClass.xxx " still give me type mismatch

what should I do instead of getting values element by elements
Nov 21 '05 #1
3 2137
ng
jg wrote:
in VB 2005 the class myClass, I have

Dim someStringArrary() As String
Function xxx() As String()
return someStringArrary
End Function
In vbscript I have
set objMyClass = CreateObject(("myClass.myClass") " work fine so far
....
Dim strResults()
strResults = objMyClass.xxx " give me type mismatch
I believe strings are handled differently in .Net than in vbscript. In
..Net they are actually classes, but in vbscript they are strings. Maybe
you could have your class return an array, and in vbscript dim the
strResults() as Any?

Just a guess.

Tom
what should I do instead of getting values element by elements

Nov 21 '05 #2
jg
"as any" in VB script?
Or do you mean as VB DOT?

"ng" <t_*****@yahoo.com> wrote in message
news:EX*****************@bignews1.bellsouth.net...
jg wrote:
in VB 2005 the class myClass, I have

Dim someStringArrary() As String
Function xxx() As String()
return someStringArrary
End Function
In vbscript I have
set objMyClass = CreateObject(("myClass.myClass") " work fine so far
....
Dim strResults()
strResults = objMyClass.xxx " give me type mismatch

I believe strings are handled differently in .Net than in vbscript. In
.Net they are actually classes, but in vbscript they are strings. Maybe
you could have your class return an array, and in vbscript dim the
strResults() as Any?
Just a guess.

Tom
what should I do instead of getting values element by elements

Nov 21 '05 #3
perhaps in the vbScript, try:

Dim strResults
set strResults = objMyClass.xxx


"jg" <ju**@mail.pls> wrote in message
news:Ot**************@TK2MSFTNGP14.phx.gbl...
in VB 2005 the class myClass, I have

Dim someStringArrary() As String
---
sub New()
MyBase.New()
... 'values assigned to elements of someStringArrary
End Sub

......

Function xxx() As String()
return someStringArrary
End Function

Function getxxxSz() As Integer
Return
End Function

In vbscript I have
set objMyClass = CreateObject(("myClass.myClass") " work fine so far
....
Dim strResults()
strResults = objMyClass.xxx " give me type mismatch
I even tried in vbscript
Dim strResults(), sz
sz = objMyClass.getxxxSz()
ReDim strResults(sz) ' I tried with and without this statement'
strResults = objMyClass.xxx " still give me type mismatch

what should I do instead of getting values element by elements

Nov 21 '05 #4

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

5
by: Arun Wadhawan | last post by:
Hello MY SQL Server is causing me this problem : Microsoft VBScript runtime error '800a000d' Type mismatch: 'ident' >>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>> I am getting from...
1
by: LJgrnl | last post by:
I've got a type mismatch error that's driving me nutty. Variable blnNoData has the initial value False. If a recordset comes back empty (both .EOF and ..BOF are true) then blnNoData is set to...
1
by: Mark | last post by:
Hi - I tried this in VS.Net, and also in the Web Matrix code below: - but I am getting a type mismatch error. The sql statement runs perfectly from within the Access Query Designer. Can anyone...
7
by: middletree | last post by:
I've been messing with this for hours, and have been to various sites, including Aaron's site, and am truly stumped. The short version: in SQL Server, the 4 fields in question are datetime. I...
4
by: Mike | last post by:
I am getting a type mismatch error when I do a bulk insert. ---Begin Error Msg--- Server: Msg 4864, Level 16, State 1, Line 1 Bulk insert data conversion error (type mismatch) for row 1, column...
3
by: amitbadgi | last post by:
I am getting teh following error while converting an asp application to asp.net, Exception Details: System.Runtime.InteropServices.COMException: Type mismatch. Source Error: Line...
1
by: Brett | last post by:
I have a form that calls a method within a DLL. By clicking a button on the form, the DLL is instantiated and the SaveOutlookMessage() method invoked. The DLL code copies messages from Outlook to...
6
by: Howard Kaikow | last post by:
I'm doing a VB 6 project in which I am trying to protect against type mismatch errors. Is the process any different in VB .NET? Here's what I'm doing in VB 6. I have an ActiveX DLL. The...
5
by: kjworm | last post by:
Hello Everyone, I have been fighting with a type mismatch error for many hours today and I can't seem to find what the problem is. Hopefully it is more than a missing apostrophe! I have isolated...
19
by: Lysander | last post by:
I have written a query that takes three integers representing day,month and year, forms a date from them and compares this date to the date the record was entered and returns any records where the...
0
by: taylorcarr | last post by:
A Canon printer is a smart device known for being advanced, efficient, and reliable. It is designed for home, office, and hybrid workspace use and can also be used for a variety of purposes. However,...
0
by: Charles Arthur | last post by:
How do i turn on java script on a villaon, callus and itel keypad mobile phone
0
by: ryjfgjl | last post by:
If we have dozens or hundreds of excel to import into the database, if we use the excel import function provided by database editors such as navicat, it will be extremely tedious and time-consuming...
0
by: ryjfgjl | last post by:
In our work, we often receive Excel tables with data in the same format. If we want to analyze these data, it can be difficult to analyze them because the data is spread across multiple Excel files...
0
by: emmanuelkatto | last post by:
Hi All, I am Emmanuel katto from Uganda. I want to ask what challenges you've faced while migrating a website to cloud. Please let me know. Thanks! Emmanuel
1
by: nemocccc | last post by:
hello, everyone, I want to develop a software for my android phone for daily needs, any suggestions?
0
by: Hystou | last post by:
Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can...
0
jinu1996
by: jinu1996 | last post by:
In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven...
0
by: Hystou | last post by:
Overview: Windows 11 and 10 have less user interface control over operating system update behaviour than previous versions of Windows. In Windows 11 and 10, there is no way to turn off the Windows...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.