Search:

Type: Posts; User: Martin Moleman

Page 1 of 41 1 2 3 4

Search: Search took 0.02 seconds.

  1. 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.
  2. 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...
  3. Replies
    2
    Views
    656

    Re: SQLSetParameter appends a space

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

    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...
  5. Replies
    15
    Views
    1,114

    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


    ...
  6. Replies
    8
    Views
    1,016

    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...
  7. Replies
    12
    Views
    881

    Re: DF19.1 Embedded SQL Issue

    Thanks, I will take a look.
  8. 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...
  9. Replies
    12
    Views
    881

    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...
  10. Replies
    12
    Views
    881

    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...
  11. 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...
  12. 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...
  13. 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)...
  14. Replies
    6
    Views
    1,961

    Re: SQL and Crystal Dates

    In your MSSQLDRV.INT put the following setting:

    ; MAP_DFDATE_TO_SQLTYPE: The SQL Server type when creating new DF_DATE columns
    ; Allowed values:
    ; ...
  15. Replies
    2
    Views
    365

    Re: Conversion Question

    Does the table have overlaps? In that case Table Editor will show the DataFlex types instead of SQL types.

    There is also a Studio setting that can cause this: Tools/Configure Studio/Database/Edit...
  16. Replies
    4
    Views
    762

    Re: Max recnum

    In SQL recnum is implemented as an integer with a max value of 2,147,483,647.
    So still a couple of centuries to go...
  17. Replies
    18
    Views
    1,106

    Re: Error 12289

    The 2 jpgs are the same?

    Anyway I now see you are using Pervasive.SQL and with old/new driver you mean the Pervasive.SQL ODBC driver. Not the DataFlex ODBC connectivity kit.
    You are using...
  18. Replies
    18
    Views
    1,106

    Re: Error 12289

    What ODBC driver are you talking about ? You mention Pervasive.SQL, so are you using a Pervasive ODBC driver to get to Pervasive? Or is this SQL Server somehow?
    What exactly is your program doing...
  19. Re: creating a column in DF Table Editor vs. SQL

    DataFlex does not really know about nulls. It cannot (easily) distinguish between an empty string and a NULL value for example.

    In SQL world NULLs are very common and have impact on the way SQL...
  20. Replies
    16
    Views
    786

    Re: SQLFilters Problem

    Are you using DataFlex ODBC driver to get to PostgreSQL? If so what version?

    STOREDEFAULTSQLFILTERS in Datadict.pkg calls this:


    Get_Attribute DF_FILE_SQL_FILTER of iMain to sOldFilter...
  21. Replies
    9
    Views
    555

    Re: Data Issue

    There is no difference in the SQL Conversion Wizard from the Studio or Database Builder. The Studio actually calls the conversion wizard in Database Builder.

    If there are errors during conversion...
  22. Re: Use SQL to copy records to non-identical database

    Like Starzen mentioned use INSERT INTO SELECT.

    https://www.w3schools.com/sql/sql_insert_into_select.asp

    I just tried on PSQL and it works there as well.
  23. Replies
    2
    Views
    314

    Re: MSSQL Issues in Conversion to 19.1

    This error: usually means there is an index mentioned in the INT file, where that index does not exist on the SQL backend.

    For example:
    Removed the index Vendor002 in SQL Studio, but my...
  24. Replies
    8
    Views
    485

    Re: Mssql-error

    Never seen this error before, but when you google the error text, it seems to be caused by database corruption.

    This is one of the links that has some tips how you can find out and possibly fix...
  25. Re: DF_FILE_RECORD_LENGTH returning incorrect value

    Doen not make much sense to me either.
    What is shown on the parameter tab or the in the DEF file would also do a get_attribute DF_FILE_RECORD_LENGTH.
    When/how exactly do you get the length? Is it...
Results 1 to 25 of 1024
Page 1 of 41 1 2 3 4