Criteria Builder - choice parametr does not respect column type

Answered

Comments

4 comments

  • Official comment

    Thank you for the explanation.

    This is a shortcoming of the current Full-featured demo: when OLE DB or ODBC connection is established, it uses the ANSI SQL/92 syntax provider which fails to load column data types. You can fix the problem by reloading metadata via the corresponding menu item after setting the right syntax provider.

    In the next build, we'll add the possibility to select (and detect) the right syntax provider for these types of connections and fix other connection issues. Right now you can download the updated demo project here.

    Comment actions Permalink
  • Dear Petr,

    Sorry for the late response. Requests to be considered of high priority better asked through support tickets.

    We have failed to reproduce this problem. Please let us know your

    - database server,
    - syntax provider being used,
    - SQL query text,
    - data type of the DocumentType field.

    0
    Comment actions Permalink
  • Avatar
    Petr Veselý

    Hello Sergey,

    Database server:

    flat file - csv

    syntax provider:

    MSAccess

    SQL query text:

    Select *
    From [Data_Sales#csv]

    data type of the DocumentType field:

    object (by OLEDBmetadataprovider)

    Thank you.

     

    0
    Comment actions Permalink
  • Avatar
    Sergey Smagin (Product manager)

    Hello, Petr.

    I am sorry for not replying you on time.

    Do you still have problems with retrieving types in AQB from CSV using MS Jet provider?

    0
    Comment actions Permalink

Please sign in to leave a comment.