I open a Database, wich is connexted to a ADOrecordset,
on mainform some fields e.g. Name, Street, City, Phone, Fax
when I 'click/walk" through grid displaying on mainform works fine
because thes field have datasource as ADObrookers, Datafield 'their table name'
BUT: as soon as I start changing (to save later), or even typing in e.g. streetaddress
I get this error
----------------------------------------------------------------------------------------
>Binding Collection Error
>Field not updatable, Bound Property Name: Text, Field Name: BrokerStreet
----------------------------------------------------------------------------------------
This is how we open.
Sql = "SELECT * from Brookers order by brokernum"
rsBrokers.CursorLocation = adUseServer
rsBrokers.CursorType = adOpenKeyset
rsBrokers.LockType = adLockOptimistic
rsBrokers.Open "brookers", "provider=PervasiveOLEDB;Data source=Newindia", adOpenDynamic, adLockOptimistic, adCmdTable
adoBrookers.CommandType = adCmdText
adoBrookers.RecordSource = Sql
adoBrookers.Refresh
rsBrokers.MoveFirst
BUT:
If I open like this, no error
Sql = "SELECT * from Brookers order by brokernum"
rsBrokers.CursorLocation = adUseServer
rsBrokers.CursorType = adOpenKeyset
rsBrokers.LockType = adLockOptimistic
rsBrokers.Open "brookers", "provider=PervasiveOLEDB;Data source=Newindia", adOpenDynamic, adLockOptimistic, adCmdTable
rem skip adoBrookers.CommandType = adCmdText
rem skip adoBrookers.RecordSource = Sql
rem skip adoBrookers.Refresh
rsBrokers.MoveFirst
I prefer to open the first way , because then I have the option
to change Sql setting, and can call the adoBrookers.Refresh after e.g. deleting record
So what do I wrong?
Regards Jack
http://0url.com/ov9
-Ram