Left() does not work anymore 2

• Aug 8, 2003

• #2

Helen1greece

Technical User

Jun 4, 2003

85

GR

Are you sure that you typing correct. Does the function Right() work?

 

Upvote 0 Downvote

• Aug 8, 2003

• Thread starter
• #3

IlseDC

Programmer

Mar 24, 2003

49

BE

Yes, I'm typing it correct.
The right function does not work.

I did not change my sources.
I just copied the sources from my old PC and I tried to compile them on my new PC. On my new PC VB6 does not recognize LEFT() and RIGHT().

 

Upvote 0 Downvote

• Aug 8, 2003

• #4

stravis

Programmer

Jun 28, 2003

420

US

Can you give an example of the code that is not "working". Also, please describe in more detail what you mean by "not working".

 

Upvote 0 Downvote

• Aug 8, 2003

• #5

MarkSweetland

MIS

Aug 30, 2000

1,177

US

Check the project references to see that none of the selected references is labled "MISSING."

It's possible one of the references is not present on your new PC...


Mark

"You guys pair up in groups of three, then line up in a circle."
- Bill Peterson, a Florida State football coach

 

Upvote 0 Downvote

• Aug 9, 2003

1
• Thread starter
• #6

IlseDC

Programmer

Mar 24, 2003

49

BE

There is no reference missing.

Here is my code:
myString = Left(strBuffer, lngLen)

When I run my application I get an error.
The compiler thinks that "Left" is an array, and does not see that this is the Left() function.

I changed my code to mystring = VBA.Left(strBuffer, lngLen) and this does work.

What reference must I add so that I don't have to add "VBA." before the left function?

Ilse

 

Upvote 0 Downvote

• Aug 9, 2003

• #7

petevick

Technical User

Jul 25, 2001

131

GB

Have you checked that you have not used left as a variable or function.

 

Upvote 0 Downvote

• Aug 9, 2003

• Thread starter
• #8

IlseDC

Programmer

Mar 24, 2003

49

BE

Left is not used as variable or function.

The strange thing is that the sources can be compiled on my old PC. I copied them to my new PC (without changing the code) and there the sources can not be compiled.

 

Upvote 0 Downvote

• Aug 9, 2003

• #9

vbrocks

Technical User

Jul 17, 2003

958

US

Are you using it with correct syntax?
dim x as string
x = left ("Hostess" , 4)
x should equal "Host"

If you just have left with no arguments then the compiler will think it is an array ..... left () etc.

 

Upvote 0 Downvote

• Aug 9, 2003

• #10

vbrocks

Technical User

Jul 17, 2003

958

US

I am saying that perhaps the variables were not initialized properly before the statement in question was performed. Causing the compiler to think it is an array.

 

Upvote 0 Downvote

• Aug 9, 2003

• Thread starter
• #11

IlseDC

Programmer

Mar 24, 2003

49

BE

Yes, I use the correct syntax !

 

Upvote 0 Downvote

• Aug 9, 2003

• #12

CCLINT

Programmer

Feb 22, 2002

3,802

DE

1. Put your cursor on the word "Left" and hit SHIFT-F2.
What happens?

2. What happens when you use the Right function?

3. Does the Left$() function work?

If Left$(), Right(), Right$() work, then you probably have a Control name, (or variable name as petevick mentioned), called "Left".

 

Upvote 0 Downvote

• Aug 9, 2003

• #13

MarkSweetland

MIS

Aug 30, 2000

1,177

US

Since the VBA.Left() does work, I'd look at this MS Article:

http://support.microsoft.com/default.aspx?scid=kb;en-us;276560

Mark

"You guys pair up in groups of three, then line up in a circle."
- Bill Peterson, a Florida State football coach

 

Upvote 0 Downvote

• Aug 9, 2003

• Thread starter
• #14

IlseDC

Programmer

Mar 24, 2003

49

BE

I found the problem.

I have a DLL "dcString.DLL".
On my new PC I installed a new version of this DLL.
This version has an enumeration with left and right.
On my old PC it was still the old DLL without enumeration.
So the new DLL caused the problem.

Thanks all for your advice!

Ilse

 

Upvote 0 Downvote

• Aug 19, 2003

• #15

PeterWallace

Programmer

Apr 28, 2003

210

AU

I am also having a problem with LEFT() and RIGHT()

These two functions were working UNTIL I Added a

WORD report to the Project....

Does WORD have LEFT 'n RIGHT as Constants ?

( Can't see how Military using any Programming Language that does not have Left and Right wotking properly.... )

 

Upvote 0 Downvote

• Aug 19, 2003

1
• #16

CCLINT

Programmer

Feb 22, 2002

3,802

DE

Then use LEFT$() or VBA.LEFT$()

 

Upvote 0 Downvote