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...