Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations Chriss Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Recent content by omacron

  1. omacron

    Database logon to a Crystal at runtime in VB.NET & Stored Procedure

    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...
  2. omacron

    Updating a list(t)

    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...
  3. omacron

    Datagridview Multiple Row headers

    That is not exactly what I need. It needs to be an actual row header and have a visual separation, not just a space.
  4. omacron

    Datagridview Multiple Row headers

    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...
  5. omacron

    Data Source Configuration Wizard issue

    Bluejay07 I will try to be more clear. To your point; No I am not having an connection issue. I want to use the connection wizard but the only options are; http://members.shaw.ca/mwence/changedatasource.jpg The options for Microsoft SQL Server Compact 3.5 are...
  6. omacron

    Data Source Configuration Wizard issue

    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...
  7. omacron

    Writing to the registry and VirtualStore

    Yes, well more correctly some BS about they are working on it... That isn't an option, the user base of this product could not handle it. Let me put it this way in an upgrade to the application there is a step of tab, tab, place a paper into a printer then hit enter got change to tab, tab...
  8. omacron

    Writing to the registry and VirtualStore

    I have contacted the software developers and they are unwilling to change at this point. Some BS about needing to write to the registry for speed and I/O concerns. If you have an idea what to suggest to them I am willing to try that.
  9. omacron

    Writing to the registry and VirtualStore

    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...
  10. omacron

    Add column named &quot;Comment&quot;

    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...
  11. omacron

    Securely delete data from a table

    thanks for information.
  12. omacron

    Securely delete data from a table

    Yeah I know that, but is it secure? It it cached someplace (auto commit turned on)? Is it in memory for a given time? FYI I am ignoring user generate backups.
  13. omacron

    Securely delete data from a table

    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...
  14. omacron

    Database will not shrink

    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...
  15. omacron

    IF NOT EXIST syntax

    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...

Part and Inventory Search

Back
Top