John You haven't said whether Table1 and Column1 actually exist. Let's assume that Table1 actually is the name of your table, are you using "column1" in the sense of the 1st column, rather than its actual name? In that case you should use the: Columninfo(Table1,"COL1",COL_INFO_TYPE) construct.
HTH Terry McDonnell -----Original Message----- From: John Crouse [mailto:[EMAIL PROTECTED] Sent: 01 November 2005 07:16 To: Terry McDonnell Subject: MI-L Columninfo Question Hi all, I have a dialog where I need to know if a selected field in a selected table is either a decimal or float. If it is something else, I need to let the user know so that it can be changed. I created a variable "col_type" where col_type = Columninfo(Table1,column1,COL_INFO_TYPE) but cannot get it to recognize the column and indicate the type that the field is. I get an error message saying that column1 is not defined. Any suggestions? TIA John --------------------------------------------------------------------- List hosting provided by Directions Magazine | www.directionsmag.com | To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] Message number: 18545
