Web forum is in read-only mode. Login as active registered customer for write access
  Forum Search   New Posts New Posts

NexusDB Aurelius Export

 Post Reply Post Reply
Randall Ken View Drop Down
Senior Member
Senior Member

Joined: 25 Oct 2014
Posts: 650
Post Options Post Options   Quote Randall Ken Quote  Post ReplyReply Direct Link To This Post Topic: NexusDB Aurelius Export
    Posted: 23 Oct 2018 at 10:19am

I have lots of fields called GUID in my NexusDB tables which is a reserved name so when I access them in SQL i have to use "GUID". I s there any way of making the export aware of this for use in tMS Web?


Back to Top
Wagner R. Landgraf View Drop Down
TMS Support
TMS Support

Joined: 18 May 2010
Posts: 2432
Post Options Post Options   Quote Wagner R. Landgraf Quote  Post ReplyReply Direct Link To This Post Posted: 24 Oct 2018 at 11:26pm
Please check: https://www.tmssoftware.com/site/forum/forum_posts.asp?TID=11429&KW=oncolumngenerated&title=force-sqare-brackets-mssql-in-generated-script.

Maybe you can adapt to your own use? Like: 

procedure OnColumnGenerated(Args: TColumnGeneratedArgs);
  Expr: TCodeSnippetExpression;
  Expr := TCodeSnippetExpression(Args.ColumnAttr.Arguments[0].Value);
  if Expr.Value = #39'GUID'#39 then
    Expr.Value := #39#34'GUID'#34#39;

Edited by Wagner R. Landgraf - 24 Oct 2018 at 11:27pm
Back to Top
 Post Reply Post Reply

Forum Jump Forum Permissions View Drop Down