Search:

Type: Posts; User: Martin Moleman

Page 1 of 41 1 2 3 4

Search: Search took 0.02 seconds.

  1. Replies
    6
    Views
    1,078

    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:
    ; ...
  2. Replies
    2
    Views
    236

    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...
  3. Replies
    4
    Views
    606

    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...
  4. Replies
    18
    Views
    816

    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...
  5. Replies
    18
    Views
    816

    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...
  6. 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...
  7. Replies
    16
    Views
    548

    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...
  8. Replies
    9
    Views
    372

    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...
  9. 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.
  10. Replies
    2
    Views
    222

    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...
  11. Replies
    8
    Views
    334

    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...
  12. 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...
  13. Re: VDF 19.0 During edit of system table it automatically converts all fields longer then 15 characters to 15 characters

    Maybe you have more than 1 Sysfile.FD around? The compiler may find an old one.
    Look in the PRN file what SysFile.FD is actually included.
  14. Replies
    18
    Views
    816

    Re: Error 12289

    Some additional information on SQL Server clients:

    Following is a list of available SQL Server clients:
    You can see which one(s) are installed by starting ODBC Administrator (32bit) and looking...
  15. Replies
    18
    Views
    816

    Re: Error 12289

    Mike,

    You mentioned you are using:

    DF18.2, MSSQLDRV.DLL is 6.1.0.32

    This driver version does not recognize "ODBC driver xx for SQL Server" . This ODBC driver did not exist yet when DataFlex...
  16. Re: Error trying to create MSSQL database from new workspace wizard

    Fixed in DataFlex 19.1 Beta 2.
  17. Replies
    13
    Views
    1,337

    Re: MariaDB via ODBC

    The just released DataFlex 19.1 beta 2 has a changed ODBC driver that should work with the latest MySQL and MariaDB versions and MySQL/MariaDB ODBC drivers.

    More info here:...
  18. Replies
    0
    Views
    201

    MySQL/MariaDB support

    DataFlex 19.1 Beta 2 has a changed ODBC driver that should work with the latest MySQL and MariaDB versions and MySQL/MariaDB ODBC drivers.

    We tested with the following environments:

    MySQL...
  19. Replies
    14
    Views
    636

    Re: Studio closes on refresh of table

    I just tried this with DataFlex 19.1 Studio. Created the table with your script and used the original INT file.
    Refresh worked fine with this setup.

    The 19.0 connect/refresh wizard has problems...
  20. Replies
    14
    Views
    636

    Re: Studio closes on refresh of table

    How does the SQL definition of this table look? Especially, what is this PK_emailsig_Recnum index?
    Normally system tables don 't have a recnum column or a recnum index, so I guess that is somehow...
  21. Replies
    2
    Views
    278

    Re: Connect to RECNUM table

    Peter,

    That is correct. On a recnum table the primary index should be the recnum index, so 0. (This is also the case after conversion).
    The primary key is on index.1 however.

    So basically a...
  22. Re: Stored Procedures that use varchar(max) parameters and named parameters

    Fixed for the next 19.1 beta build.


    Clive already tested and confirmed the fix.
  23. Replies
    4
    Views
    471

    Re: Invalid Cursor State

    Not sure if this is going to work. The embedded SQL implementation uses cursors internally and I am not sure what happens if you also explicitly use cursors in your script.

    At the very least you...
  24. Replies
    4
    Views
    471

    Re: Invalid Cursor State

    I don't follow what you are showing here. This is just pseudo code right?

    In general you get "Invalid cursor state" if you try to fetch something from a non-existing or already closed result set....
  25. Re: Stored Procedures that use varchar(max) parameters and named parameters

    Clive,

    Yes, please send me your example and I will take a look.
Results 1 to 25 of 1011
Page 1 of 41 1 2 3 4