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: Problem with Auto Increment during insert

Brian Segers
Posts: 69

Problem with Auto Increment during insert Your last visit to this thread was on 1/1/1970 12:00:00 AM

Posted: 13 Mar 08 11:44 PM

SLX 7.01 Trying ti insert records using the Provider.
Auto inc is enabled on the table and a service restart has occured.

This works (i get a SLX generated ID and data is loaded):
INSERT INTO ASSOCIATION (toid, fromid, forwardrelation, backrelation)
VALUES ('SOMEID','SOMEOTHERID','Client','Vendor')

This does not work (i get an error: filed ASSOCIATIONID is a required field):
INSERT INTO ASSOCIATION (toid, fromid, forwardrelation, backrelation)
Select c1.contactid, c2.contactid, 'Vendor','Client' from contact c1, contact c2 where c1.somefield = c2.someotherfield

What am I missing?

Thanks,

Brian

[Reply][Quote]

Timmus Agersea
Posts: 328

Re: Problem with Auto Increment during insert Your last visit to this thread was on 1/1/1970 12:00:00 AM

Posted: 14 Mar 08 1:54 PM

You can not do these types of set operations. The provider only handles single record inserts.

Timmus

[Reply][Quote]

Brian Segers
Posts: 69

Re: Problem with Auto Increment during insert Your last visit to this thread was on 1/1/1970 12:00:00 AM

Posted: 14 Mar 08 5:41 PM

Thanks Timmus.

Gave me an excuse ot figure out how to do it in DTS.

Best, Brian

[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 9:19:13 PM