AS you all know when you are creating a View you have some options like
DBSetProp('EXCHGTAB', 'View', 'UpdateType', 1)
DBSetProp('EXCHGTAB', 'View', 'WhereType', 3)
DBSetProp('EXCHGTAB', 'View', 'FetchMemo', .T.)
DBSetProp('EXCHGTAB', 'View', 'SendUpdates', .F.)
DBSetProp('EXCHGTAB', 'View', 'UseMemoSize', 255)
DBSetProp('EXCHGTAB', 'View', 'FetchSize', 30)
DBSetProp('EXCHGTAB', 'View', 'MaxRecords', -1)
DBSetProp('EXCHGTAB', 'View', 'Tables', 'dbo.exchgtab')
DBSetProp('EXCHGTAB', 'View', 'Prepared', .F.)
DBSetProp('EXCHGTAB', 'View', 'CompareMemo', .T.)
DBSetProp('EXCHGTAB', 'View', 'FetchAsNeeded', .T.)
DBSetProp('EXCHGTAB', 'View', 'ParameterList', "pcust,'C'")
DBSetProp('EXCHGTAB', 'View', 'Comment', "")
DBSetProp('EXCHGTAB', 'View', 'BatchUpdateCount', 1)
DBSetProp('EXCHGTAB', 'View', 'ShareConnection', .T.)
is there a way to have this options set for a cursor created mith the SQLEXEC() command.
I need the
DBSetProp('EXCHGTAB', 'View', 'FetchSize', 30) &
DBSetProp('EXCHGTAB', 'View', 'FetchAsNeeded', .T.)
for a number of cursors.
thanks.
B.D.H.