4/18/2024 9:50:27 AM
|
| |
| slxdeveloper.com Community Forums |
|
| |
|
|
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!
Forum to discuss general external development topic (related or not to SalesLogix development). View the code of conduct for posting guidelines.
|
|
|
|
Calling SLX Stored Procs
Posted: 22 Aug 06 11:46 AM
|
fiogf49gjkf0d I'm trying to create SLX what's new records for my remote users (Scribe doesn't do this). I'm writing a script that will run after the load to call the SLX stored procs: slx_WNInsertCAO and slx_WNUpdateCAO for the records that have been created or updated. The calls work, but the WGLogs show no data but a blank call to What's new.
Anyone have any experience with these procs in particular?
Thanks,
Steve. |
|
|
|
Re: Calling SLX Stored Procs
Posted: 24 Aug 06 2:27 PM
|
fiogf49gjkf0d Figured out that this does work with Account records (I'm trying to do the same with history records). Any idea what records this will work with aside from Accounts? I think I may be up against a wall...
Steve. |
|
|
|
Re: Calling SLX Stored Procs
Posted: 24 Aug 06 2:34 PM
|
fiogf49gjkf0d have a transition table where you write the accountid and all other details needed for the stored proc to run later and then have the external app loop thru it and create the transactions for that...
My users never complained about the WN records after a scribe dataload;so whatever i suggested , I haven't done ....but it should work though  Try it out and let us know.
slx_WNUpdateCAO has the following 5 parms :
1:MAINTABLE
2:ID
3:FIELDNAME
4:OLDVALUE
5:NEWVALUE
all with Char 255
and slx_WNInsertCAO has 2 params
1:MAINTABLE
2:ID
If this doesnt resolve it , why dont you post your code here so we can take a look?? |
|
|
|
Re: Calling SLX Stored Procs
Posted: 24 Aug 06 2:56 PM
|
fiogf49gjkf0d Steve..I was writing a reply and you posted inbetween...
Anyways this should work with history too as there is a history tab there in the WN remote view. |
|
|
|
Re: Calling SLX Stored Procs
Posted: 24 Aug 06 3:11 PM
|
fiogf49gjkf0d yep, that's exactly what I'm trying, I also used the COM Object and attempted the LogWhatsNewInsert and LogWhatsNewUpdate.
With both actions, account works great, history not so much...  however with history attempts, I do get the following error in the eventvwr where my slxserver is running...
Source: SLXDBLogging
Event ID: 4:
Error writing to Logfile: WriteToLog - LogWhatsNew - GetNameByID - Missing SQL property
Steve
p.s. Scribe doesn't create these records, but any user action in SLX does, so when we bulk load any important data, users ask why there's no "What's New" records appearing.
|
|
|
|
Re: Calling SLX Stored Procs
Posted: 24 Aug 06 3:36 PM
|
fiogf49gjkf0d Steve, i dont know if there are any limitations as far as what all the maintables can be for these tefs to be created.You can probably ask the SDK guys there at SLX.
but another thing i thought of is to create your own custom functions in VB and have that integrated into scribe when you do a dataload.
refer to a doc Add-In Functions in the /Scribe/Samples/VBFunctions directory on your scribe server.there is a project too which you can look into.
Also are you trying something along these lines?? If so , then isnt supposed to work only for CAO - Contacts, Accounts and Opportunities.??
Dim objcmd as New Oledb.OledbCommand("slx_WNInsertCAO('Tablename' , 'currenttableID')", myconnection)
and then a objcmd.executescalar
|
|
|
|
You can
subscribe to receive a daily forum digest in your
user profile. View the site code
of conduct for posting guidelines.
 Forum RSS Feed - Subscribe to the forum RSS feed to keep on top of the latest forum activity!
|
|
|
|
|
|
|
|