Yes, you can run SQL-DMO from within your VFP program, that's what I was talking about. It should be available on any machine that's running SQL Server 2000. (I'm not sure if it was available with SQL 7, you might need to check).
I thought I had posted something here before, but that may have been on one of the mailing lists instead. Anyway, check out my reply to your original post. I put the code for doing this there, to benefit the other guys who replied to you.
~~Bonnie
>I need to run it from within a VFP program. I tried to figure out how to do this with VFP, but am not sure exactly how. Also, is SQL-DMO going to be available on whatever machine I'm going to need to run it on or will I have to do an install? (The whole idea is to send a PRG they can run, if possible.
>
>Any other people help poor ole ignorant me?
>
>-- John
>
>>John,
>>
>>I saw your original post and thought for sure someone else would reply and I was busy at the time, so I didn't reply then.
>>
>>What you could probably use is SQL-DMO. It's an easy way of running T-SQL without having to parse every SQL command. I thought I had posted some code here about this subject one time, but I can't find it now. If you can't find any information on it anywhere, lemme know and I can try and dig something up for you ...
>>
>>~~Bonnie
>>
>>
>>>I asked this a week back and only got one answer that did not work.
>>>
>>>Could one of the gurus (someone who probably thinks this is a really stupid quesiton and not worth their time to reply) PLEASE help?
>>>
>>>I run the upsizing wizard and take the 'Save SQL' option and end up with a project with code in Memo fields of tables. However, I cannot figure what/how to use it again (I have to take the end result to the client's site).
>>>
>>>I was told I could take the memo field and execute it via SQLEXEC(), but that just doesn't work ... either using the field directly or pulling it into a memvar and then SQLEXEC'ing the memvar.
>>>
>>>Can someone give me a clue of how I can re-use the code (it is a TSQL script, not native VFP).
>>>
>>>Thanks in advance.
>>>
>>>Yours in ignorance...
