7/8/2025 12:34:01 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 general administration topics for SalesLogix (including LAN & remote topics). View the code of conduct for posting guidelines.
|
|
|
| |
| |
|
Re: Remote Task- Send and execute a .bat file
Posted: 03 Feb 07 5:47 PM
|
fiogf49gjkf0d As RJ Ledger mentioned, you can, depending on version, execute a create statement via the provider and it will sync out, however, I've found it will choke on complex queries for create view statements if you're doing some funky stuff in your view.
An alternative is to create the view in a script that fires when a remote logs on to SLX. You can check SYSTEMINFO.DBTYPE, if it is a 2 then it is a remote. Then you can even write out the batch file commands to a file and execute it to create the views (also check to see if the view exists already first before you do it as well) |
|
|
|
Re: Remote Task- Send and execute a .bat file
Posted: 04 Feb 07 3:20 PM
|
fiogf49gjkf0d Agree Ryan.
I can choke.. I recommend one test it carefully first against a test using a tool like TOAD, ADO Explorer, etc. that can connect to the SalesLogix provider.
Certainly using the 2nd approach works as well.. and then there's the "SQL" type plugin that many have forgotten (and how to "invoke" it). I've used that plugin to "hold" the SQL Create statement, setup a vbscript to run (on Application LoginComplete) nased on db type (2 and 3), etc.. get the idea?
--
rjl |
|
|
|
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!
|
|
|
|
|
|
|
|