Book a Demo

Author Topic: DDL Generation problem  (Read 2078 times)

m.marcusio

  • EA Novice
  • *
  • Posts: 1
  • Karma: +0/-0
  • I love YaBB 1G - SP1!
    • View Profile
DDL Generation problem
« on: May 05, 2006, 02:27:55 am »
Hi!

Evaluating latest version (790) I have encountered quite interesting problem. Importing ODBC schema works fine at a first look, but if when I tried to regenerate a DDL from what I just imported something strange went out in resulted code. CREATE PROCEDURE statement is missing from almost all (but not all) of the stored procedures. Firstly I thought that I'm doing something wrong (which is still possible), and retried the whole process dozen times, different scenarios, databases etc., result was the same. No CREATE PROCEDURE. Even retyping proc. which looked fine gave bad result.

So, after some hours of frustration, found that the only difference between correctly generated procedures, and the other ones lays in /*Simple comment*/.

This means that if you wont your procedures to generate correctly you should comment something out in the Notes box on the General tab for the procedure in question.

As this looks quite funny to me, I mean, why should comment anything to get correct syntax out.

My question really is: Am I doing something wrong, is this a functionality glitch in evaluation version or is this behavior a bug.

I would appreciate a reply just to confirm that this is not just my lack of knowledge, and if it is point me out in the right direction.

Thank you all

hd

  • EA Administrator
  • EA User
  • *****
  • Posts: 312
  • Karma: +0/-0
    • View Profile
Re: DDL Generation problem
« Reply #1 on: May 07, 2006, 03:33:36 pm »
Quote
My question really is: Am I doing something wrong, is this a functionality glitch in evaluation version or is this behavior a bug.


Unfortunately, a bug  :-[

However, build 791 will include a fix.