The Forums on slxdeveloper.com are now retired. The forum archive will remain available for the time being. Thank you for your participation on slxdeveloper.com!
|
|
GetIDFor help please
Posted: 29 Nov 06 10:54 AM
|
fiogf49gjkf0d I'm trying to add both a Mailing and Street address in an import script. I'm using the following:
strAccountID = Application.BasicFunctions.GetIDFor("Account")
strMAddressID = Application.BasicFunctions.GetIDFor("Address")
strPAddressID = Application.BasicFunctions.GetIDFor("Address")
Both strMAddressID and strPAddressID end up being the same ID.
What's going on? |
|
|
|
Re: GetIDFor help please
Posted: 29 Nov 06 5:55 PM
|
fiogf49gjkf0d Are you on a version higher than 6.2.3? If so could you use the SLXProfiler.exe and see if it increments a value in the SITEKEYS table with each GetIDFor call?
I can guarantee 2 subsequent GetIDFor calls work for one of my custom tables. It has to according to my design (I create a mirror primary key linking 2 records to each other). I'm not entirely certain of the effects of using it on a system table like Address or Account. It's supposed to work. |
|
|
|
Re: GetIDFor help please
Posted: 30 Nov 06 5:52 AM
|
fiogf49gjkf0d I tested the code in our database (6.2.3) and found that the two address id's were different, so there's something odd about your db. Also note that the SLXProfiler exists in 6.2.3. |
|
|
|
Re: GetIDFor help please
Posted: 30 Nov 06 7:25 AM
|
fiogf49gjkf0d Sorry guys, on further inspection (its not my code originally) I see that the GetIDFor works it's just the rest of the code that's not working as expected. I love trying to figure out someone else code. |
|
|
|