>>>>>Hi All,
>>>>>
>>>>>I am not sure if this is the correct place to post this.
>>>>>
>>>>>I am trying to create a trigger that will take the inserted information for the table and format it and pass it to another process. I have done this "in process" and it works fine, however "in-process" will take down the sql server if something nasty happens in the other process. I would like to make this "out of process", but foxpro wants the exe for this. When I use cmdshell I am limited to 256 characters in the arguements I am passing and that is not going to work. How do I call foxpro out of process without using commandshell from sql server? I tried the call from sql server using the 4(out of process) parameter with sp_OACreate, but is there something special I need to do in the foxpro exe to make this work?
>>>>>
>>>>>TIA
>>>>>Beth
>>>>
>>>>I'm not sure which limit you're referring to.
>>>>
>>>>Are you talking about http://msdn.microsoft.com/en-us/library/ms175046.aspx ?
>>>
>>>No, when you run it from the command line, you can only run 256, when calling vfp. vfp is the thing that is having the problem with over 256 characters.
>>
>>Where you saw limit in VFP?

>
>It doesn't say about the limit here http://www.berezniker.com/content/pages/visual-foxpro/how-pass-parameters-vfp-exe but I suppose there is a limit of the string literal. May be we can pass parameters as a name of the text file.

I don't know. I just tried:

m1 = REPLICATE([a],5000)
? Test(m1)

FUNCTION Test(a1)
RETURN a1

and it works as supposed to. But i didn't try to receive huge parameter as a parameter to EXE. I suspect that there is no difference.