Re: [Ironpython-users] DataSet --> SQLite

2012-03-16 Thread Sven Thomas
t; Sent: March-16-12 10:49 AM > To: Vernon Cole > Cc: Sven Thomas; [email protected] > Subject: Re: [Ironpython-users] DataSet --> SQLite > > On Wed, Mar 14, 2012 at 3:34 PM, Vernon Cole > wrote: > > I would suggest opening both databas

Re: [Ironpython-users] DataSet --> SQLite

2012-03-16 Thread Jeff Hardy
On Wed, Mar 14, 2012 at 3:34 PM, Vernon Cole wrote: > I would suggest opening both databases in their native form, then do the > comparison using Python code rather than a complex SQL query. It may take a > while to run, but should work okay. SQLite select statements are quite fast. > Trying to do

Re: [Ironpython-users] DataSet --> SQLite

2012-03-14 Thread Vernon Cole
I would suggest opening both databases in their native form, then do the comparison using Python code rather than a complex SQL query. It may take a while to run, but should work okay. SQLite select statements are quite fast. Trying to do the whole thing in one swallow may be too much. Better to do

[Ironpython-users] DataSet --> SQLite

2012-03-14 Thread Sven Thomas
Greetings all, I'm sort of new to IP and brand new on this mailing list. J Here's my situation: I need to build a report of everything missing from our institution's library that isn't accounted for (i.e. we want to find what's been stolen/lost, etc.) That means the librarians will scan