I am in programming hell.

As I posted earlier, I am writing an all purpose URL manager. It was going really well at first, I have a really nice clean, minimal u_i, and some pretty gnarly features. But in the interest of HD space and effeciency, I opted to use a databse structure to store the URLs that are imported and/or added to the program. I have mucked through all the really difficult parts, and now am being stopped cold by a ridiculous error, that none of my geeky little friends can identify!

I have been bashing my head into the wall for the past 8-10 hours, it has gotten so bad that I couldn't sleep last night. I retired at 2:00am and was up again slaving on it at 7:45! I was seeing things like this in my sleep:

dim r as databaserecord
  dim d as database
  dim s as string
  dim mySelectedURL,mySiteName as string
  dim theSQL as string
  d=DBase
  mySelectedURL=SelectedURL.text
  mySiteName=SiteName.text
r=new databaserecord
r.column("SelectedURL") = mySelectedURL
r.column("SiteName") = mySiteName
if d (actual character omitted) nil then
d.insertRecord "Conan",r
SelectedURL.text=""
SiteName.text=""
if d.error then
  msgBox d.errormessage
end if
else
end if

This is driving me up the wall. And I am posting this to give myself a break, but after this is posted I will right back at it.

Someone, please help me.