Relationships
IP Examples
  • Create new relationships.
    • 	' First select the tags that you want to link to each other
	' fyi: Include files define Const FIZZTAG_USER_ClientIP = "Usage_ClientIPAddress"
	ipTagID = fizzGetTagID(FIZZTAG_USER_ClientIP)            ' Pick any reasonable table name

    	' Get the target record definition
	recDef = fizzGetRecDef(FIZZREC_SnapshotUser)	' Get PTR to table definition

    	' build a relationship:
	'    WorldTable  . . . . . . . . . . . .  UsageTable
	'      WorldRecord  -------------   DBSnapShotRecord
	'        Tag:WorldSiteIP --> Tag:SnapshotAppServerIP
	lclKey = fizzAddRelationship(	FIZZTBL_WORLD,		FIZZREC_WORLD,			FIZZDAT_IP, FIZZTAG_WORLDSITEIP, _
	                                FIZZTBL_SnapshotDB, FIZZREC_SnapshotDB,		FIZZDAT_IP, "SnapshotAppServerIP", _
																				"World SiteIP --> DB Snapshot")
	lclKey = fizzAddRelationship(	FIZZTBL_SnapshotDB, FIZZREC_SnapshotDB,		FIZZDAT_IP, "SnapshotAppServerIP", _
	                                FIZZTBL_WORLD,		FIZZREC_WORLD,			FIZZDAT_IP, FIZZTAG_WORLDSITEIP, _
																				"DB Snapshot --> World SiteIP")

    End Fizz /FizzDB/SampleLinks.asp @ 8/20/2008 1:04:21 PM