Compilation error: semi colon expected

This occurs on my Win XP2 laptop using B4PPC v6.8. The program is a simple sqlite data search widget in which I type in a search string and get back the relevant data. It works perfectly when run from the IDE but it won't compile (optimised) for a Windows.exe, giving the error message:
"Error message: error CS1002: ; expected
Line number: 38
Line: Temp=Temp & recList.Item(9) & " " recList.Item(10) & " " & recList.Item(11)"
[If anyone knows how to copy and paste these error messages, please let me know!]

So what's this about a semi-colon being expected?
The entire program is attached, but not the 40 Megabyte database it looks at. I wrote it for use on the laptop, so haven't attempted to compile it for my iPAQ.

Many thanks in advance for any clues how to fix this.

Caravelle

You are missing an ampersand. This is a classic error that the IDE lets you get away with but the compiler doesn't.

Temp = Temp & recList.Item(9) & " " & recList.Item(10) & " " & recList.Item(11)

Ah, that fixed it, thanks.

The Delphi equivalent I'm used to wouldn't have run from the IDE with a concatenation error like that - I sort of assumed that if it runs OK, it's OK.

So how come the error message says that a semi-colon is expected? One for the confusing error message list?

Thanks again, now to move on to the next one.

Caravelle

Caravelle said:

So how come the error message says that a semi-colon is expected?

Click to expand...

For optimised compilation the code is translated to C#. In C# every statement is terminated by a semi-colon. Without the ampersand the optimising compiler translated the code into an erroneous form where the C# compiler thought that a statement had ended without the terminating semi-colon. Hence the error.

<sigh>

As far as I'm concerned the main purpose of any programming language other than a variety of C is to avoid the user having to work with any variety of C !

Thanks

Caravelle