Search:

Type: Posts; User: Pepe

Page 1 of 35 1 2 3 4

Search: Search took 0.02 seconds.

  1. Conditionally evaluate TotaFormula calculations

    Hi,



    In a MSSQL based report we have different columns and some of them are Total Formula calculations.


    We need an extra columna whose vale is conditional to any of those Total Formula...
  2. Replies
    1
    Views
    81

    Bar chart with selected columns

    Hi,


    We've got a report with multiple columns.


    We need to have a bar chart with values from only two of those columns


    Is that possible? How?
  3. Thread: Unit tests

    by Pepe
    Replies
    7
    Views
    477

    Re: Unit tests

    Thanks Wila!
  4. Thread: Unit tests

    by Pepe
    Replies
    7
    Views
    477

    Re: Unit tests

    What is "FitnesseForDataFlex"?

    Salu2

    Pepe
  5. Replies
    19
    Views
    682

    Re: Jenkins error when starting a webapp

    ... then check that all dfcollate.cfg are from 19.x

    I don't know if DAWW was using Jenkins in 19.1 ....
  6. Replies
    19
    Views
    682

    Re: Jenkins error when starting a webapp

    We never had this problem with 19.x even in applications (500 + sites) deployed in all "flavours" and OS combinations.

    I would check the dfcollate.cfg (permissions, paths, ...) and you can always...
  7. Replies
    19
    Views
    682

    Re: Jenkins error when starting a webapp

    I don't think the dfCollate.cfg are compatible . At least not in Spanish and I think in Portuguese neither
  8. Thread: CTE in DAI views

    by Pepe
    Replies
    2
    Views
    216

    Re: CTE in DAI views

    It can't be done

    Thread started by me. Memory, ... oh well :-)

    https://support.dataaccess.com/Forums/showthread.php?57340-From-two-dates-obtain-daily-bed-occupation-in-a-hospital



    Pepe
  9. Thread: CTE in DAI views

    by Pepe
    Replies
    2
    Views
    216

    CTE in DAI views

    Hi,

    I'm trying to create a DAI view using Common Tables Expresions. It executes correctly from the DAI SQL View but when browsing it I get the error:


    -2147217900 : Incorrect syntax near the...
  10. Replies
    11
    Views
    580

    Re: MySQL Dataflex Driver + Licensing

    Thanks Chip. A bit clearer now.

    Salu2

    Pepe
  11. Replies
    11
    Views
    580

    Re: MySQL Dataflex Driver + Licensing

    Just curious of having some thoughts on this (MariaDB, Postgress and others) and how much we usually ignore the licenses agreement of what we think "non-paying software" just because we hear that is...
  12. Replies
    11
    Views
    580

    Re: MySQL Dataflex Driver + Licensing

    Would MariaDB fall in the same restrictions as MySQL?
  13. Replies
    5
    Views
    420

    Re: Chhose columan for a graph

    Neat!

    Thanks

    Pepe
  14. Replies
    5
    Views
    420

    Re: Chhose columan for a graph

    Thanks Bob!

    Salu2

    Pepe
  15. Replies
    5
    Views
    420

    Re: Chhose columan for a graph

    Choose column for a Graph
  16. Replies
    5
    Views
    420

    Chhose columan for a graph

    Hi,

    We've got a report with various columns and we would like to have a graph based on only one of those columns. Is that possible?

    Even better if we could choose which column we want the graph...
  17. Re: Problems with "date" types in a MSSQL database

    The reason for this thread arose from the fact that Dynamic recognises "date" types as string.

    We were doing a proof of concept of using Dynamic as a BI tool for a client. They are not happy of...
  18. Re: Aplication impact in changing column types from date to datetime

    The reason for this thread arose from the fact that Dynamic recognises "date" types as string.


    We were doing a proof of concept of using Dynamic as their BI tool. Final client was not happy of...
  19. Re: Aplication impact in changing column types from date to datetime

    A DateTime is longer than a Date - so you'd have to change all overlaps -

    Yes, we have to.


    or even better - make 'em go away

    That is what we recommenad but ....
  20. Re: Problems with "date" types in a MSSQL database

    Thanks all.


    I'm having a go and try to solve the problem from the tables changing the types to datetime (DAI considers datetime2 as text ). I'm also finding that the tables are populated with...
  21. Re: Aplication impact in changing column types from date to datetime

    Thanks everyone for the input.

    Further to CR 8, all this conversion problema arose due to a proof of concept to use Dynamic AI. In Dynamic AI 6.5.x (latest production version) "date" and...
  22. Re: Aplication impact in changing column types from date to datetime

    Thanks Martin. Do we have to modify the standard 19.0 MSSQLDRV.int?

    Usually we change

    MAP_DFDATE_TO_SQLTYPE datetime

    See below (around line 316 in MSSQLDRV.int)
  23. Re: Aplication impact in changing column types from date to datetime

    Thanks Garret.

    Did that change had any impact on your application?

    Pepe
  24. Re: Problems with "date" types in a MSSQL database

    Thanks for the info. I didn't know that one ;)

    Yes, the database needs to be cleaned but in the process of a "proof of concept" I don't want to go that deep.

    I will try to cast to datetime2....
  25. Aplication impact in changing column types from date to datetime

    A client of ours has a large application in DF19.0 with a MSSQL backend.

    It's running with the standard MSSQLDRV.int and thus Dataflex "date" type columns are "date" type columns in MSSQL.

    We...
Results 1 to 25 of 870
Page 1 of 35 1 2 3 4