ESdat Forums
»
Forums
»
ESdat
»
320 ORDER BY... errors
 Rank: Newbie
Groups: Registered
Posts: 2
|
We keep getting this error: 320 ORDER BY clause (Min(Sample.[Sampled_Date_Time])) conflicts with DISTINCT It happens almost every time we try to run soil results into a chemistry output table. We cannot get a table due to these errors. Knight attached the following image(s):  Tablulation error.PNG (34kb) downloaded 14 time(s).You cannot view/download attachments. Try to login or register.
|
|
|
|
|
|
Rank: Administration
Groups: Registered, Administrators Posts: 498  Location: Byron Bay Was thanked: 19 time(s) in 19 post(s)
|
Hello, Can you confirm you are running the latest version (4.4.14), and if that gives the error. If so can you provide the details requested at http://www.ESdat.net/ESd...ase_problems_or_bugs.htm so we can resolve this as soon as possible? Many thanks, Warwick
|
|
|
|
|
|
Rank: Administration
Groups: Registered, Administrators Posts: 498 Location: Byron Bay Was thanked: 19 time(s) in 19 post(s)
|
This was resolved by upgrading to the current version. As it didn't happen all the time it is likely that it occurred when a later version of ESdat had been used for that data, and it was not longer compatible with the older version that had this error.
|
|
|
|
|
|
ESdat Forums
»
Forums
»
ESdat
»
320 ORDER BY... errors
You cannot post new topics in this forum.
You cannot reply to topics in this forum.
You cannot delete your posts in this forum.
You cannot edit your posts in this forum.
You cannot create polls in this forum.
You cannot vote in polls in this forum.