Database

ya, should be "string.Equals()" But I was getting the cast exception BEFORE I added the Compare. I'm guessing that there's some problem comparing a SQL GUID against the .Net GUID If it's not broken, fix it until it is. Everything makes sense in someone's mind. Ya can't fix stupid.

So you're using SQL 2005 or earlier? You'll have to stick with datetime in that case. "These people looked deep within my soul and assigned me a number based on the order in which I joined." - Homer

thank you for help

This is not very clear. There are two kinds of people in the world: those who can extrapolate from incomplete data. There are only 10 types of people in the world, those who understand binary and those who don't.

SQL Server doesn't have built-in regular expression support, but you can add it with SQLCLR: GitHub - DevNambi/sql-server-regex: Run regular expressions in SQL Server[^] "These people looked deep within my soul and assigned me a number based on the order in which I joined." - Homer

I didn't look; he said he wanted the entire record, and add a single column. Means it is also easy to debug the subquery by using a value from the database as example. There will probably be multiple records with the same ar.BaySerialNumber, and I'm hoping that b.SerialNumber is the primary key (or at least uniquely indexed) on the Bays-table. Even if there's a one to one relation, that should work. So, what the schema of the tables? Would be nice to have a CREATE script for both tables :) --edit Asking the wrong person, and was already solved. Bastard Programmer from Hell :suss: If you can't read my code, try converting it here[^][](X-Clacks-Overhead: GNU Terry Pratchett)

Thanks for the heads-up. I'll move my thread over as soon as I finish my current set of tasks. Steve Naidamast Sr. Software Engineer Black Falcon Software, Inc. blackfalconsoftware@outlook.com

I didn't think of that, I'll add it now 21st Century Globalism has become Socialism on a planetary scale, in which the unequal treaties of the past have come back into play.

Actually looks more like the output of one of the online buzzword generators. ;)

I did but the problem is the temp files are going to be created with $ prefix but the extension is same and another thing is that the temp files is going to be renamed back to the original file I think that's the reason why, it was hard for me to catch it and fix it. I tried it in hard way but only got 90% success, the way is to not insert any record into the monitoring table if same file name and location file comes within 15 minutes of previous drop then don't insert it into the monitoring table, but still for some SSIS package may take more that 15 minutes to read, then still those files are showing up in the monitoring table. If there is any easy and proven approach that would be very helpful, thanks for the help buddy:) Thanks, Abdul Aleem "There is already enough hatred in the world lets spread love, compassion and affection."

Ah thanks, have not got used to the variations in MySQL yet and I would never find that wrinkle - spaces in field names are NEVER acceptable. Never underestimate the power of human stupidity RAH

I think I finally got the code correct to delete the records by customer number and invoice, guess I should run 1 more test on it. Maybe I just fixed the index file and now it works. Tired of working on this, not fun! Dim dwXCode As Integer = registry_shared.read_HKCU_dataPath(m_path) Dim connString As String = "Provider=VFPOLEDB; Data Source=" & m_path & "; DELETED = FALSE;" Using connection As New System.Data.OleDb.OleDbConnection(connString) Dim c1 As New System.Data.OleDb.OleDbCommand("SET EXCLUSIVE ON", connection) Dim c2 As New System.Data.OleDb.OleDbCommand("SET DELETED ON", connection) Dim c3 As New System.Data.OleDb.OleDbCommand("DELETE FROM ARTRS01H WHERE FCUSTNO = ? AND FINVNO = ?", connection) Dim c4 As New System.Data.OleDb.OleDbCommand("DELETE FROM ARTRS01 WHERE FCUSTNO = ? AND FINVNO = ?", connection) Dim c5 As New System.Data.OleDb.OleDbCommand("PACK", connection) c3.Parameters.Add("@FCUSTNO", OleDbType.VarChar).Value = pCustNo c3.Parameters.Add("@FINVNO", OleDbType.VarChar).Value = pInvNo c4.Parameters.Add("@FCUSTNO", OleDbType.VarChar).Value = pCustNo c4.Parameters.Add("@FINVNO", OleDbType.VarChar).Value = pInvNo Try connection.Open() c1.ExecuteNonQuery() c2.ExecuteNonQuery() Dim x As Integer = c3.ExecuteNonQuery() x += c4.ExecuteNonQuery() c5.ExecuteNonQuery() pValue.Result = If(x > 0, True, False) pValue.Message = x & " record(s) were deleted successfully" Catch sqlEx As SqlClient.SqlException pValue.Result = False pValue.Message = sqlEx.Message.ToString Catch exdb As OleDb.OleDbException pValue.Result = False pValue.Message = exdb.Message.ToString Catch ex As Exception pValue.Result = False pValue.Message = ex.Message.ToString Finally connection.Close() End Try 21st Century Globalism has become Socialism on a planetary scale, in which the unequal treaties of the past have come back into play.

I don't use Fox Pro, it's just an app that a customer of mine has and it's quick money, but got it working last Friday. 21st Century Globalism has become Socialism on a planetary scale, in which the unequal treaties of the past have come back into play.

Thanks. That helped... Working fine now If it's not broken, fix it until it is. Everything makes sense in someone's mind. Ya can't fix stupid.