Search:

Type: Posts; User: Roman Köhler

Page 1 of 17 1 2 3 4

Search: Search took 0.01 seconds.

  1. Re: Speedproblems with SQL-View with 3 tables

    Hi Samuel,

    I have tried to transfer the example to the Orderentry example of DataAccess. This might make troubleshooting a bit more difficult. Therefore I give you the original definitions now....
  2. Re: Restriction to order with special articles

    I didn't tell you in my posting, that I work with SQL. It was my fault, I'm sorry.

    But the embedded version works with SQL, too.

    So it was interesting to try out both ways and compare them with...
  3. Re: Speedproblems with SQL-View with 3 tables

    Hello, Vincent,

    even if it is true that the Connectivity Kit has no knowledge of how many tables are included, it is still the case that 3-table views do not work that easily.
    I have already...
  4. Re: Speedproblems with SQL-View with 3 tables

    Hello Samuel
    I have found a solution. It is a bit unconventional, but it works.

    Assuming that my assumption is correct that Dataflex cannot handle 3-table views, I have thought about how to work...
  5. Re: Speedproblems with SQL-View with 3 tables

    Thank you Samuel for your answer,


    I have matching indexes that connect the 3 tables with each other via IDs.
    Because I abstracted the example, I did not enumerate all indexes. This can not be...
  6. Re: Restriction to order with special articles

    Thanks Michael for your help.
    I tried it and it worked out perfectly.
    But I was glad that another suggestion with SQL came, because it works much faster.
  7. Re: Restriction to order with special articles

    Thanks Evertjan,

    your suggestion was great.
    I thought that the problem should be solved with SQL.
    Michael's option works as well, but it is much slower.
  8. Re: Restriction to order with special articles

    Hi Michael,

    I have deleted the connection of the Item-DataDictionary and added a function with SQL query to the Order-DD.

    Now I get all orders with the desired item. (Super)
    But unfortunately...
  9. Re: Restriction to order with special articles

    Hi Edgar,

    The structure of my example should be based on the Orderentry database. (Order is relationally linked to items)
    Order.number --> Items.ordernumber

    Orders 1,2,3 are only...
  10. Speedproblems with SQL-View with 3 tables

    Hello,

    The described speed problems refer ONLY to DataflexViews/-SelectionLists.
    There are no problems in the SQL-Managemant-Studio.


    I have a SQL-View, where 3 tables are linked together and...
  11. Restriction to order with special articles

    Hello,

    I am looking for a way to constrain orders where a certain article appears in the order articles. But the filtered orders should be shown completely with all articles.

    Example:
    order 1...
  12. Re: Changing Table with depending scalar value function not possible

    So first of all thank you for your tips and effort.

    Unfortunately no tip helped. The reason became clear after I had a closer look at "schemabinding".

    If you provide functions or views with the...
  13. Re: Changing Table with depending scalar value function not possible

    Hello, Martin,

    I changed the setting in the SSMS and wanted to make the changes now.
    But after pressing the save button I got the following warning:


    Table "person"
    - Warning: The following...
  14. Re: Changing Table with depending scalar value function not possible

    Hello,

    first of all, "Thank you for your timely responses."

    @Steven
    On your advice I tried to change the field length with the SQL Management Studio. But it failed with the following error...
  15. Wie kann ich eine Tabelle ändern für die es eine Skalarwertfunktion gibt?

    Hallo liebe Leute,

    mein aktuelles Problem hängt mit dem SQL-Server 2017 und Skalarwertfunktionen zusammen.

    In meiner SQL-Datenbank baue ich immer mehr Scalarwertfunktionen ein, damit...
  16. Changing Table with depending scalar value function not possible

    Hello, everybody,

    my current problem is related to SQL-Server 2017 and scalar value functions.

    In my SQL database I am adding more and more scalar value functions, so that SQL-queries , -views...
  17. Replies
    2
    Views
    486

    Re: Handle of a DDO

    Thank you Peter for your quick response.

    I've tried it and it works fine.
  18. Replies
    2
    Views
    486

    Handle of a DDO

    Hello,

    I have a problem in getting the handle of a DDO, which is NOT in the DDO-tree of the Main_File.
    Both files are completely unrelated, but I need to save records in the other file, when...
  19. Replies
    8
    Views
    3,879

    Re: Fehlermeldung bei Aufruf eines Themes

    Hi Peter,
    I've solved the problem and published the source-code.
    Please look at this.
    The problem was the ResourceImagePath, which isn't created, when you haven't installed the VDF-Client or...
  20. Replies
    8
    Views
    3,879

    Re: Fehlermeldung bei Aufruf eines Themes

    So, I've found a solution (debugger thank you).
    I have seen that the procedure LoadResourceImagesFromFile in cCJCommandBarSystem.pkg sets the directory for the styles.
    So, I have copied this...
  21. Replies
    8
    Views
    3,879

    Re: Fehlermeldung bei Aufruf eines Themes

    Stephen,
    yes. After your first answer, I've tried this immediately.
    Our folder-structure now looks in this way:
    11555
    In both styles-folders are the following files: Office2007.dll,...
  22. Replies
    8
    Views
    3,879

    Re: Fehlermeldung bei Aufruf eines Themes

    Hi Stephen,

    I recognize the problem.

    None of the clients has an installed client-version. We don't want to update over 30 PCs for every new Version of VDF.
    There's a directory on our...
  23. Replies
    8
    Views
    3,879

    Solved: Fehlermeldung bei Aufruf eines Themes

    Hallo liebe Leute,

    ich hätte da mal wieder ein Problem:

    Ich will meinem Programm ein (vermeindlich) schöneres Aussehen verpassen. (Mit haben die Beispiele von VDF19 gut gefallen)
    Also schnell...
  24. Replies
    2
    Views
    2,091

    Re: Variable Prozedurnamen

    Hallo Jan,

    vielen Dank für Deine schnelle Antwort. Ich werde sie gleich ausprobieren.
    Also wenn das klappt:
    - dann kann ich ca 1000 Programmzeilen wieder rausschmeißen
    - dann kann ich das kaum...
  25. Replies
    2
    Views
    2,091

    Variable Prozedurnamen

    Hallo liebe Dataflex-Entwickler(innen),
    hat jemand von Euch eine Idee, besser noch eine Lösung, wie ich folgendes Problem gelöst bekomme?

    Jede dbView hat einen Objektnamen.
    Jede dvView hat eine...
Results 1 to 25 of 409
Page 1 of 17 1 2 3 4