>>>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?
Against Stupidity the Gods themselves Contend in Vain - Johann Christoph Friedrich von Schiller
The only thing normal about database guys is their tables.