convert vb code to t-sql (pdf automation)

Question

Post reply

convert vb code to t-sql (pdf automation)

skb 44459

SSCarpal Tunnel

Points: 4768
More actions
August 14, 2013 at 9:23 am

#281174

Want to convert VB Code to SQL
Dim objMyForm
objMyForm = CreateObject("CutePDF.Document")
objMyForm.initialize("DEMO-SDK-84232865-00514228")
objMyForm.openFile("x:\skb\rmfg-0202.pdf")
objMyForm.setField("KO No", "Acro Software Inc.")
objMyForm.saveFile("x:\skb\Form01.pdf")
Above code works fine.
This is what attempted but its not working
declare @objMyForm integer, @rs integer
execute @rs = dbo.sp_OACreate 'CutePDF.Document', @objMyForm OUTPUT
execute @rs = master.dbo.sp_OAMethod @objMyForm, 'initialize' , 'DEMO-SDK-84232865-00514228'
execute @rs = master.dbo.sp_OAMethod @objMyForm, 'OpenFile' , 'x:\skb\RMFG-0202.pdf'
execute @rs = master.dbo.sp_OAMethod @objMyForm, 'SaveFile' , 'x:\skb\Form01.pdf'
execute @rs = master.dbo.sp_OADestroy @objMyForm

Viewing 13 posts - 1 through 12 (of 12 total)

You must be logged in to reply to this topic. Login to reply

Alvin Ramard SSC-Forever Points: 41190 More actions · Answer 1

Nice code. Thanks for posting here. 🙂

You might want to add whatever question you have. 😎

Alvin Ramard
Memphis PASS Chapter[/url]

All my SSC forum answers come with a money back guarantee. If you didn't like the answer then I'll gladly refund what you paid for it.

For best practices on asking questions, please read the following article: Forum Etiquette: How to post data/code on a forum to get the best help[/url]

Sean Lange SSC Guru Points: 286590 More actions · Answer 2

Why do you want to do this in t-sql? It is the wrong tool for the job. A CLR proc, SSIS or even an application would be a much better choice here.

_______________________________________________________________

Need help? Help us help you.

Read the article at http://www.sqlservercentral.com/articles/Best+Practices/61537/ for best practices on asking questions.

Need to split a string? Try Jeff Modens splitter http://www.sqlservercentral.com/articles/Tally+Table/72993/.

Cross Tabs and Pivots, Part 1 – Converting Rows to Columns - http://www.sqlservercentral.com/articles/T-SQL/63681/
Cross Tabs and Pivots, Part 2 - Dynamic Cross Tabs - http://www.sqlservercentral.com/articles/Crosstab/65048/
Understanding and Using APPLY (Part 1) - http://www.sqlservercentral.com/articles/APPLY/69953/
Understanding and Using APPLY (Part 2) - http://www.sqlservercentral.com/articles/APPLY/69954/

skb 44459 SSCarpal Tunnel Points: 4768 More actions · Answer 3

I want to populate the pdf form using large sql data

Sean Lange SSC Guru Points: 286590 More actions · Answer 4

skb 44459 (8/14/2013)
I want to populate the pdf form using large sql data

OK.

Why do you want to do this in t-sql? It is the wrong tool for the job. A CLR proc would be a much better choice here.

_______________________________________________________________

Need help? Help us help you.

Read the article at http://www.sqlservercentral.com/articles/Best+Practices/61537/ for best practices on asking questions.

Need to split a string? Try Jeff Modens splitter http://www.sqlservercentral.com/articles/Tally+Table/72993/.

Cross Tabs and Pivots, Part 1 – Converting Rows to Columns - http://www.sqlservercentral.com/articles/T-SQL/63681/
Cross Tabs and Pivots, Part 2 - Dynamic Cross Tabs - http://www.sqlservercentral.com/articles/Crosstab/65048/
Understanding and Using APPLY (Part 1) - http://www.sqlservercentral.com/articles/APPLY/69953/
Understanding and Using APPLY (Part 2) - http://www.sqlservercentral.com/articles/APPLY/69954/

Alvin Ramard SSC-Forever Points: 41190 More actions · Answer 5

Sean Lange (8/14/2013)
skb 44459 (8/14/2013)
I want to populate the pdf form using large sql data
OK.
Why do you want to do this in t-sql? It is the wrong tool for the job. A CLR proc would be a much better choice here.

I agree.

Alvin Ramard
Memphis PASS Chapter[/url]

All my SSC forum answers come with a money back guarantee. If you didn't like the answer then I'll gladly refund what you paid for it.

For best practices on asking questions, please read the following article: Forum Etiquette: How to post data/code on a forum to get the best help[/url]

Sean Lange SSC Guru Points: 286590 More actions · Answer 6

Maybe instead of taking code you found in a 6 year old thread here on ssc and asking us to convert it to t-sql you can tell us what you are actually trying to do.

(http://www.sqlservercentral.com/Forums/Topic383628-131-1.aspx)

The code posted there only saves a copy of a pdf, you sound like you want to create your own pdfs using data found in your database? If you can provide the details of what you want to accomplish we can help you figure out a good way to it. Using t-sql with sp_OACreate to generate a pdf is not the best way.

_______________________________________________________________

Need help? Help us help you.

Read the article at http://www.sqlservercentral.com/articles/Best+Practices/61537/ for best practices on asking questions.

Need to split a string? Try Jeff Modens splitter http://www.sqlservercentral.com/articles/Tally+Table/72993/.

Cross Tabs and Pivots, Part 1 – Converting Rows to Columns - http://www.sqlservercentral.com/articles/T-SQL/63681/
Cross Tabs and Pivots, Part 2 - Dynamic Cross Tabs - http://www.sqlservercentral.com/articles/Crosstab/65048/
Understanding and Using APPLY (Part 1) - http://www.sqlservercentral.com/articles/APPLY/69953/
Understanding and Using APPLY (Part 2) - http://www.sqlservercentral.com/articles/APPLY/69954/

skb 44459 SSCarpal Tunnel Points: 4768 More actions · Answer 7

I am not aware of CLR Procs at all. But I am open to any good solutions.

I want to write a Stored Procedure which will

- Open a PDF template (Template has all the form field defined)

- put sql data into the pdf file.

-Save the pdf file on network location.

Sean Lange SSC Guru Points: 286590 More actions · Answer 8

skb 44459 (8/14/2013)
I am not aware of CLR Procs at all. But I am open to any good solutions.
I want to write a Stored Procedure which will
- Open a PDF template (Template has all the form field defined)
- put sql data into the pdf file.
-Save the pdf file on network location.

In a nutshell a CLR procedure is a way to write your code in .NET and call that from sql as a stored procedure. Can you write the code to do this in .NET? The CLR portion is pretty simple.

_______________________________________________________________

Need help? Help us help you.

Read the article at http://www.sqlservercentral.com/articles/Best+Practices/61537/ for best practices on asking questions.

Need to split a string? Try Jeff Modens splitter http://www.sqlservercentral.com/articles/Tally+Table/72993/.

Cross Tabs and Pivots, Part 1 – Converting Rows to Columns - http://www.sqlservercentral.com/articles/T-SQL/63681/
Cross Tabs and Pivots, Part 2 - Dynamic Cross Tabs - http://www.sqlservercentral.com/articles/Crosstab/65048/
Understanding and Using APPLY (Part 1) - http://www.sqlservercentral.com/articles/APPLY/69953/
Understanding and Using APPLY (Part 2) - http://www.sqlservercentral.com/articles/APPLY/69954/

Jeff Moden SSC Guru Points: 1004318 More actions · Answer 9

skb 44459 (8/14/2013)
This is what attempted but its not working

What's not working about it? Are you getting any error messages?

Also, what do you get when you run the following?

EXEC xp_dirtree 'x:\skb\',1,1;

--Jeff Moden

RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.

Change is inevitable... Change for the better is not.

Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally)

Jeff Moden SSC Guru Points: 1004318 More actions · Answer 10

Sean Lange (8/14/2013)
Why do you want to do this in t-sql? It is the wrong tool for the job. A CLR proc, SSIS or even an application would be a much better choice here.

If you have someone that can write a CLR, use SSIS, or write an application to do it, maybe. 😉

--Jeff Moden

RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.

Change is inevitable... Change for the better is not.

Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally)

Jeff Moden SSC Guru Points: 1004318 More actions · Answer 11

Sean Lange (8/14/2013)
Maybe instead of taking code you found in a 6 year old thread here on ssc and asking us to convert it to t-sql you can tell us what you are actually trying to do.
(http://www.sqlservercentral.com/Forums/Topic383628-131-1.aspx)

I just have to ask... what in the world made you look for a previous thread on this?

--Jeff Moden

RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.

Change is inevitable... Change for the better is not.

Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally)

Sean Lange SSC Guru Points: 286590 More actions · Answer 12

Jeff Moden (8/14/2013)
Sean Lange (8/14/2013)
Maybe instead of taking code you found in a 6 year old thread here on ssc and asking us to convert it to t-sql you can tell us what you are actually trying to do.
(http://www.sqlservercentral.com/Forums/Topic383628-131-1.aspx)
I just have to ask... what in the world made you look for a previous thread on this?

Didn't go searching for it. It popped up on the Active Threads and I noticed the most recent post was the same person. They were right next to each other on the list. 😉

_______________________________________________________________

Need help? Help us help you.

Read the article at http://www.sqlservercentral.com/articles/Best+Practices/61537/ for best practices on asking questions.

Need to split a string? Try Jeff Modens splitter http://www.sqlservercentral.com/articles/Tally+Table/72993/.

Cross Tabs and Pivots, Part 1 – Converting Rows to Columns - http://www.sqlservercentral.com/articles/T-SQL/63681/
Cross Tabs and Pivots, Part 2 - Dynamic Cross Tabs - http://www.sqlservercentral.com/articles/Crosstab/65048/
Understanding and Using APPLY (Part 1) - http://www.sqlservercentral.com/articles/APPLY/69953/
Understanding and Using APPLY (Part 2) - http://www.sqlservercentral.com/articles/APPLY/69954/