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...
-- John Kiernan
"Maybe Amelia Earhart was just stealing the plane".