1. Richard Albrecht
  2. Valentina Reports ADK
  3. 月, 8月 02 2021, 08:12 PM
  4.  メールで購読
In Xojo the ADK is throwing an exception:
Datasource error: "Error( 1054 ) 42S22: "Unknown column 'Speaker' in 'field list'"".

However in Studio the same sql runs fine.

I'm don't have anything named speaker in the report???
コメント
There are no comments made yet.
Sergey Pashkov 承諾済みの回答
Is there any sorting/grouping set for this report on the Data tab?
コメント
There are no comments made yet.
Richard Albrecht 承諾済みの回答
No Sorting
コメント
There are no comments made yet.
Sergey Pashkov 承諾済みの回答
And this report runs fine with the same SQL query in VStudio, correct?
コメント
There are no comments made yet.
Richard Albrecht 承諾済みの回答
Yes, exact same query
コメント
There are no comments made yet.
Sergey Pashkov 承諾済みの回答
Could you please export this report and attach it here?
コメント
There are no comments made yet.
Richard Albrecht 承諾済みの回答
I don't see an export option?

Also do you want an excel of sample data?
コメント
There are no comments made yet.
Sergey Pashkov 承諾済みの回答
On the project tab, you can select report and export it using the context menu.

No, data is not necessary for now.
コメント
There are no comments made yet.
Richard Albrecht 承諾済みの回答
I'm sorry but the only export I see is from a preview.
コメント
There are no comments made yet.
Richard Albrecht 承諾済みの回答
Do you want to move this to Skype, I'm Hawkcode

We've used it before.
コメント
There are no comments made yet.
Richard Albrecht 承諾済みの回答
I'm essentially stopped until this gets resolved.
コメント
There are no comments made yet.
Sergey Pashkov 承諾済みの回答
So the problem was in the datasource string, after fixing it the error has gone.
コメント
There are no comments made yet.
  • ページ :
  • 1


There are no replies made for this post yet.
However, you are not allowed to reply to this post.