Skip to content

Geography hierarchy recognition resources

I’m currently working on a project involving geographic locations and our program needs to state whether location A is contained in location B. Currently, we do it using administrative codes in …

Firebird with .net driver – drop table if exists

I’m new to Firebird and I’m testing a few things to check out the differences between Fb and SQlite (and the .net driver). I am trying to do a drop table if exists followed by the creation of a table. In Sqlite I am able to do this by: However in Firebird the same query fails. I’ve read that…

SQL Update when not in subquery?

I have 2 tables: tblAbsence Name Start End Status John 4/2/18 4/5/18 Approved Sue 5/1/18 5/10/18 Denied tblManning Date Required 4/1/18 3 4/2/18 4 4/3/18 2 I would …

Can I programmatically exit a Firebird script

Consider the following script: The exit is perfectly valid and does cause script execution to end. At least in IBExpert where I am testing this. But I want to do this programmatically. Is the exit in my first example valid Firebird or is IBExpert handling this itself? Is there a different way to exit the enti…

Data Mismatch Error in VB.net SQL statement

I have this code: Protected Sub unlikebtn_Click(sender As Object, e As EventArgs) Handles unlikebtn.Click Dim strSQL As String Dim MemberDataConn As New OleDbConnection(“Provider=Microsoft….

how to write sql query text for IN clause in C#

I want to know how can I write a sql query in C# where I have to use multiple strings in the IN clause. I have a List ListSessionId, and I want to use each of them in my IN clause. Something like: …