Hi
I get this error on this declaration:
Can’t find a type with this name. Did you mean class Storm.DBConnection?
Sub Updated dbConn As DBConnection, dbVersion As Integer)
Note below that it declares it as: As DBConnection and not Storm.DBConnection
Don’t know why it worked before in 2014 v 2.1 but does not work in 3.2 or 2015.1
When I go to that code and declaration I can’t seem to find a way to edit it.
-Tim
Sub Update(dbConn As DBConnection, dbVersion As Integer)
// note if file is empty then dbversion is 0… which will then execute the SQL to create the database
Select Case dbVersion
Case Is < 1
ProcessUpdate(RSPSQL, 1) // Set up initial DB schema
//UpdateDatabase
Case 1
// Add ClientNotes, ClientNotesTitle cols to Plan table
//- could have called it just Notes but it is mapped to ClientNotes screen
ProcessUpdate(UpdateSQL2, 2) // Apply updates to v1 of the schema and set the schema to be a v2
// Change Contrib fields to DECIMAL
//ProcessUpdate(UpdateSQL3, 3) // Apply updates to v2 of the schema and set the schema to be a v3
'Case 2
'// Change Contrib fields to DECIMAL
'ProcessUpdate(UpdateSQL3, 3) // Apply updates to v2 of the schema and set the schema to be a v3
End Select
//NOTE SQLLite does not support MODIFY statements to change a column TYPE
End Sub