Errors compiling in 2019 r2.1

I now have 185 Errors:

Like:
mdGlobals.CheckDate Declaration
Can’t find a type with this name
Function CheckDate(lsDate as DatabaseCursorField) As String

Do I have to change all my recordset.field(“XXX”) calls to .Column(“xxx”)?

Yes - well, or go back to 19r1.1 … and that’s just the beginning :open_mouth:

I changed the parameter to DatabaseColumn now get:

frmCommittees.Open, line 46
Parameter “lsDate” expects class DatabaseColumn, but this is class DatabaseField.
lstCommittee.Cell(lstCommittee.LastIndex, 1) = CheckDate(rs.Field(“InceptDate”))

total 133 errors

Then did a search and replace Field with Column

And got over 4,000 errors.

What was the reason this was changed.

And how should I proceed.

I need to run the current one because of iOS.

They should provide a doc on how to update your code.

my opinion (as well as many others) is that they shouldn’t have changed all the syntax at all
one of a few reasons I am staying with r1.1 for probably quite a while to come

So I will then be stuck on that version…

I will have to keep 2 version then. One for iOS and one for legacy code.

Why would they do that?

Current version is 2019r3…

I’ll try 3

Version 3:

mdGlobals.CheckDate Declaration
Can’t find a type with this name
Function CheckDate(lsDate as DatabaseCursorField) As String

Same issue

you are saying

mdGlobals.CheckDate

yet checkDate is a function you defined?
if so, then shouldn’t it be

s=CheckDate(mdGlobals)

if you switch to new database classes (RowSet) i think you get the field type with this
documentation.xojo.com/api/databases/rowset.html#rowset-columnType
it seems unfortunately not part of the column itself and only accessible via column index and search by name.

documentation.xojo.com/index.php?title=DatabaseCursor.Field&redirect=no