SoftTree Technologies SoftTree Technologies
Technical Support Forums
RegisterSearchFAQMemberlistUsergroupsLog in
CRUD Generator can't find Primary Keys that definitely exist

 
Reply to topic    SoftTree Technologies Forum Index » SQL Assistant View previous topic
View next topic
CRUD Generator can't find Primary Keys that definitely exist
Author Message
jlangland



Joined: 27 Apr 2016
Posts: 7
Country: United States

Post CRUD Generator can't find Primary Keys that definitely exist Reply with quote
Hi,

After upgrading to v9.5.469, my previous problem was fixed, but now new error.

CRUD tool keeps reporting (in code) /* Cannot find key columns in [CurveMaster].[Curves].[CurveDefinition] */

for every proc.

However, the table has a very obvious PK column

CREATE TABLE [Curves].[CurveDefinition](
[curveId] [int] IDENTITY(1,1) NOT NULL,
[CurveName] [varchar](255) NULL,
[DataSet] [varchar](20) NULL,
[BinScheme] [varchar](100) NULL,
[DateScheme] [varchar](100) NULL,
[BaseView] [varchar](255) NULL,
[Harvest_Rating] [varchar](25) NULL,
[FilterCriteria] [varchar](max) NULL,
CONSTRAINT [PK_CurveDefinition] PRIMARY KEY CLUSTERED
(
[curveId] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]

Version: Microsoft SQL Server 2017 (RTM) - 14.0.1000.169 (X64) Aug 22 2017 17:04:49 Copyright (C) 2017 Microsoft Corporation Developer Edition (64-bit) on Windows Server 2012 Datacenter 6.2 <X64> (Build 9200: ) (Hypervisor)
Fri Jun 22, 2018 11:55 am View user's profile Send private message
Display posts from previous:    
Reply to topic    SoftTree Technologies Forum Index » SQL Assistant All times are GMT - 4 Hours
Page 1 of 1

 
Jump to: 
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum


 

 

Powered by phpBB © 2001, 2005 phpBB Group
Design by Freestyle XL / Flowers Online.