Hi, I'm using VB.net express edition with SQL server compact for a project and I need a little help. What I'm trying to do is; I want to set a certain column to true or false automatically based on what value another column has entered. I managed to get this working by myself using the 'SQL Pane' in VB and testing it by using execute sql but I don't know what to do now. I assumed that I could just save it and it would work from there but that's not the case, it dissapears from the SQL Pane if I close the project (even though it worked fine when I ran the project the first time), so where do I put it/what do I do with it in order to get this to work?

Any help would be appreciated :)

Edited by InS@NiTy: n/a

6 Years
Discussion Span
Last Post by InS@NiTy

Ah, sorry I figured this out, I was just doing something really stupid.
Here's what I did if anyone would find it useful:

Public Sub Refresh_T()
        Dim SQLCon As SqlServerCe.SqlCeConnection
        Dim SQLCmd As New SqlServerCe.SqlCeCommand

            SQLCon = Connect()
            SQLCmd = SQLCon.CreateCommand
            SQLCmd.CommandText = _
            "SELECT (Table Columns) CASE WHEN (1) > (2) THEN 'Yes' ELSE 'No' END AS (Column to be filled in) FROM (Table)"

        Catch ex As Exception
            MessageBox.Show("There was a problem connecting to the Database!")

        End Try
    End Sub

It was a lot simpler than I thought it would be :P
(The query is just a placeholder.)

Edited by InS@NiTy: n/a

This question has already been answered. Start a new discussion instead.
Have something to contribute to this discussion? Please be thoughtful, detailed and courteous, and be sure to adhere to our posting rules.