Search results for query: *

Trying to created a vb.net program to run some existing crystal reports. Doing a test program this code correctly ran the report; Dim cryRpt As New ReportDocument cryRpt.Load("C:\MyCrystalReport1.rpt") CrystalReportViewer1.ReportSource = cryRpt...

I have a list(t) defined as; Public Class typeList Private mType1 As String Private mType2 As String Private mType3 As String Private mType4 As String Private mTotal As Double Public Property Total() As Double Get Return mTotal End Get...

Hi I have a DataGridView were I need to have multiple row headers. Like this; C1 C2 C3 Ra R1 Ra R2 Rb R1 Rb R1 Cannot seem to get it to work. Here is some sample test code I have been working with; Public Class Form1 Private Sub Form1_Load(ByVal sender As...

Hi First want to say I am very new to VB (like 6 hours into learning it) and using VB 2010 Express. I need to connect to a MS SQL DB, that is not on my computer. If I use the Data Source Configuration Wizard the only options for the type of Database connection are; Microsoft SQL Compact 3.5...

Hi I have an application that needs to move to Windows 7. The issue is that it writes to the registry (HKLM > Software => <Application Name>). The issue is with VirtualStore it redirects the registry write to the VirtualStore for each user. This would be fine but different users log into the...

Hi I am running into an issue and don't know if there is a solution. My app runs on multiple DBMS packages (Oracle, DB2 and MS SQL). There were features that were originally added to DB2 and now need to ported over to Oracle. In the new features a new table was required and in that table one...

Hi I don't even know what I am about ask exists or if DB2 does it already. I am being asked to securely delete data from a table. Its a two fold issue; one is to delete only select records from a table, the second is to delete data from a field. So for example, table Customers CustID...

Hi This is a MS SQL Express 2005 database. It was getting close to the 4GB cap so purged some data out. It only got about 200MB back when I was expecting around 800-1,000MB. So I shrunk (MS SQL Management Studio => Expand Server => Expand Databases => Right click on the database => Right...

Hi I am new to DB2 and have a simple problem. Trying to get an IF NOT EXIST statement work. Here is my code; IF NOT EXISTS (select * from ABC.table1 where field1 = 1100200) THEN INSERT INTO ABC.table1 ("field1") VALUES (1100200); END IF; Toad keeps telling me there is an error at the...

Hi I feel completely stupid but can not find the answer. Oracle 10g is fresh installed on Windows XP and I am trying to log into the Weblogic Server administration Console. Don't know what the user name and password to use. I have tried all my local accounts. Reading the manual all I have...

Hi This might sound odd but I am trying produce the error message when a table is locked and an update/delete state runs against that table. So what I did was lock a table and then on another terminal do a delete on the table. The problem is when I do in the delete in SQL Plus it doesn't...

I need to be able to disable foreign constraints on all tables. Is there a script to do that? Also I will need to enable after words.

Hi Currently I need to export all tables from a schema in DB2 9.5 to Oracle 10g. The only way I have found is doing it manually table by table. Please tell me there is a better way. thanks

Hi I am sure making this harder then it is. I need to display the hour of a datetime field, problem is that; Hour(Table.Date) is giving it to me in military time. I want to display it with AM/PM on it. Been looking around and can't find anything on how to do this. I could do something...

Hi Client has a Windows 2003 SP1 server, that every time it reboots get the following errors Event Type: Error Event Source: Service Control Manager Event Category: None Event ID: 7001 Date: 1/10/2009 Time: 9:23:35 AM User: N/A Computer: SERVER Description: The Galaxy Client Event Manager...

Hi I am try to compare a VARCHAR field that stores a date as: MMDDYYYY To a date time field. So what I am doing is running a script like this; select TransactionID, DateTimeField, VarCharDate from Table where to_char(DateTimeField, 'MM-DD-YYYY') <> to_char(to_date((VarCharDate)...

Hi I need to do a conversion of a julian date in a SQL script. Meaning convert a julian date to a calendar date. Is there a way of doing this? thanks

Hi I am trying to setup a silent install of MS SQL Express. Here is the command I am using; sqlexpr32.exe -q /norebootchk /qn reboot=ReallySuppress INSTANCENAME="name" SECURITYMODE=SQL SAPWD="password" SQLAUTOSTART=1 DISABLENETWORKPROTOCOLS=0 The problem is that all that gets installed is...

Hi I have a MS SQL MSDE database that came up in suspect mode. I am trying to get a backup copy but it will take some time. Meanwhile I want to try to fix it. Switch the database to Emergency Mode and ran; DBCC checkdb('dbname') It showed some errors in two tables. So switched the...

Hi I am trying to do a simple Trim command but have some problems. Here is a sample data; XXXX123456YYYYYYYYY note: XXXX is a constant YYYYYYYYY is a constant What I need to do is strip out the X's and Y's so only the numbers appear. This is what I am doing right now; if InStr...