Search:

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.

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...

I see it too. This was not intentional.
Will log this as a bug and fix for next revision.

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...

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

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


...

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...

Thanks, I will take a look.

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...

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...

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...

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...

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...

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)...

In your MSSQLDRV.INT put the following setting:

; MAP_DFDATE_TO_SQLTYPE: The SQL Server type when creating new DF_DATE columns
; Allowed values:
; ...

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...

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...

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...

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...

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...

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...

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...

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.

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...

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...

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...