Search:

Type: Posts; User: Martin Moleman

Page 1 of 42 1 2 3 4

Search: Search took 0.02 seconds.

  1. Replies
    11
    Views
    120

    Re: Set NOCOUNT ON Question

    It is perfectly fine to use the same connection.


    SQLDisconnect can be used after the ESQL query. It will not actually close the original connection.

    When using a shared connection,...
  2. Replies
    11
    Views
    120

    Re: Set NOCOUNT ON Question

    Why are you using Set NOCOUNT ON / Set NOCOUNT OF here in the first place?
    It is not needed.
    Select Count(*) from Tempchk;

    returns a result set of one row with one column. You should SQLFetch...
  3. Re: Connection is lost with mysql server after 24 hours

    Roel,

    In the MySQL DSN setup in ODBC Administrator there is a checkbox "Enable automatic reconnect". Try turning that on.
  4. Replies
    9
    Views
    393

    Re: Create Index closes the Studio

    I followed your steps, but could not reproduce the issue.

    -Can you provide the Create Table script for this table. Make sure to include the indexes.
    -Also the <table>.int file
    -Can you provide...
  5. Replies
    2
    Views
    235

    Re: DF_FIELD_DEFAULT_VALUE Change

    It's a bug in DataFlex 20.0, although I don't think it causes problems.
    Will be fixed for the next build.

    Thanks for reporting
  6. Re: MySQL behaving different from MSSQL

    latin_bin does not sound correct. It is a binary collating, that does string compares on the binary byte values. It will probably be case sensitive.
    I have no idea why you would not be able to...
  7. Re: MySQL behaving different from MSSQL

    Can you try to choose codeset = latin1 and collation= latin1_general_ci when creating the database.
    Convert the tables again with these settings.
  8. Re: Aplication impact in changing column types from date to datetime

    You can just change it in the Studio Table Editor.
    Change the Type column from 'date' to 'datetime'. Make sure the DataFlex Type column remains 'date'.
    That's all. The restructure process will...
  9. Replies
    10
    Views
    366

    Re: Mysql-df19.1

    You can use the SQL Connect wizard to create the INT files.

    But an alternative approach might be better: Use the SQL conversion wizard to convert directly from SQL Server to MySQL. This will...
  10. Replies
    10
    Views
    366

    Re: Mysql-df19.1

    Your DSN is a 64-bit DSN.
    You should create a 32bit DSN instead.
  11. Replies
    9
    Views
    465

    Re: DB2_DRV not loading anymore - 16.1

    Check the length of your windows PATH environment variable.
    If it gets too long (if I remember correct, above 2048) it can cause database drivers not to load.
    This should be solved in DataFlex...
  12. Replies
    23
    Views
    1,091

    Re: Indexed VDF 19.1 finds in MySQL 8

    This sounds like the finds are not using the proper index, but instead do a table scan.

    Without information on the actual definitions it's hard to tell why this is happening.

    If this works for...
  13. Re: 19.1 SQL Conversion Wizard - mySQL version option

    Are you referring to the df_file_revision in the properties of the table? This shows the version number of the database server. It's not something that can be set.
  14. Replies
    3
    Views
    1,215

    Re: MariaDB and descending index segments

    MariaDb does not support descending index segments.
    You could define a client only index with descending segment. That will work, but it will cause unoptimized Finds, so could be slow.

    MySQL does...
  15. Replies
    2
    Views
    984

    Re: SQLSetParameter appends a space

    I see it too. This was not intentional.
    Will log this as a bug and fix for next revision.
  16. Replies
    15
    Views
    1,553

    Re: DFCONNID vs. table.INT

    This "bad parameter" error was a bug in the SQL Connect/Repair Wizard in DataFlex 19.0.
    Only when started from Database Builder. You can also start the SQL Connect/Repair Wizard from the Studio and...
  17. Replies
    15
    Views
    1,553

    Re: DFCONNID vs. table.INT

    Yes, you should add a cConnection object inside your cApplication object:

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


    ...
  18. Replies
    8
    Views
    1,598

    Re: IS THIS A BUG IN SQLStrLike?

    I see this as well.
    Turns out MySQL uses the backtick character as the identifier quote. Strange enough MySQL does not generate an error when using double quotes, but just returns an empty result...
  19. Replies
    12
    Views
    1,200

    Re: DF19.1 Embedded SQL Issue

    Thanks, I will take a look.
  20. Re: How do I optimize for speed on a remote MSSQL server?

    No, connections can stay open. SQLConnect/SQLDisconnect can be done only once in a program.
    Statements however must be opened and closed (SQLOpen and SQLClose) for each statement you...
  21. Replies
    12
    Views
    1,200

    Re: DF19.1 Embedded SQL Issue

    I don't see anything wrong with this, although I never used Common Table Expressions.
    Is it possible to provide a reproducible case? The create table scripts for the involved tables or a backup of...
  22. Replies
    12
    Views
    1,200

    Re: DF19.1 Embedded SQL Issue

    For the default cursor type (SQL_CURSOR_FORWARD_ONLY) there is still a limitation that variable length columns must be last in the SELECT.
    Variable length columns are 'varchar(max)' or 'text' in...
  23. Re: PSQL 13 install in a MS Terminal Server 2019 Error

    Lookup "Status 11" in the PSQL documentation. There are a number of reasons mentioned than can cause status 11.
    This one sounds like something you should check:

    Or this one: (that I don't...
  24. Re: MySQL Newbie problem (Finding on a file)

    As it turns out the comparison with or without spaces depends on the collation of the MySQL database.

    https://dev.mysql.com/doc/refman/8.0/en/char.html


    The default collation for a new MySQL...
  25. Re: MySQL Newbie problem (Finding on a file)

    Just did a test on converted order entry sample on MySQL and that works for me.


    Open OrderHeader
    Clear OrderHeader
    Find gt OrderHeader by Index.1
    While (Found)...
Results 1 to 25 of 1036
Page 1 of 42 1 2 3 4