1. Richard Albrecht
  2. Valentina Reports ADK
  3. Понедельник, Август 02 2021, 08:12 PM
  4.  Подписаться через email
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 Ответ принят
So the problem was in the datasource string, after fixing it the error has gone.
Комментарий
There are no comments made yet.
Richard Albrecht Ответ принят
I'm essentially stopped until this gets resolved.
Комментарий
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 sorry but the only export I see is from a preview.
Комментарий
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 don't see an export option?

Also do you want an excel of sample data?
Комментарий
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 Ответ принят
Yes, exact same query
Комментарий
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 Ответ принят
No Sorting
Комментарий
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.
  • Страница :
  • 1


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

Categories

Announcements & News
  1. 0 subcategories
Valentina Studio
  1. 2 subcategories
Valentina Server
  1. 4 subcategories
Valentina Database ADK
  1. 0 subcategories
Valentina Reports ADK
  1. 0 subcategories
Other Discussions
  1. 2 subcategories
BETA Testing
  1. 0 subcategories
Education & Research
  1. 0 subcategories