Ian,
 
If the other advice hasn't already helped then you may find that using an alias to reference the column will solve the problem.  I often have problems in code when I'm trying to get the value of a column and they nearly always revolve around the need to have an alias for the column name.  To do this:
 
Dim aColumn As Alias
aColumn = sTabname + "." + sCol_1
 
Dim sResult As String
sResult = aColumn
 
Regards,
Colin


From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Ian Robertson
Sent: 19 July 2006 12:28
To: [email protected]
Subject: [MI-L] Problem with parameters in Sub

Hi,
 
I'm having some difficulty passing parameters in a Sub procedure.
 
The MapBasic help gives the following as a example of using a sub procedure. It includes a value "2" as a parameter.
Declare Sub Cube(ByVal original As Float, cubed As Float)
.
.
Call Cube( 2,  result)

 
I've adapted this to pass some text values for a table name and some column titles:
 
Declare Sub Table_to_Array( byval sTabname as string, sCol_1 as string, sCol_2 as string, sType as string) 
.
.
Call Table_to_Array("T_Usrn", "street_text", "street_reference_number", "Streets")
 
The outcome is an error on compilation stating:
Found [street_text] while searching for [An identifier]
 
 
Where am I going wrong?
 
Thanks
 
Ian
 
 
.

This email is only intended for the person to whom it is addressed and may contain confidential information. If you have received this email in error, please notify the sender and delete this email which must not be copied, distributed or disclosed to any other person.

Unless stated otherwise, the contents of this email are personal to the writer and do not represent the official view of Ordnance Survey. Nor can any contract be formed on Ordnance Survey's behalf via email. We reserve the right to monitor emails and attachments without prior notice.

Thank you for your cooperation.

Ordnance Survey
Romsey Road
Southampton SO16 4GU
Tel: 023 8079 2000
http://www.ordnancesurvey.co.uk

_______________________________________________
MapInfo-L mailing list
[email protected]
http://www.directionsmag.com/mailman/listinfo/mapinfo-l

Reply via email to