System.Data.SQLite

 I'm very new to this and to 2005. I'm writing an app for offline data entry and Sqlite seems ideal and I'm impressed with what I've seen so far.

I tested the data sources with data from the MSDE Nortwind test datbase to amke sure I got the data binding correct for customers and orders, you have to start somewhere :0), and that all worked fine. When I moved the customer the bottom grid for orders filled with the correct customer orders.

I tried the same with Sqlite and I can't get the same to work. I modified a test script I found for albums and tracks

CREATE TABLE album(
  id CHAR(10) NOT NULL PRIMARY KEY,
  title VARCHAR(100),
  artist VARCHAR(100));

CREATE TABLE track(
  album CHAR(10),
  dsk INTEGER,
  posn INTEGER,
  song VARCHAR(255),
  FOREIGN KEY (album) REFERENCES album(id));

and the binding source and tracking source look the same as the MDSE version I tried but the bottom datagrid tracks is not syncing. I'm probably missing something very basic so apologies in advance

Jim Florence

I'll try and duplicate the issue on my side -- if I have trouble, I may need you to send me a test app and database.

Robert

 

    Robert,

Thanks for the VERY quick reply. I created some very basic test data against those tables, 2 albums and 2 tracks per album. If you cant replicate it I'll happily send you the files

Regards

Jim

Robert,

After much hair pulling I re-created the database from scratch, twice, and it now seems to be working. That's the umpteenth time I've done it so goodness knows what's been happening.

Sorry for this but I was at it for a whole day before I posted and now it seems to just work, I hate computers :0)

Jim

Hi, This is exactly the same kind of demo i am trying to create, a master/details form. Can this all be done by adding the data sources and dropping onto the form, or do you have to start coding the datagrid datasources?

Regarding Foreign Keys, i couldnt find any info about explicitly defining these, i was using SQLite Maestro and it has no mention of them in the app. Are FK required for the code generator to work properly, or do i need to define them in the datasource relationship view? Should i stick to hand generating tables by code rather than tools?

Any pointers on how to do this would be much appreciated.