1. shoaib siddiqui
  2. SnapDevelop
  3. Monday, 16 August 2021 18:05 PM UTC

I have a small test project in SnapDevelop/R3 to test WebApi using SAP ASE database,  I have simple datawindow in my target. While converting this datawindow in SnapDevelop I am getting this error.

Parsing 'd_all_tickets_contract (c:\dev\e-ticket\tickets.pbl)' Error: The data type of column ticket_ident is not supported.

The column ticket_ident is defined as Numeric() Identity column in database, which means this value gets generated by database automatically when a new row is created, hence called Identity column.

 

 

 

 

Accepted Answer
David Xiong @Appeon Accepted Answer Pending Moderation
  1. Thursday, 19 August 2021 02:46 AM UTC
  2. SnapDevelop
  3. # Permalink

Hi Shoaib,

The columns in your SRD use user-defined data types like dm_identity in the DB. SnapDevelop 2019 R3 has limited support for user-defined data types when converting DataWindows to C# models. SnapDevelop 2021 has optimized for this. I suggest that you try SnapDevelop 2021 and see if it resolves your issue.

Regards,
David

Comment
There are no comments made yet.
shoaib siddiqui Accepted Answer Pending Moderation
  1. Thursday, 19 August 2021 17:20 PM UTC
  2. SnapDevelop
  3. # 1

PB 2021 did resolve this issue, Thanks

Comment
  1. Armeen Mazda @Appeon
  2. Thursday, 19 August 2021 17:31 PM UTC
Glad to hear that! Thanks for confirming!
  1. Helpful
There are no comments made yet.
shoaib siddiqui Accepted Answer Pending Moderation
  1. Tuesday, 17 August 2021 12:18 PM UTC
  2. SnapDevelop
  3. # 2

So I removed this column from datawindwo and tried and got another error It seems like the Data window converter is throwing error on every column that was defined with user-defined datatypes.

Extracted SQL example:

CREATE TABLE dbo.ticket
(
ticket_ident dm_identity IDENTITY,
contract_nbr char(7) NOT NULL,
ticket_book_nbr int NOT NULL,
status_cd dm_code NOT NULL,
ticket_dt dm_datetime NOT NULL,

 

pre-defined user datatypes in DB

dm_identity = Numeric(8.0)
dwm_code = Char(5)

This is just my understanding, I don't know how SnapDevelop looks datatypes for each column in a datawindow. my datawindow column specs looks like this:

 

 

Comment
  1. shoaib siddiqui
  2. Thursday, 19 August 2021 15:37 PM UTC
I did, I am waiting Admin to install and will try then. Thanks
  1. Helpful
  1. Armeen Mazda @Appeon
  2. Thursday, 19 August 2021 16:04 PM UTC
Great. Please try and let us know.
  1. Helpful
  1. shoaib siddiqui
  2. Thursday, 19 August 2021 17:20 PM UTC
PB 2021 did resolve this issue, Thanks
  1. Helpful
There are no comments made yet.
Olan Knight Accepted Answer Pending Moderation
  1. Monday, 16 August 2021 21:04 PM UTC
  2. SnapDevelop
  3. # 3

Have you tried assigning a size to the NUMERIC? Example:  numeric (11,0) or numeric (5,7)?

Also, I thought the DATATYPE of a column auto-assigned by the database was IDENTITY, not numeric.

 

 

Comment
  1. Sivaprakash BKR
  2. Tuesday, 17 August 2021 08:04 AM UTC
Is Numeric datatype allowed for IDENTITY columns in ASE ? I think only Integer data type are allowed.
  1. Helpful
  1. shoaib siddiqui
  2. Tuesday, 17 August 2021 12:02 PM UTC
Yes it is IDENTITY column defined as Numeric(8,0) IDENTITY



Thanks
  1. Helpful
  1. Olan Knight
  2. Thursday, 19 August 2021 13:34 PM UTC
Go ahead and try to define an IDENTITY column as NUMERIC (8,0) and see what happens.
  1. Helpful
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.