hi good day!
I need some help here.. I have a SHAPE recordset..everything in the database has its value..Im stucked with this error:
"Error : -2147467259 - Relate, Compute By, and Sort operations cannot be performed on column(s) whose defined size is unknown or too large."
My code below:
cmd.ActiveConnection = cn
cmd.CommandType = adCmdText
cmd.CommandText = " SHAPE{Select invno,custcode,drcode,amount,grptype from `" & TempTab & "` } AS Command1 COMPUTE Command1 by 'grptype'"
cmd.Execute
'grptype' filed is in memo datatype.!