I have to create a Parent Child relationship when i insert data into SQL
Server tables, I create GUID as primary key and i need the same GUID as the
Foreign key for insertion into another table, I am unable to achieve this
since the Functiod that uses Inline C# is being executed once for each call
and hence i have two seperate GUIDs,
Is there any way out

Thanks in advance
Raj

[ Post a follow-up to this message ]

In your Inline C# you can maintain global variables that can remember the
state information across different functoid calls, and thus you can
remember if you have already generated a GUID before.

The code that you put in a InlineC# functoid would probably look something
like:


bool _globalDidWorkBefore = false;  //global variables to remember state
string _globalGuid = null; //global variable to remember state
string GetMeGuid()
{
if (! _globalDidWorkBefore)
{
_globalDidWorkBefore  = true;
_globalGuid = GenerateNewGuid();
}

return _globalGuid;
}


Thanks....

--------------------[vbcol=seagreen] 
cpmsftngxa10.phx.gbl!TK2MSFTFEED01.phx.gbl!TK2MSFTNGP08.phx.gbl!TK2MSFTNGP12
.phx.gbl[vbcol=seagreen] 
the[vbcol=seagreen] 
call[vbcol=seagreen] 

This posting is provided "AS IS" with no warranties, and confers no rights.

EBusiness Server Team

[ Post a follow-up to this message ]