Hi,

You could save the whole flowchart as a string in a TEXT/BLOB field. Use the SaveToString and LoadFromString methods to implement that.

If you need to map flowchart items and relations to entities in your database tables, you can do that by looping over the Boxes and Arrows collections and creating records in the respective tables. I have found the following code in our support archive that loads a flowchart from a table, and saving the flowchart should be symmetrical to that:

Private Sub Form_Load()
	Dim conn As New ADODB.Connection
	Dim nodeData As New ADODB.Recordset
	Dim linkData As New ADODB.Recordset

	conn.Open "Provider=Microsoft.Jet.OLEDB.4.0;data source=D:\Projects\FlowChartX\Support\Database\test.mdb"
	nodeData.Open "select * from Nodes", conn
	linkData.Open "select * from Links", conn

	While Not nodeData.EOF
		Dim b As box
		Set b = fcx.CreateBox(0, 0, 50, 30)
		b.Tag = nodeData(0)
		b.Text = nodeData(1)

		nodeData.MoveNext
	Wend

	While Not linkData.EOF
		Dim a As arrow
		Set a = fcx.CreateArrow( _
			fcx.FindBox(linkData(1)), _
		fcx.FindBox(linkData(2)))
		a.Text = linkData(3)

		linkData.MoveNext
	Wend

	Dim sl As New SpringLayout
	sl.NodeDistance = 150
	fcx.ArrangeDiagram sl
End Sub
 

I hope that helps,
Stoyan