9/13/2025 10:28:46 PM
|
| |
| 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 using the SalesLogix OLE DB Provider from external applications (including usage of built-in provider procedures). View the code of conduct for posting guidelines.
|
|
|
|
Keep getting the same KeyID back from slx_DBIDs
Posted: 17 Jul 08 10:20 AM
|
I have a VB6 App that is used to Insert records into a Custom SLX table from data in another database on different server on a regular basis.
The problem that I am having is that when the app has more than one record to insert, each call to "slx_DBIDs" is giving back the same KeyID as the previous call to "slx_DBIDs" therefore or the second INSERT I am getting a Primary Key Duplicate Value Error.
And now for the twist if I run the app in source then the problem does not occur and I runs without errors if I fire the EXE off direct or via a desktop shortcut.
The only time I am getting the error is when it is set to run as a windows scheduled task.
What am I missing?
I have looked in the SITEKEYS table when the error occurs and the entry for Keytype 25 (Other) is not being changed but the call.
I am using SLX 6.2.0 and have a number of other VB6 programs that use "slx_DBIDs" successful for inserting large numbers of records in various SLX tables both custom and standard.
|
|
|
|
Re: Keep getting the same KeyID back from slx_DBIDs
Posted: 18 Jul 08 8:22 AM
|
RESOLVED
Some idiot installed the SLX V7 Provider on to the machine that the scheduled task was set up on.
Therefore while it was giving back a KEYID it was not incrementing the value in the table
Sorry to have bothered anyone |
|
|
|
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!
|
|
|
|
|
|
|
|