Search results for query: *

Hi, I have got a program which dynamicaly compiles a vb-file when it is being executed, this allows me to alter the code in the vb-file without altering the executable. So far so good, I did manage to create this using CompileAssemblyFromSource(). The problem I have is the following.... From...

After quite some puzzling I finally found the answer to this question. Enlarge the bitmap to whatever you want it to be, than set the e.Graphics.PageScale setting (in the PrintPage event) to Papersize divided by Bitmapsize. This will do the trick. Grtz, Kalin

Hi, I have the following problem.... I want to print some image on a sheet of A4 paper, my printer is capable of a much higher resolution than de default resolution of A4 paper in Visual Basic. How can I change this....??? Example: Standard size for A4 in Visual Basic = 780 * 1130 My...

How do I retrieve the name of the current package from within a script task ?? Grtz, Kalin

Why not use the top xx percent clause ?? Select top 96 percent * from table where id-column not in (select top 2 percent id-column from table) Grtz, Kalin

SQLBill: There were no dba tasks performed. Thus no reindexing no maintenance or defragging. There were no large transactions performed. Furthermore nothing different from the normal operations where carried out on the db. Dr.Sql: datafile 4896Mb Logfile ~1200Mb Space available 0 Mb Grtz...

Hi all, I have a SQL-Server database (size +/-5 GB) which filled up completely, to my suprise because this database had unlimited filegrowth enabled and the disk wasn't full. After creating a second datafile the database continued to operate normally. Any thoughs on what may have caused this...

Hi, in a db I have I have a view which is a pivottable made from a table in this db. I need to export this data to Excel on a regular basis, so I want to create a DTS package to refresh the view (drop and recreate) and then export it to Excel. Since the view is a pivot of one of the tables the...

Hi Dalchri, I've tried your solution but it gives me the following error... An unhandled exception of type 'System.InvalidCastException' occurred in Proj18xx.exe Additional information: Specified cast is not valid. The code I wrote is: Dim tabTiles As DataTable Dim rowTile() As DataRow Dim...

Hi, I've got a dataviewmanager through which I filter some data in a dataset (multiple tables parent-child). So far so good. When I retrieve the data in a datagrid I get precisely the data I need but how can I retrieve this data programmaticaly ?? Thus step through the filtered dataset ...

Where can I find the drop and recreate table option is it part of a sql-statement or task. Grtz, Kalin

Well, the files are imported once a month. Each month each file consists of approx. 10 set columns followed by a number (which can vary for month to month) of variable columns. Example: In January we get a total of 10 columns: Col A; Col B; Col C; Col D; Col E; Col F; Col G;etc In February...

Hi, I want to import a CSV-file into SQL-Server. The column headers for the columns are on the first line. The file contains approx. 500000 records. So far no problem.... But the columns can vary both in amount and composition. So I need to dynamicly create a table based on the file and the...

Thanks..... Grtz, Kalin

Hi all, I'm creating a function, it works when I remove the last or second last else if statement. But fails (Incorrect syntax near the keyword 'ELSE' on line 14) when I include both. Source: Alter Function fn_SwapRuimte (@LijnID nvarchar(20)) RETURNS @fn_SwapRuimte table (Origin...

Hi Plank, isn't DTS an option for you. In it you can transform your data while the db remains online... Grtz, Kalin

Hi, isn't DTS an option for you.... In it you can create an copy-action while the db is online.... Kalin Grtz, Kalin

How do you specify the home which a application (forms or other) should use during runtime ?? Grtz, Kalin

Hi Sem, because the installs aren't always in the same order I can't depend on one of the two being the default home, so if I have a application which depends on the Oracle 9i client and the forms install (with a 8i conectivity) is the default home, the application can't connect to the 9i...

Sounds like the .dmp file is a dumpfile which has to be imported using import. Import can be found in the bin directory of your Oracle home directory and /? will give you the parameters with which to import the file. Grtz, Kalin