Hello,
I've a DTS Package in which i'm using Execute SQL Task. It's having a connection CON1. I've a function which is defined at DataBase level CON2. The query in the Execute SQL Task is an Update Query. It takes data from CON2 and updates in CON1. SO how can i call the function which is defined at database level into my Execute SQL Task update query. I don't know the syntax. Also that function taking 3 input parameters which i'm...
amitp
Last Activity: Mar 7 '08, 10:01 AM
Joined: Dec 11 '06
Location:
-
Regarding DTS Package Execute SQL Task
-
The report is nothing but a word document(word97 ) with .rtf extension. I want to open the same in word 2003. -
Regarding Word Application in VB 6.0
Hi,
I'm using VB 6.0 application in which one of my modules deals with printing of reports which are in RTF format. I'm able to populate all the data with proper formats. The RTF templates in which the data populates are in Word97. So when I only open that template file and save it in Word2003 the report goes fine. But when I open a Word97 template file, edit it (just typing a space and removing the space again before saving) and save... -
Regarding TreeView in ASP .Net
Hello I'm a newcomer to ASP.Net. I just need to create a hierarchy for each employee like employee name, then his immidiate manager and so on. For this i need to use a teeview. But i'm facing a problem when creating nodes dynamically. Here is a sample how my structure should look like.
xxxxxxxxxx
yyyyyyyyyyy
zzzzzzzzzzzz
aaaaaaaaaaaa
Also i want to expand and collapse each node with the + and - sign respectively.... -
Multiple Opening of an Application
I have a vb application where one EXE calls another exe, so that a new application opens. But when i want to open the same application again from the other application it gives an error that the application is already active and the new instance is not opened. I use SHELL function to open the exe. Needs help. Thanks in Advance. -
Thank u very much. This is working fine. Actually i wanted to read the RTF file as text file. So i have a problem while reading. I want to append a RTF file at the end of the other. But before attaching i want to remove the last text "\par }" of the first file and then attach the same file just after that. but i don't know how to do that. I read the input file to a output file like this. I think u know the RTF text file, i've posted to...Leave a comment:
-
i tried this but this is not working at all. Could u answer my next question in which i'm opening the RTF file as text file. Bcoz if i use WORD object it takes around 5-10 minutes to generate the whole report. So i want to use the FILESYSTEMOBJEC T. Thanking YouLeave a comment:
-
According to u i need to read the RTF file as plain text file line by line. Consider 'MyLine ' in which i'm reading a file line by line. If there is a text "<<s_naam>> " present in the line which is another file name. I want to replace "<<s_naam>> " with its whole content. How can i do that. Can this code will be do.
Actually my requirement is that previously my RTF file has only field names...Leave a comment:
-
yes i'm sending my RTF file.
{\rtf1\ansi \deff4\deflang1 033{\fonttbl{\f 4\froman\fchars et0\fprq2 Times New Roman;}{\f5\fsw iss\fcharset0\f prq2 Arial;}{\f70\fs wiss\fcharset0\ fprq2 KPN Sans{\*\falt Arial};}}{\colo rtbl;\red0\gree n0\blue0;\red0\ green0\blue255;
\red0\green255\ blue255;\red0\g reen255\blue0;\ red255\green0\b lue255;\red255\ green0\blue0;\r ed255\green255\ blue0;\red255\g reen255\blue255 ;\red0\green0\b lue128;\red0\gr een128\blue128; \red0\green128\ blue0;\red128\g reen0\blue128;\ red128\green0\b lue0;...Leave a comment:
-
The code supplied by u distorts the original format of the table. Also u've read the document up to "\\par" but i want to read the doc upto the end which consists of lot of field value to be replaced. And the original format of the table should remain same.
Can this be possible that i'll open the doc thru word object but delete the field code and remain the text as unchanged so that i can easily replace the text with its...Leave a comment:
-
Removing Field Codes
I've a word document which contains some field values like "<<s_naam>> ". How can i remove the field codes"<<" and ">>" , so that the text only remains.Thanx in advance for all suggessions -
Now starting with the issue to find and replace strings, it works fine. But at one point it gives a problem. When the replaced string is more than the cell width it is not displayed. Also when i single click on a replaced value the whole text is selected, that means after replacement it doesn't wrap into new line if the text size is large than the cell width. Bcoz i think it is treating it as field not text. i don't know the reason. But when i opened...Leave a comment:
-
I've some problem with WORD doc but i don't know the reason, need ur help.
U know that i'm replacing the field values(access datbse column names) in the DOC with the respective values(column values) from the Access databse. But when the text size exceeds a cell width , the text doesn't display i.e the text doesn't come(wrap) to a new line. But this is not the case when u type some text in the cell, i e. when u type some text in the cell and...Leave a comment:
-
The wordwrap property is not woking . Could u plz tell me the reason why its not working and provode me some alternate solution to that. Thanx in advanceLeave a comment:
-
Anybody having any idea to my question share with me.Leave a comment:
-
I tried the wordwrap property of the cell to True but it is not working. I'm not getting any alternate solution to that. Share if u have any alternate solution of to that. Thanking YouLeave a comment:
-
wrapping text inside a table cell
hi i'm using MS Word2003 for my VB application which is a report. The word documents contains tables and the cells inside the table contain some fields. My application replaces the field values with Values from database.
The problem i was getting is if the text length that is replaced is more than the cell length it was not displaying at all rather "Display Text Cannot Span More Than One Line" is displayed in that cell.... -
The thing is that i want to check if there is any text in the cell for a particular row. How i can check whether all the cells of the row are blank or not. I'm using the below code for checking:
...Code:dim lsColVal as variant For liS = 1 To wrdFinApp.ActiveDocument.Tables(1).Rows(2).Cells.Count lsColVal = wrdFinApp.ActiveDocument.Tables(1).Cell(2, liS) If (Len(Trim$(lsColVal)) <> 0) ThenLeave a comment:
-
Checking for a Blank Row
I've a word doc which contains a table with 3 rows and 6 columns of which one record is blank.I want to check for a blank row. How can i do that using VB 6.0. All suggessions are welcome. -
The thing is that i'm using Find and Replace method to replace the string to the particula field value in the document. The variable "lsVeldWaar de" gets the value from the database which is the big string. So where to put the code so that each substring inside the big string will come in a new line.
lsVeldWaarde = Replace(lsVeldW aarde, "\line", )
sReplace = lsVeldWaarde
With wrdApp4.ActiveD ocument.Applica tion.Selection. Find...Leave a comment:
No activity results to display
Leave a comment: