On 2/14/2010 10:46 PM, Jacek Kałucki wrote:
> Użytkownik Sim Zacks napisał:
>
>> app.DatabaseActivityLog is only logging some statements.
>>
>> I set app.DatabaseActivityLog to a valid path in my main.py
>> After login, it opens a form with a grid of the customers. I have a New
>> Customer button.
>> I click the button and it calls:
>> cust=CustomerDetails(self)
>> cust.requery()
>> cust.new()
>> cust.show()
>>
>> I then get a blank customer form. I fill in some of the details and
>> close the form (by clicking the x). It asks me if I want to save the
>> record. I click yes.
>>
>> I then close the application and look at the log. The only thing in the
>> log is:
>> Database Activity Log: Sun Feb 14 22:15:38 2010: SQL: select * from
>> customers limit 1000
>> Database Activity Log: Sun Feb 14 22:15:38 2010: SQL: pragma
>> table_info('customers')
>>
>> When I open the app again, the information that I entered for the new
>> customer is merged into the first customer in the grid. For example, If
>> I just write the customer name before Save, then the first record shows
>> the new name I typed with the address of the old first customer.
>> 2 Problems:
>> 1) The log doesn't show me neither an Insert nor an update statement,
>> but the database has changed.
>> 2) I expect it to be doing an insert and it is doing an update on a
>> specific non-chosen record.
>> This is a SQLite database.
>> Note that I don't have any code in the bizobj telling it what to do
>> onSave or onNew.
>>
>>
>>
> Hi,
>
> It's very strange. Logging works for me for all except preferences cursors.
> About second issue, could you show me entire bizobj definition,
> especially PK?
> Dabo has problem with compound keys and sometimes after new(),
> sets first row as current instead of newly created.
>
>
The table has a single primary key, customerid.
My bizobj is about as simple as you could get:
import dabo
class CustomerBizobj(dabo.biz.dBizobj):
def afterInit(self):
self.DataSource = "customers"
self.KeyField = "customerid"
_______________________________________________
Post Messages to: [email protected]
Subscription Maintenance: http://leafe.com/mailman/listinfo/dabo-users
Searchable Archives: http://leafe.com/archives/search/dabo-users
This message: http://leafe.com/archives/byMID/[email protected]
