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!
|
|
Send SQL Statements to Remote
Posted: 31 Jul 08 12:25 PM
|
SLX 7.2.2 I've tried several times to send Delete statments from the SQL tool in Administrator to Remotes... However , it will just not execute on the remotes once they pick up their sync.
Is this a known issue or I am just doing something wrong? I've selected all the Remotes I want it to go to but it never goes. |
|
|
| |
|
Re: Send SQL Statements to Remote
Posted: 31 Jul 08 2:45 PM
|
Nope...
Its exactly this:
Delete from contact where firstname='E-mail' or firstname='Web' or middlename like '.%'
I do realize i don't account for address table deletion.... i was going to handle that next. |
|
|
|
Re: Send SQL Statements to Remote
Posted: 31 Jul 08 2:55 PM
|
| Weird, have you looked at the TEF files to see if the statement is really getting in? Do you have access to a remote to run this as a SELECT to see if the query produces results? Maybe the remote user does not have access to the contacts in question? |
|
|
|