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 - General External Development
Forum to discuss general external development topic (related or not to SalesLogix development). View the code of conduct for posting guidelines.

Forums RSS Feed

Back to Forum List | Back to General External Development | New Thread

View: Search:

Author

Thread: Anyway to generate primary keys from outside of SLX?

Andrew Fink
Posts: 41

Anyway to generate primary keys from outside of SLX? Your last visit to this thread was on 1/1/1970 12:00:00 AM

Posted: 15 Jul 09 8:31 AM

Is there any way to be able to generate a primary key from outside of SLX via the web?

Right now we have a fully custom customer portal that use apache/PHP on linux. It connects to our SLX Database using FreeTDS and it works great if:
a. Records are only created from the web using a Primary Key that we assign
b. Records are only created from inside SLX and only read to the web.

Is there any way to either create a SLX key from the web or possibly tell SLX to use a regular incremental key?

Or if anyone has an alternate solution I am all ears.

Thanks,
Andrew

[Reply][Quote]

Raul A. Chavez
Posts: 1300

Re: Anyway to generate primary keys from outside of SLX? Your last visit to this thread was on 1/1/1970 12:00:00 AM

Posted: 16 Jul 09 4:15 PM

What version of SLX are you on?
And, what do you mean by "from Outside of SLX via the web".

If you are writing the data directly to the SQL database, you may need to build a Store Procedure or CLR object to generate an ID (by mimicing what SLX does).
If you are able to write into SLX via the SalesLogix OLEDB provider, you could use AutoIncrement keys on the tables that you are going to be workign on.

And, I believe that you could also generate the keys via the REST interfaces on SLX (SDATA on 7.5 web client)

...

[Reply][Quote]

Chris Grant
Posts: 10

Re: Anyway to generate primary keys from outside of SLX? Your last visit to this thread was on 1/1/1970 12:00:00 AM

Posted: 28 Jul 09 9:29 PM

If you access SalesLoigx via SLXOLEDB you can generate ID in one of three ways depending on your version of SalesLogix

1. To generate an ID for a table execute the following "Special" SQL.

slx_dbids("<tableName>", 1)

2. To multiple ID at a time execute the following "Special" SQL.

slx_dbids("<tableName>", )

3. Via the SLX DB Manage goto a primary field right clcick and select properties on an ID field for a table and check "Field is Auto Increment".
In this case if you do not provide the ID it will auto populate it for you.

[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): 4/27/2024 6:29:34 PM