Search:

Type: Posts; User: phvwijk

Page 1 of 51 1 2 3 4

Search: Search took 0.02 seconds.

  1. Replies
    17
    Views
    560

    Re: DD utilities in Studio are PAINFULLY slow

    Most likely when it tries to create the FD file. Running against that problem too in tables with a lot of fields


    Peter
  2. Replies
    17
    Views
    560

    Re: DD utilities in Studio are PAINFULLY slow

    I am one of those persons who likes the filelist in a for me understandable order and also in alphabetical so often use the move filelist entry but it does not take that long and it are 550+ entries...
  3. Replies
    17
    Views
    560

    Re: DD utilities in Studio are PAINFULLY slow

    Most likely will use the DF_Attribute "logic" so will work for DF tables and SQL with one set of logic.

    Peter
  4. Re: Date in 2024 and the New cSQLExecutor class

    Peter

    That is what wrote it is faster and a lot faster. but missing stuff to make it useful beyond basic calls. As soon as date or DateTime fields are involved it gets messy.

    It is still...
  5. Re: CSQLExecutor support stored procedures with IN/OUT parameters ?

    Samuel,

    The way I found is using (ok I know you use DB2) the SQL Management studio and toy a bit

    The following works


    EXECUTE [dbo].[SP_Agent_of_Trademark] @sVertegen_ID = ${Test}
  6. Replies
    5
    Views
    193

    Re: DF application speed problem on network

    Pretty simple answer but possible not what you want to read. Move to SQL use a SQL query to get the data and it will be faster the your fastest time.

    Peter
  7. Re: Date in 2024 and the New cSQLExecutor class

    Harm,

    Here the result from an DateTime2 field in tDataSourceRow, the last field with DF_NUll_Date

    16682

    I would expect for 01/01/0001 12:00:00 AM


    Peter
  8. Re: Date in 2024 and the New cSQLExecutor class

    And there is a Unix Date too 32 bit which will give problems like the Y2K and 64 bits




    In this is stuff where have to deal with.

    Problem is that the way the cSQLExecutor class it results...
  9. Re: Date in 2024 and the New cSQLExecutor class

    Harm,

    For me it is show stopper bug. I will not be able to use 24 and the cSQLExecutor class (will have to use the old class)

    But did some work on the different results the class can give,...
  10. Re: Date in 2024 and the New cSQLExecutor class

    Harm

    some more



    Struct tOrderHeader
    { Name="Order_Number" }
    Integer iOrder_Number
    { Name="Order_Date" }
  11. Replies
    11
    Views
    363

    Re: SQL Filters and Constraints

    You were right

    Peter
  12. Re: Date in 2024 and the New cSQLExecutor class

    Harm,

    I hardly ever worked with Dataflex Reporter but downloaded the beta and made a small change to the Table Usage sample.
    Added 2 fields to the report a date and a datetime

    Added the...
  13. Re: Date in 2024 and the New cSQLExecutor class

    Harm

    Let me make a simple example and an simple question



    Set_Attribute DF_DATE_4_STATE_ONLY_ON_PARSE to False


    Result of a SQL Query with an MSSQL Database defined by DF so has...
  14. Date in 2024 and the New cSQLExecutor class

    This has been the topic of multiple posts.

    I have been testing with the RC and these are my findings.

    Testing Situation.

    Converted OrderEntry to MSSQL
    Added 2 fields to OrderHeader

    ...
  15. Replies
    11
    Views
    363

    Re: SQL Filters and Constraints

    Take a look in the data_set class.



    { Visibility=Private }
    Procedure Constrain
    Integer iFile
    Send OnConstrain
    Forward Send Constrain
    Get...
  16. Replies
    11
    Views
    363

    Re: SQL Filters and Constraints

    Forward Send onConstrain ?


    Peter
  17. Replies
    20
    Views
    787

    Re: ESQL and ROWLOCK

    I do the same trick but with processes so no 2 users can run the same process at the same time.
    When for what ever reason something goes wrong and the "lock" stays because the user got during the...
  18. Re: Is there somewhat a partial password_state?

    Think with some code it can be done within datadictionairy. But in this case with credit card 4 form are acceptable solution

    Peter
  19. Re: Header tooltips for old grids not working anymore

    I did on Dataflex conference in 2009 a presentation how to convert the old grid to the new grid,.

    But there are 2 sides. You have the dbGrid morphing in the cdbCJGrid. That is fairly easy to do,...
  20. Replies
    2
    Views
    174

    Re: Stored Procedure and RowId

    RowID is an DF concept tp be able to work with database where no recnum is defined. There is not a lot of information where RowID is based on. So will be hard to get in a SQL query.

    You do not...
  21. Replies
    10
    Views
    583

    Re: Structs and memory

    Bot using mYSQL but looks like there is a Bulk import option. I use that with MsSql and that is blazing vast.
    After that use an SQl query to sort out what you need and process that or with SQL...
  22. Re: DF 19.1 windows application closes now and then without any message

    Modern networks, is that a translation for Wireless network? Complaining the computer on the network is slow. When you ask and how is your mobile working..... Oh terrible but yes that is wireless so...
  23. Re: Restoring a database created on a home pc to an AD environment

    MSSMS create while restoring a temp file. Most likelt the SQL server user does not have right on your user directory, which makes sense.

    Put the backup in the by the MSSQL install created backup...
  24. Thread: cIniFile

    by phvwijk
    Replies
    9
    Views
    500

    Re: cIniFile

    Sort of the list of File Extensions at the moment.

    And a setting to save with or with UTF8 per workspace. Monetioned before but makes life a lot easier



    Peter
  25. Replies
    5
    Views
    280

    Re: SQLExecutor and 01/01/2001

    There was no Alpha although......

    Possible all not easy to fix, I can believe that, But something that does not work and cannot be used in easy DF way, but in a limited way and yes it is SQL so...
Results 1 to 25 of 1269
Page 1 of 51 1 2 3 4