Ed Leafe wrote:
Seems like based on my first few tests, PySQLite doesn't handle Decimal at all; I get the error: "pysqlite2.dbapi2.InterfaceError: Error binding parameter 1 - probably unsupported type.". If I change that value to a float, it works, but I get back a float. It also totally hoses dates, but I saw on the pysqlite website that there are converter routines for datetimes, so maybe there are some for date values, too.
Right, and there will likely be ways to handle decimal too, even if we have to roll that on our own. Isn't pysqlite completely implemented in Python (I could be wrong)?
I'll look into this further, then. The stuff I created works great for what I had in mind, but I agree that trying to make a full SQL implementation is a waste of time, and once you let people do simple stuff with DataSets, they'll want to do more!
Cool. I feel *much* better now. Not that I don't think we have the ability to do this ourselves, just that it seemed like the scope wasn't just creeping, it was detonating. ;)
This is leading back to where I originally envisioned for Dabo: cursors in data environments that could be easily referenced, linked together, iterated, etc. It is *the big strength* of Fox, having a powerful local cursor engine. I absolutely love the idea, especially if it leads to the cursor being more separate from the bizobj instead of bizobj totally wrapping cursor.
I just got kind of freaked out thinking that we were going to try to implement all this ourselves, when we've already committed to implementing other daunting things (ide, report designer, etc.).
-- Paul McNett http://paulmcnett.com http://dabodev.com _______________________________________________ Post Messages to: [email protected] Subscription Maintenance: http://leafe.com/mailman/listinfo/dabo-dev
