TMSQuery editor, SQL Generator - error generating SQL statem

Discussion of open issues, suggestions and bugs regarding SDAC (SQL Server Data Access Components) for Delphi, C++Builder, Lazarus (and FPC)
Post Reply
Rnest
Posts: 10
Joined: Fri 19 Oct 2007 14:45

TMSQuery editor, SQL Generator - error generating SQL statem

Post by Rnest » Mon 12 Mar 2012 09:46

Autogenerated update, insert, strings are invalid in newest SDAC edition (6.1.5)
e.g. for TMSQuery.SQL.Text:

Code: Select all

SELECT [EMPNO]
      ,[ENAME]
      ,[JOB]
      ,[MGR]
      ,[HIREDATE]
      ,[SAL]
      ,[COMM]
      ,[DEPTNO]
  FROM [SDACDemos].[dbo].[emp]
as generated result for insert text you get

Code: Select all

INSERT INTO [dbo].[emp]
  ([EMPNO], [], [], [], [], [], [])
VALUES
  (:[EMPNO], :[], :[], :[], :[], :[], :[])
SET :[EMPNO] = SCOPE_IDENTITY()
and for update text:

Code: Select all

UPDATE [dbo].[emp]
SET
  [EMPNO] = :[EMPNO], [] = :[], [] = :[], [] = :[], [] = :[], [] = :[], [] = :[]
WHERE
  [ENAME] = :[Old_ENAME]
Tested on RAD Studio 2010, SQL Server 2008

Best regards
Ernest

AndreyZ

Post by AndreyZ » Tue 13 Mar 2012 08:34

Hello,

Thank you for the information. We will fix this problem in the next SDAC build.

Badiboy
Posts: 4
Joined: Mon 04 Jan 2010 15:56

Post by Badiboy » Sun 18 Mar 2012 15:03

I have the same problem and it makes new form design hard.

It's also generate identity querying code "SET :PROJECT_PERSON_ID = SCOPE_IDENTITY()" while "QueryIdentity" option is FALSE.

When do you plan to release new version?

AndreyZ

Post by AndreyZ » Mon 19 Mar 2012 12:04

We will release the new SDAC build approximately in two weeks.

Badiboy
Posts: 4
Joined: Mon 04 Jan 2010 15:56

Post by Badiboy » Mon 19 Mar 2012 12:12

Thanks for the reply, I'll be waiting for. :roll:

Post Reply