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
Author
Randall Ken View Drop Down
Senior Member
Senior Member
Avatar

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
Hi,

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?

Thanks,

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

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);
var
  Expr: TCodeSnippetExpression;
begin
  Expr := TCodeSnippetExpression(Args.ColumnAttr.Arguments[0].Value);
  if Expr.Value = #39'GUID'#39 then
    Expr.Value := #39#34'GUID'#34#39;
end;


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