Re: [dabo-users] Form.save()?

2010-08-27 Thread Ed Leafe
On Aug 27, 2010, at 1:05 AM, Paul McNett wrote: > I make sql script files, like: > > {{{ > create table customers (id char(40), name char(64), ...) > create table blah (id char(40)...) > ... > }}} Same here. > and then I execute them in Python like: > > {{{ > import sqlite3.dbapi2 as s

Re: [dabo-users] Form.save()?

2010-08-27 Thread Paul McNett
On 8/27/10 5:50 AM, Ed Leafe wrote: > Sounds like a lot of work. I just do this at the command line: > > sqlite3 path_to_new_db< myscript.sql That's cool, but it requires the sqlite client to be installed, and I'm running this creation code from within my python program distributed with p

Re: [dabo-users] Form.save()?

2010-08-27 Thread Ed Leafe
On Aug 27, 2010, at 9:34 AM, Paul McNett wrote: > That's cool, but it requires the sqlite client to be installed, and I'm > running this > creation code from within my python program distributed with py2exe, py2app, > and > cxFreeze. I didn't know that you could have sqlite3 installe

Re: [dabo-users] Form.save()?

2010-08-27 Thread Adrian Klaver
On Friday 27 August 2010 6:41:17 am Ed Leafe wrote: > On Aug 27, 2010, at 9:34 AM, Paul McNett wrote: > > That's cool, but it requires the sqlite client to be installed, and I'm > > running this creation code from within my python program distributed with > > py2exe, py2app, and cxFreeze. > >

Re: [dabo-users] Form.save()?

2010-08-27 Thread Jim Byrnes
Jim Byrnes wrote: > Ed Leafe wrote: >> On Aug 25, 2010, at 1:03 PM, Jim Byrnes wrote: >> >>> Will Form.save() save changes to a record or just save new >>> records? >> >> It will save all changed records, whether new or not. >> >>> I ask because if I edit a dTextBox and then try to save it to a >>>

Re: [dabo-users] Form.save()?

2010-08-27 Thread Paul McNett
On 8/27/10 8:12 AM, Jim Byrnes wrote: > It may be apparent to a more experienced coder than myself but it seems > Dabo's .save() needs a table with a primary key to work. Now to put this > to use on the app I'm working on. Ooh, yeah, pk's are a definite requirement for updating records (but not fo

Re: [dabo-users] Dabo-users Digest, Vol 74, Issue 26

2010-08-27 Thread Jamie Adams
On Aug 27, 2010, at 9:34 AM, Paul McNett wrote: > > That's cool, but it requires the sqlite client to be installed, and I'm > > running this > > creation code from within my python program distributed with py2exe, > > py2app, and > > cxFreeze. > Paul, this is something I would like to kn

Re: [dabo-users] Form.save()?

2010-08-27 Thread Jim Byrnes
Paul McNett wrote: > On 8/27/10 8:12 AM, Jim Byrnes wrote: >> It may be apparent to a more experienced coder than myself but it seems >> Dabo's .save() needs a table with a primary key to work. Now to put this >> to use on the app I'm working on. > > Ooh, yeah, pk's are a definite requirement for u

[dabo-users] Packaging Dabo Apps (was: Re: Dabo-users Digest, Vol 74, Issue 26)

2010-08-27 Thread Paul McNett
On 8/27/10 9:31 AM, Jamie Adams wrote: > On Aug 27, 2010, at 9:34 AM, Paul McNett wrote: > >>> That's cool, but it requires the sqlite client to be installed, and I'm >>> running this >>> creation code from within my python program distributed with py2exe, >>> py2app, and >>> cxFreeze. >> >

Re: [dabo-users] Form.save()?

2010-08-27 Thread Ed Leafe
On Aug 27, 2010, at 1:22 PM, Jim Byrnes wrote: >>> It may be apparent to a more experienced coder than myself but it seems >>> Dabo's .save() needs a table with a primary key to work. Now to put this >>> to use on the app I'm working on. >> >> Ooh, yeah, pk's are a definite requirement for updati

Re: [dabo-users] Form.save()?

2010-08-27 Thread Paul McNett
On 8/27/10 10:33 AM, Ed Leafe wrote: > On Aug 27, 2010, at 1:22 PM, Jim Byrnes wrote: > It may be apparent to a more experienced coder than myself but it seems Dabo's .save() needs a table with a primary key to work. Now to put this to use on the app I'm working on. >>> >>> Ooh, yeah

Re: [dabo-users] Form.save()?

2010-08-27 Thread Jim Byrnes
Paul McNett wrote: > On 8/27/10 10:33 AM, Ed Leafe wrote: >> On Aug 27, 2010, at 1:22 PM, Jim Byrnes wrote: >> > It may be apparent to a more experienced coder than myself > but it seems Dabo's .save() needs a table with a primary key > to work. Now to put this to use on the app I'm wor

Re: [dabo-users] Packaging Dabo Apps

2010-08-27 Thread Henning Hraban Ramm
Am 2010-08-27 um 19:27 schrieb Paul McNett: > It was trial and error, trial and error, and it consumed many many > hours just to get > it working on Windows. Then it was many many hours getting it > working on Mac. The same for me. Here's a sample of a setup.py that works for me on the Mac and