So here's an issue I ran across this last week. I have an windows service that connects to an oracle 9i database. It's a pretty simple app really, all it needs to do is select from tables in the database and insert into the tables. 5 of the 6 inserts work just fine. However the last one only inserts the last record in the dataset. The one major difference between this table and the other 5 is it has a field in it that's a reserved word in oracle “UID“. The dataset is strongly typed and I've attemped the insert (adapter.update) using the oracle data provider and the oledb provider for oracle. Both yield the same results. I even went so far as to write an oracle stored proc to handle the insert instead of raw SQL.
FYI, if I change the reserved field name to something other than the reserved name the insert works like a charm. Also, the select statement works just fine retrieving all records from the table. So the problem is only with the insert.
So what say you people? Has anyone come across this before?
So here I sit writing my first blog post and I must say it's somewhat of a relief. Why you may ask? I shall tell you.. Peer pressure, that's right, we all remember that after school special. As you can see by my 'cohorts' section several of my friends are long standing contributors to this blogitorium. They all also happen to be members of the WeProgram.NET user group. As per our usual post meeting banter the subject of blogs and blogging comes up.. Along with that the inevitable question; “So when are you going to start a blog Chris?”. Well I could stands no more, so let the blogging goodness commense!
So for my first useful contribution I submit this: edtFTPnet. This is a open license FTP API whose methods mirror the old command line FTP commands. I've used this API in several windows services I've written when I needed to retrieve data files from our various clients. It's easy to implement and it's free. It doesn't get much better than that. If your app needs FTP functionality I recommend this.