The meaning of the "Variable or Field undefined" error message you are getting depends on the context in which you are using it. This error will often occur when you are trying to reference a column from a variable containing a table name. In this situation using an alias will remove this problem. For example, this would cause the error you are getting:
Dim tabname As String tabname = "opentable" Select * From tabname Where tabname.Col1 = "something" Into Selection Browse * From Selection For that to work you would need to do the following: Dim tabname As String Dim colref As Alias tabname = "opentable" colref = tabname + ".Col1" Select * From tabname Where colref = "Something" Into Selection Browse * From Selection Hope this helps, it could of course be due to something else! -----Original Message----- From: Mark Williamson [mailto:[EMAIL PROTECTED]] Sent: 18 May 2002 13:37 To: [EMAIL PROTECTED] Subject: MI-L Variable or Field undefined Hi I have three files file A file B file C file B Includes file A file C Includes file B my main is in file C I am calling a function in file A from file C - assigning the result to a variable, every thing compiles fine but when I run the program I get an error Variable or Field <function name> not defined can anyone shed any light on this?? Thanks Mark ******************************************************************** This Email and any attachments has been virus checked upon receipt at the OS and is free of all known viruses. ******************************************************************** *************************************************************** For more information on Ordnance Survey products and services, visit our web site at http://www.ordnancesurvey.co.uk *************************************************************** --------------------------------------------------------------------- List hosting provided by Directions Magazine | www.directionsmag.com | To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
