Subscribe via RSS
Toggle Submenu
  1. Categories
  2. Recent
  3. Tags
View Replies (2)

Resolved RowsCopy(): how much should data types match?

  1. Advice
0
Votes
Undo
  1. Konstantin Goldobin
    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

  1. DataWindow
  2. PowerBuilder
PowerBuilder is calling the APD functions with an...
Microsoft SQL Server Native Client 11.0 Column do...
Accepted Answer
René Ullrich
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
Load more comments
Michael Kramer
  1. Michael Kramer
  2. Thursday, 5 December 2019 12:23 PM UTC
Nice to know; Thanks, René!
  1. Helpful
Chris Pollach @Appeon
  1. Chris Pollach @Appeon
  2. Thursday, 5 December 2019 15:33 PM UTC
But, not officially supported ... aka: "use at own risk".
  1. Helpful
Konstantin Goldobin
  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.
Responses (2)
Chris Pollach @Appeon
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.