Tuesday, 28 December 2010

I think I'll leave the SQL alone for now.

Well, I enter the data, the table exists. I check the data entered ok, and the table exists. I try to query said data just a little later, and there is no such table.

I tried wrapping it in transactions; making sure the database closed... So I've given up on it for now. I'm keeping the Narrative interface, but stubbing out the SQL behind the scenes.

Next time I try it, I think I'll start with XML

Meanwhile: alerts. I want to prompt for the girl's name, and then on to the hard part - setting orders.

2 comments:

Anonymous said...

Can you specify witch type of SQL are you using and what do you need it for? Local DB or client server over the net? I might be able to help with it.

P.S. I would recommend SQLite ( http://www.sqlite.org/ ) for a local DB and MySQL ( http://www.mysql.com/ ) for a client server over the net.

Doc Clox said...

I'll do a follow up post I think - the editor's better :)