Problem INCSTR in VARCHAR field with SQL

monteiro

Hi all,

I have a problem using function INCSTR in a VARCHAR field with SQL database.

In a table the highest value ID (like a field "No.") is 11.000. When I use INCSTR in FDB returns 11.001. But in SQL returns 10.000. SQL considers 9.999 as the highest value.

Someone know how to fix this? Is a configuration in SQL?

Thanks in advance.

monteiro

Hello,

I found solution myself and would like to share: there is a property in some fields (the incompatibles with SQL, like CODE) called "SQL Data Type". This property has 3 options: Integer, Variant and Varchar (this is default).

In my problem, I needed use INCSTR in a CODE field, but works wrong. The highest number was 11.000, but was considered 9.999 (because VARCHAR is a text). So, I changed the "SQL Data Type" to Integer and then runs right.

But this works only if the CODE field has numbers (0-9). Unlettered.