Hi John,
>The documentation mentions creating a separate class for each table based on cusOleDataServer and then instantiating that new class. For our more simpler reference data forms that just have a code/key and description, wouldn't it be possible to just instantiate cusOleDataServer directly passing it the table name without the need of creating a new class definition?
I'd create one class that would service all of those types of tables.
DEFINE CLASS MyGenericDataController as cusOleDataServer
cSprocPrefix = "DCSP_" && stored procedure prefix.
cDatabaseConnectionName = "MyDatabase"
ENDDEFINE
This way you would automatically have the SP Prefix and connection information preset.
Hope this helps.
Jim Duffy
Microsoft MVP
INETA Speaker
TakeNote TechnologiesDeveloper's Choice Award Winner for Best Training Company
Specializing in VB.NET, ASP.NET, VFP, and SQL Server Training and Development