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
    
    Requested Record: Show the record and table we will use
    Table: "FIZZRecord"{D9F6DCD4-4923-4F7F-9263-DE778C70E688} located

    Record #1SnapshotUser Key={D9F6DCD4-4923-4F7F-9263-DE778C70E688}
    #1000674TextTag 2: RecordNameSnapshotUser12/12/2006 4:03:09 PM
    SummaryThere is 1 nugget associated with this record.
    	' 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")
    
    
    Requested Record: Show our new relationship
    Table: "FIZZRecord"{E251C572-941F-47E7-92D4-658CA0743904} does not exist
    SummaryThere were NO nuggets.


    End Fizz /FizzDB/SampleLinks.asp @ 9/19/2019 4:13:42 AM