Hi All,

I have an error when importing some data from a spreadsheet into R6 following the upgrade to 6.13, I have searched but couldn't find a similar case. Basically when importing a simple spreadsheet I get the following error message:

operating system  : Windows XP Service Pack 2 build 2600
system language   : English
system up time    : 5 hours 14 minutes
program up time   : 5 minutes 27 seconds
processor         : Intel(R) Pentium(R) 4 CPU 2.80GHz
physical memory   : 558/1270 MB (free/total)
free disk space   : (C:) 5.27 GB (R:) 9.96 GB
display mode      : 1280x1024, 32 bit
process id        : $cd4
allocated memory  : 18.75 MB
command line      : RecorderApp.exe /2032570
executable        : RecorderApp.exe
exec. date/time   : 2008-11-04 08:45
version           : 6.13.3.182
madExcept version : 2.7h
exception class   : EOleException
exception message : Column "#master.Record_No" is invalid in the ORDER BY clause because it is not contained in either an aggregate function or the GROUP BY clause.

main thread ($81c):
0055fd9e RecorderApp.exe ADODB                       TADOCommand.Execute
0055fcf8 RecorderApp.exe ADODB                       TADOCommand.Execute
0055fcd8 RecorderApp.exe ADODB                       TADOCommand.Execute
0062ba94 RecorderApp.exe DatabaseAccessADO       909 TdmDatabase.ExecuteSQL
008dc2ce RecorderApp.exe IWTableRule             581 TTableRule.Apply
008e6c80 RecorderApp.exe IWColumnMappingClasses 1673 TImportFile.ApplyTableRules
00901480 RecorderApp.exe Import                  183 TfraImport.GenerateImportDatabase
00901330 RecorderApp.exe Import                  152 TfraImport.Execute
008fd805 RecorderApp.exe ImportWizard            339 TfrmImportWizard.ChangePage
008fd279 RecorderApp.exe ImportWizard            189 TfrmImportWizard.btnNextClick
004b4048 RecorderApp.exe Controls                    TControl.Click
004a9160 RecorderApp.exe StdCtrls                    TButton.Click
0046ff09 RecorderApp.exe Buttons                     TBitBtn.Click
004a9254 RecorderApp.exe StdCtrls                    TButton.CNCommand
004b3eb0 RecorderApp.exe Controls                    TControl.WndProc
004b6f0f RecorderApp.exe Controls                    TWinControl.WndProc
004a9024 RecorderApp.exe StdCtrls                    TButtonControl.WndProc
006f42d4 RecorderApp.exe XPMenu                 2928 TControlSubClass.ControlSubClass
7c90f0a5 ntdll.dll                                   RtlAnsiStringToUnicodeString
004b3c80 RecorderApp.exe Controls                    TControl.Perform
004b7047 RecorderApp.exe Controls                    DoControlMsg
004b769f RecorderApp.exe Controls                    TWinControl.WMCommand
004b3eb0 RecorderApp.exe Controls                    TControl.WndProc
004b6f0f RecorderApp.exe Controls                    TWinControl.WndProc
004a9024 RecorderApp.exe StdCtrls                    TButtonControl.WndProc
00445985 RecorderApp.exe Classes                     TList.Delete
004b6b8c RecorderApp.exe Controls                    TWinControl.MainWndProc
004528d8 RecorderApp.exe Classes                     StdWndProc
7e41b8fe user32.dll                                  SendMessageW
7e41f658 user32.dll                                  CallWindowProcA
004b6ff3 RecorderApp.exe Controls                    TWinControl.DefaultHandler
004b4450 RecorderApp.exe Controls                    TControl.WMLButtonUp
004b3eb0 RecorderApp.exe Controls                    TControl.WndProc
004b6e41 RecorderApp.exe Controls                    TWinControl.WndProc
004a9024 RecorderApp.exe StdCtrls                    TButtonControl.WndProc
006f42d4 RecorderApp.exe XPMenu                 2928 TControlSubClass.ControlSubClass
004b3c80 RecorderApp.exe Controls                    TControl.Perform
004528d8 RecorderApp.exe Classes                     StdWndProc
004b6b8c RecorderApp.exe Controls                    TWinControl.MainWndProc
004528d8 RecorderApp.exe Classes                     StdWndProc
7e4196c2 user32.dll                                  DispatchMessageA
004d4de3 RecorderApp.exe Forms                       TApplication.ProcessMessage
004d4e1a RecorderApp.exe Forms                       TApplication.HandleMessage
004d503a RecorderApp.exe Forms                       TApplication.Run
0099f832 RecorderApp.exe RecorderApp             317 initialization

The spreadsheet looks like this:

species                         date       site                         grid    recorder
briza media    01/01/2008       altarstone    nt1535    A name
briza media    01/01/2008       altarstone    nt1535    A name
briza media    01/01/2008       altarstone    nt1535    A name

As further tests:

- I've rolled back to version 6.10 and the import works
- I've un-installed and re-installed the standard validation add-in which didn't help
- I've replaced the new validation add-in with the previous version which didn't help

Has anyone else seen this?

Regards,
Tony