1. Richard Albrecht
  2. Valentina Reports ADK
  3. Montag, August 02 2021, 08:12 PM
  4.  Abonnieren via E-Mail
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???
Kommentar
There are no comments made yet.
Sergey Pashkov Akzeptierte Antwort
So the problem was in the datasource string, after fixing it the error has gone.
Kommentar
There are no comments made yet.
Richard Albrecht Akzeptierte Antwort
I'm essentially stopped until this gets resolved.
Kommentar
There are no comments made yet.
Richard Albrecht Akzeptierte Antwort
Do you want to move this to Skype, I'm Hawkcode

We've used it before.
Kommentar
There are no comments made yet.
Richard Albrecht Akzeptierte Antwort
I'm sorry but the only export I see is from a preview.
Kommentar
There are no comments made yet.
Sergey Pashkov Akzeptierte Antwort
On the project tab, you can select report and export it using the context menu.

No, data is not necessary for now.
Kommentar
There are no comments made yet.
Richard Albrecht Akzeptierte Antwort
I don't see an export option?

Also do you want an excel of sample data?
Kommentar
There are no comments made yet.
Sergey Pashkov Akzeptierte Antwort
Could you please export this report and attach it here?
Kommentar
There are no comments made yet.
Richard Albrecht Akzeptierte Antwort
Yes, exact same query
Kommentar
There are no comments made yet.
Sergey Pashkov Akzeptierte Antwort
And this report runs fine with the same SQL query in VStudio, correct?
Kommentar
There are no comments made yet.
Richard Albrecht Akzeptierte Antwort
No Sorting
Kommentar
There are no comments made yet.
Sergey Pashkov Akzeptierte Antwort
Is there any sorting/grouping set for this report on the Data tab?
Kommentar
There are no comments made yet.
  • Seite :
  • 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