Search:

Type: Posts; User: Martin Moleman

Page 1 of 43 1 2 3 4

Search: Search took 0.05 seconds.

  1. Replies
    6
    Views
    471

    Re: Descending Index segments AuroraDB

    What AuroraDB version and what MySQL ODBC driver version are you using?

    As you say descending index segments are only supported with MySQL 8 and later. Earlier versions just ignore any DESC...
  2. Re: ODBC_DRV + MYODBC - Create column - Incorrect index name PRIMARY

    Thanks for reporting, I could reproduce the issue. We will look into it.
  3. Replies
    19
    Views
    727

    Re: Can't load DLL DFBTRDRV

    When moving to DataFlex 2020 it is most logical to have both the 32bit and 64bit database clients installed side by side. It will not blow up anything. Windows has a setup where 32-bit and 64-bit...
  4. Replies
    19
    Views
    727

    Re: Can't load DLL DFBTRDRV

    Some further explanation how this works:

    64bit applications can only load 64bit dll’s
    32bit applications can only load 32bit dll’s

    DataFlex 20 Studio comes only as a 64bit application.
    ...
  5. Re: BUG: Get_attribute via ODBC queries the incorrect database!

    This is caused by a bug in MariaDB ODBC driver. It does not happen with MySQL or other ODBC drivers.
    We actually already found and fixed the issue in odbc_drv for DataFlex 20.0.

    We intend to...
  6. Replies
    8
    Views
    433

    Re: VDF Studio + SQL Server Connection

    So the connection is working.

    The INT file seems OK as well. If you can open the table with this INT file it should be OK.

    Only remaining issue is creation of the .FD file? Maybe the existing...
  7. Replies
    19
    Views
    727

    Re: Can't load DLL DFBTRDRV

    DataFlex Studio 20.0 is a 64bit application. It can only load 64bit components (dll's). You must have a 64bit PSQL client installed to be able to load DFBTRDRV.
    What (client) version of PSQL are...
  8. Replies
    8
    Views
    433

    Re: VDF Studio + SQL Server Connection

    So you have a connection ID defined in 2 places. In dfconnid.ini (managed connection) and mssqldrv.int.
    You should have only one definition. So what happens if you remove the definition in...
  9. Replies
    8
    Views
    433

    Re: VDF Studio + SQL Server Connection

    Can you open the table in Studio Table Editor? If yes, how does df_file_login in the properties panel look?

    Did you define a managed connection with SQL connection manager? Can you test connect...
  10. Re: Conversion to SQL Express 2019 (VDF 19.1)

    Do you have a cConnection object in your program.src ?


    Object oApplication is a cApplication
    Set pbPreserveEnvironment to False
    Set peHelpType to htHtmlHelp


    Object oConnection...
  11. Replies
    8
    Views
    354

    Re: print directly

    Sometimes it takes a little longer: https://support.dataaccess.com/Forums/showthread.php?35393-New-Array-Question&p=358328#post358328


    This deserves it's own name: The Cheng Effect!
  12. Replies
    3
    Views
    357

    Re: A2:DB2_DRV find errors

    All fixed for next build.
  13. Thread: Mssql

    by Martin Moleman
    Replies
    1
    Views
    499

    Re: Mssql

    This was already fixed for the next DataFlex 20 build.

    Thanks for reporting.
  14. Re: Changing Table with depending scalar value function not possible

    In SSMS go to the menu Tools >> Options >> Designers and uncheck “Prevent Saving changes that require table re-creation”
  15. Re: mySql / MariaDB Date type min value 1000-01-01

    I experimented a bit with dates on MySQL and MariaDB and on both accept dates between 0001-01-01 and 1000-01-01 perfectly well.
    Although the doc says there is no guarantee it works, I would not...
  16. Replies
    18
    Views
    3,538

    Re: MSSQL Driver error

    It's not the ODBC driver for SQL Server that can lift this restriction, but the DataFlex SQL Server driver (mssqldrv) 6.3, that comes with DataFlex 19.1.

    With mssqldrv 6.3 you can change the...
  17. Replies
    18
    Views
    3,538

    Re: MSSQL Driver error

    You get this when variable length columns (varchar(max) or text) or not last in the Select.


    Select Name , Address, Comments from Customer
    If Comments is varchar(max), it must be last column in...
  18. Replies
    18
    Views
    2,424

    Re: ESQL Question/Problem

    You probably need to call SQLNextResultSet.
    We discussed the same issue before in this thread: https://support.dataaccess.com/Forums/showthread.php?65962-Set-NOCOUNT-ON-Question I posted an example...
  19. Replies
    18
    Views
    2,424

    Re: ESQL Question/Problem

    It's the other way around:
    Set Nocount on
    suppresses messages like "x rows affected"

    In multi statement scripts and stored procedures you should set Nocount ON
  20. Replies
    5
    Views
    388

    Re: ODBC driver truncates field names

    Peter,

    I could now reproduce this. Working on a fix.
  21. Replies
    5
    Views
    388

    Re: ODBC driver truncates field names

    Peter,

    If you have a reproducible example we can use, that would be great.

    Also, what exact Pervasive.SQL ODBC driver are you using?
  22. Replies
    1
    Views
    201

    Re: Fulltext search on a MySQL server

    Never tried it, but it seems possible.

    https://dev.mysql.com/doc/refman/8.0/en/fulltext-search.html
    https://www.mysqltutorial.org/mysql-full-text-search.aspx/
  23. Replies
    22
    Views
    722

    Re: Set NOCOUNT ON Question

    I am unable to reproduce a 'lock up'. I tried several variations but for me this just works.

    Once again, why are you using Set NoCount On/Off in the first place? What are you trying to accomplish...
  24. Replies
    22
    Views
    722

    Re: Set NOCOUNT ON Question

    I made a small change in SQLFetchResultsetValues in sql.pkg (for DF19.1) that should solve the "Invalid cursor state" error.

    Could you give this a try?

    Drop sql.pkg in DataFlex 19.1\pkg folder...
  25. Replies
    22
    Views
    722

    Re: Set NOCOUNT ON Question

    I tried to reproduce the issue, but could not get a lockup.
    This is my test procedure:


    Procedure TestESQLRowCountDemo
    Handle hoConnection
    Handle hoStmt


    ...
Results 1 to 25 of 1062
Page 1 of 43 1 2 3 4