Search results for query: *

Hi, Just wondering if anyone would know why the below problem would be occuring?? We have a table which holds a BLOB column which we use to store word documents. Now there is a stored proc which reads this blob using DBMS_LOB.READ (rec_letter.letter_file, l_amount, l_pos, l_buffer); where...

Hi All, I have an application which I help build and created a msi file for installtion purposes. Installing the application registers a few dlls in the GAC. Now when I want to change something in the application from .NET I am changing of of these components dlls that is in the GAC. Now to...

Hi, Just need to know how to do a SQL select on say the data, node etc field from the SWLOCALMSG object which is used as a type for an advanced Queue. CREATE OR REPLACE TYPE SWLOCALMSG AS OBJECT ( msginfo VARCHAR2(500), node VARCHAR2(24), contenttype...

Hi, I have two tables (TabA & TabB) with a foreign key on TabB referencing a PK on TabA. Therefore there is a one to many relationship between the two tables. For the query below how which may produce a number of records from TabB , how can i limit it to just giving me the last record in the...

Hi, How would I write an update to increment the date field for a dataset by one day the column is a timestamp like '12-Sep-2006 12:34:00' I just want to increment the date part by a day and leave the time component as is. eg. update [table_name] set [column_name] = ....... Any examples...

Hi, How do I get two RichTextBox's to scroll vertically together? So when you scroll down one richtextbox it automatically scrolls the other as well. Examples would be helpful. Thanks Anthony

Hi, I am developing an application that will need to display the script for such objects as stored procs, triggers, schemas, seqeunces etc. How can I extract the script for a table or stored proc say that will show all in the script including indexes, constraints, grants etc. I would like it...

Hi, I want to be able to uppercase all Varchar2 fields on an Insert or Update Trigger. Currently I actually specify the the columns but can this be done generically across allthe fields without specifying the column names. CREATE OR REPLACE TRIGGER TOWER.INGPTST_TBIU_MOD BEFORE INSERT OR...

Hi, I want to be able to run SQLPlus's COPY command from within a PL/SQL block of code. Is this possible and how would I go about doing this?? Any examples would help greatly.. DECLARE {Variable Declarations} BEGIN {Code.....} {Be able to RUN COPY command} {Code} END; /

Hi, I am cuurently setting up an environment at home to mimic the setup at work, which is comprised of an application connected to a SQL Server. Now this SQL Server has linked Servers setup to other servers for Data transactions using triggers. Since I have only one SQL Server setup at home I...

Thanks for the help, will try it

Hi All, How do launch a word document. I need to launch a word document with prepopulated text. I want to be able to specify the the font and font size used when launching the Word Document. Any help or examples of code would be great Thanks Anthony

Yes I have downloaded the font 3 of 9, but how do I launch a word document already populated with barcoded text?

Hi All, I need some help printing Barcodes in word. I have a VB.Net application that does a few things but what I need it also to do is for a user to be able to enter text information into 5 text fields of the app and for it to launch Microsoft word using Code 3 of 9 font to display the 5...

Excuse me sem but I didn't quite understand you first comment. So how would I relate it to my example??

Hi All, Is it possible to pass use a variable or constant to pass the table name in a select query?? Such as the following DECLARE tablename CHAR(30); BEGIN tablename := 'Table' SELECT * from tablename; END; Or is there another way of doing querying tables dynamically?? Any...

Hi All, I would like to know with web pages, how does search engines recognise your web content. Is it done through some Keyword/s field on your web page? If this is the case what is the syntax/tag that is used for this? Also what I really would like to know is how to make your web page be...

Hi All, I want to be able to write an application that uses either an ISIS or TWAIN driver(ISIS preferably) to scan paper base files. I want to be able to scan different size paper and save it as either pdf or tiff formats. If anyone has any examples of this or any documentation of this, or if...

If it has a limit of serving just one website, will this enough for testing several web applications at different times. Also is this the same limit as found on Windows 2000?

Hi All, I just have a few questions about IIS. I have just installed Visual Studio.NET Architecture Enterprise on my Laptop running Windows XP. I want to be able to create Web Applications using .NET however I need IIS to be installed. Am I able to install IIS on XP and what is the new...