8/25/2025 9:30:38 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 writing script in Architect plugins for SalesLogix & general SalesLogix customization topics (for Windows client only). View the code of conduct for posting guidelines.
|
|
|
|
Form does not store new DB-entries
Posted: 10 Sep 08 7:02 AM
|
Hi,
I made a customized form (SLX 6.2.6 Oracle 9i) to add and edit the ASSOCIATION-Table of SLX.
The main view is a datagrid showing all associations of current account. Works fine.
The edit form is called
a) for new: Application.BasicFunctions.ShowViewForRecord "association", "Personal:My_Associations_Edit", ""
b) for editing: Application.BasicFunctions.ShowViewForRecord "association", "Personal:My_Associations_Edit", dgAsso.GetCurrentField("")
(This mechanism works for many others forms as well.)
Editing data of a given data record works fine in form Personal:My_Associations_Edit.
But creating new entries just does not work. The new entry wont be created.
Form:
+ All db-fields are connected to input fields (.Text). (except create/modify - date/user)
+ AXFormChange does:
if Application.BasicFunctions.CurrentViewID = "" then
edID.Text = Application.BasicFunctions.GetIDFor("ASSOCIATION")
edAccID.Text = Application.BasicFunctions.CurrentAccountID
if Application.MainViews.ActiveView.BaseTable = "ACCOUNT" Then edAccAss.Text = "T" Else edAccAss.Text = "F"
end if
that's all - nothing else happens in the form
any ideas where to look for the failure? i have no more idea after investigation for 2 days...
Thanks!
Martin
|
|
|
|
Re: Form does not store new DB-entries
Posted: 10 Sep 08 8:40 AM
|
Hi Martin,
Make sure you are populating Fromid and Toid fields as they are not allowed to be null, as well as the normal primary key field of associationid.
You could run SLXProfiler (I think it works on Oracle) and see what is trying to happen, you should see what the insert statement is trying to do and hopefully it will report the error.
Cheers,
Steve |
|
|
|
Re: Form does not store new DB-entries
Posted: 10 Sep 08 8:46 AM
|
Hi Steve,
I already tried the Profiler, it showed no INSERT-statement.
Anyway - sometimes you need a good soul to give you the needed hint as you dont notice the obviouse. I checked it 2 times but didnt see, that TOID was provided 2 times, but FROMID not a single time.... 
Thanks for leading me, now it works 
Martin |
|
|
| |
|
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!
|
|
|
|
|
|
|
|