Bah! Stupid programming.

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.