Member Avatar for PinoyDev

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.!

Edited by PinoyDev
  • 1 Contributor
  • 1 Reply
  • 263 Views
  • 1 Hour Discussion Span
  • Latest Post Latest Post by PinoyDev
Member Avatar for PinoyDev

got it solved.. changed datatype from memo to text...

Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.