Toggle Submenu
  1. Forums
  2. Recent
  3. Kategorien
  4. Tags
  5. Benutzer
Antwort hinzufügen Antworten ansehen (11)

Gelöst Datasource error: "Error( 1054 ) 42S22: "Unknown column 'Speaker' in 'field list'"".

  1. Richard Albrecht
    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.
Antworten (11)
Sergey Pashkov
Sergey Pashkov Akzeptierte Antwort
Is there any sorting/grouping set for this report on the Data tab?
Kommentar
There are no comments made yet.
  1. vor über einem Monat
  2. Valentina Reports ADK
  3. Permalink zu dieser Antwort
Richard Albrecht
Richard Albrecht Akzeptierte Antwort
No Sorting
Kommentar
There are no comments made yet.
  1. vor über einem Monat
  2. Valentina Reports ADK
  3. Permalink zu dieser Antwort
Sergey Pashkov
Sergey Pashkov Akzeptierte Antwort
And this report runs fine with the same SQL query in VStudio, correct?
Kommentar
There are no comments made yet.
  1. vor über einem Monat
  2. Valentina Reports ADK
  3. Permalink zu dieser Antwort
Richard Albrecht
Richard Albrecht Akzeptierte Antwort
Yes, exact same query
Kommentar
There are no comments made yet.
  1. vor über einem Monat
  2. Valentina Reports ADK
  3. Permalink zu dieser Antwort
Sergey Pashkov
Sergey Pashkov Akzeptierte Antwort
Could you please export this report and attach it here?
Kommentar
There are no comments made yet.
  1. vor über einem Monat
  2. Valentina Reports ADK
  3. Permalink zu dieser Antwort
Richard Albrecht
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.
  1. vor über einem Monat
  2. Valentina Reports ADK
  3. Permalink zu dieser Antwort
Sergey Pashkov
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.
  1. vor über einem Monat
  2. Valentina Reports ADK
  3. Permalink zu dieser Antwort
Richard Albrecht
Richard Albrecht Akzeptierte Antwort
I'm sorry but the only export I see is from a preview.
Kommentar
There are no comments made yet.
  1. vor über einem Monat
  2. Valentina Reports ADK
  3. Permalink zu dieser Antwort
Richard Albrecht
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.
  1. vor über einem Monat
  2. Valentina Reports ADK
  3. Permalink zu dieser Antwort
Richard Albrecht
Richard Albrecht Akzeptierte Antwort
I'm essentially stopped until this gets resolved.
Kommentar
There are no comments made yet.
  1. vor über einem Monat
  2. Valentina Reports ADK
  3. Permalink zu dieser Antwort
Sergey Pashkov
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.
  1. vor über einem Monat
  2. Valentina Reports ADK
  3. Permalink zu dieser Antwort
  • Seite :
  • 1


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