1. Konstantin Goldobin
  2. PowerBuilder
  3. Wednesday, 4 December 2019 14:39 PM UTC

Hello,

I was wondering if anyone knows how much column datatypes of datawindow objects must match in order for RowsCopy() to work. For example, are "number" and "decimal" compatible? Or "char(10)" and "char(100)"? "Date" and "datetime"? Unfortunately, I failed to find this information in help...

Best regards,
Konstantin

Accepted Answer
René Ullrich Accepted Answer Pending Moderation
  1. Thursday, 5 December 2019 06:44 AM UTC
  2. PowerBuilder
  3. # Permalink

Hi Konstantin,

I tried:

decimal{2} -> decimal{0}: works (no truncation or rounding!)

decimal{2} -> number: doesn't work

date -> datetime: works

datetime -> date: works

char(10) -> char(1): works (no truncation!)

HTH,

René

Comment
  1. Michael Kramer
  2. Thursday, 5 December 2019 12:23 PM UTC
Nice to know; Thanks, René!
  1. Helpful
  1. Chris Pollach @Appeon
  2. Thursday, 5 December 2019 15:33 PM UTC
But, not officially supported ... aka: "use at own risk".
  1. Helpful
  1. Konstantin Goldobin
  2. Tuesday, 10 December 2019 15:01 PM UTC
Thanks Rene! Indeed, it was decimals vs numbers... Surprisingly enough, copying via dot notation data access worked with no complaints!
  1. Helpful
There are no comments made yet.
Chris Pollach @Appeon Accepted Answer Pending Moderation
  1. Wednesday, 4 December 2019 16:25 PM UTC
  2. PowerBuilder
  3. # 1

Hi Konstantin;

  The DWO buffers must be exactly the same. So, the same columns, data types and most importantly ... the same column order as well.

HTH

Regards ... Chris

Comment
There are no comments made yet.
  • Page :
  • 1


There are no replies made for this question yet.
However, you are not allowed to reply to this question.
We use cookies which are necessary for the proper functioning of our websites. We also use cookies to analyze our traffic, improve your experience and provide social media features. If you continue to use this site, you consent to our use of cookies.