Ttile: Tab in TDBAdvMemo not smart like in SQL Server Management Studio
Component: TDBAdvMemo
I'm using TDBAdvMemo to show the script of SQL. I want to create a small application to
isolate SQL Server Management Studio, so I can edit/update script by my application
from anywhere in network without open SQL Server Management Studio application.
I have a SQL file with formatted. When I open this file by SQL Server Management
Studio, the script looked so tidy, but for the same file and I have stored it into the
database and showed it with my application the script look not tidy.
Based on my investigation, I think this issue caused by the tab of TDBAdvMemo that not
smart. Actually, I have set the property SmartTabs, but I think this tab is not smart like
SSMS has.
For more information about the format of my script, you can use this setting:
Font: Courier New / 14
Tab: 4
To ensure you can understand this issue clearly, let you see this script:
...
USE DB0814_01;
GO
IF OBJECT_ID(N'SP_0814_01_209_DATA') IS NOT NULL
DROP PROCEDURE SP_0814_01_209_DATA
GO
-- =============================================
-- AUTHOR: EKO INDRIYAWAN
-- EDITOR: EKO INDRIYAWAN
-- SUPERVISOR: FRANCISCA AURE LIASIE
-- CREATE DATE: 08-03-2010
-- DESCRIPTION: STORED PROCEDURE TEMPLATE LIST
-- =============================================
CREATE PROCEDURE SP_0814_01_209_DATA
...
Now, let you try to copy paste the script above in SSMS and TDBAdvMemo.
Just comparation, I have tried to use this format in TRzMemo and it worked fine.
Here is my code in TRzMemo. I cannot use TRzMemo since this component does not
support for Highlight like your component. I also have tried component from RichView
and I think not stable for this purpose to show the highlight.
I have tried PlusMemo trial, but I have not purchased the license of this component, and
I hope TDBAdvMemo can do this issue more better than today.
Thank in advance.
Regards,
Eko Indriyawan