On Sunday 23 December 2007 02:31:09 pm Adrian Klaver wrote:
> Database: Postgres 8.2
>
>
> 1) Given-
> bz=self.PrimaryBizobj
> bz.moveTo RowNumber(45)
> self.update(0)
> Is this the best way to bring the UI in sync with the bizobj?
Yes. However, I have not found a need to pass "0" to the update method.
>
> 2) I updated a field in a table from psql. I then ran self.update(0)
> against the form that pointed to that table. I expected to see the field
> value changed to reflect the update in the backend, but it was not. Am I
> missing something?
Assuming a commit was issued. And I'm guessing a self.requery() did work?
You are running into the most common problem of multi-user environments and
we could fill a book with a complete discussion. So a short answer is - Dabo
has the concept of a cursor or DataSet. So the data is memory and does not
know about the change to the backend. But a requery should retreive the
current/changed data.
>
> 3) Am I correct in assuming bizobj.seek() only does exact matches (the
> caseSensitive & near options notwithstanding). In other words I cannot
> do '%mint%'?
I believe that is correct. Something like the following would work:
mybiz=self.Form.getBizobj("public.arcust")
mybiz.setWhereClause("company like '%mint%")
self.Form.requery()
--
John Fabiani
_______________________________________________
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/dabo-users/[EMAIL PROTECTED]
