7/5/2025 10:30:23 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 the use of the SalesLogix Web Platform, Client and Customer Portals, and the Application Architect (For version 7.2 and higher only). View the code of conduct for posting guidelines.
|
|
|
|
Problem inserting into extension table -unknown or internal error has occurred
Posted: 23 Jul 09 9:24 AM
|
Has anyone run into this problem? I have a table my_table with an extension table.
I receive the following error regardless if I try to insert the record through the object .save() or through the OLEDB.
An unknown or internal error has occurred. (SQL: "INSERT INTO mytable_ext( mytable_extID,MODIFYDATE,TOT_ACCT_VAL) VALUES (?,?,?)")
I thought there may be an issue with the fields, so I stripped the table down to the base fields (id, modifydate, modifyuser, createdate, createuser,tot_acct_val) and still get the same error. I checked the Admin, it shows the relationship as One-to-One. I should add that the only non-nullable field is mytable_extId.
Using the profiler, it never gets to SQL.
Any ideas? My thanks in advance. |
|
|
|
Re: Problem inserting into extension table -unknown or internal error has occurred
Posted: 23 Jul 09 11:00 AM
|
Question:
If the table has a One to One relationship, shouldn't the ID field be called mytableID?
In other words, my base table is called "MYTABLE", and its ID is called "MYTABLEID". I create a new table with a one to one relationship called MyTable_EXT. The new table doesn't contain its own ID, but rather just the ID of the Parent table: MYTABLEID.
I know that this is how the tables would be created if using the Database Manager, but not sure how the App Architect may build them. When I have had a need to create an Extension entity,it was to associate a previously created One to One table that followed the schema listed above.
|
|
|
|
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!
|
|
|
|
|
|
|
|