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!

External Development Forums - SalesLogix OLEDB Provider
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.

Forums RSS Feed

Back to Forum List | Back to SalesLogix OLEDB Provider | New Thread

View: Search:

Author

Thread: Keep getting the same KeyID back from slx_DBIDs

Adrian Zawierka
Posts: 6

Keep getting the same KeyID back from slx_DBIDs Your last visit to this thread was on 1/1/1970 12:00:00 AM

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.

[Reply][Quote]

Adrian Zawierka
Posts: 6

Re: Keep getting the same KeyID back from slx_DBIDs Your last visit to this thread was on 1/1/1970 12:00:00 AM

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

[Reply][Quote]

Page 1 of 1

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!

slxdeveloper.com is brought to you courtesy of Ryan Farley & Customer FX Corporation. This site, and all contents herein, are Copyright © 2024 Customer FX Corporation. The information and opinions expressed here are not endorsed by Sage Software.	code of conduct \|

page cache (param): 11/22/2024 5:16:25 PM