[Gambas-user] DataBrowser and SQL views

[Paolo Fagni]

On Jan 18, 2008 9:10 PM, Benoit Minisini <gambas at ...1...>
wrote:

> On vendredi 18 janvier 2008, Paolo Fagni wrote:
> > Hello,
> >
> > I'm experimenting with DataSource and DataBrowser, I can successfully
> use
> > the DataBrowser to print rows from a table but not from a persistent
> view
> > with SQLite.
> >
> > Gambas (latest version available) tells me that the table xxx doesn't
> exist
> > when I set
> >
> >  DataSource1.Table = "pView"
> >
> > Is there a way to use views with DataSource and DataBrowser? Or at least
> to
> > use Joined tables? Since I can do a "SELECT * FROM pView" with my
> database
> > connection it shouldn't be impossible...I guess :)
> >
> > By the way, what's the correct way to get data from the currently
> selected
> > row in a DataBrowser?
> >
> > Thank you.
> >
> > Cheers,
>
> I'm afraid there is no view support at the moment in the database
> component.
>
> To get the current data of a DataBrowser, you must ask to its DataSource.
> For
> example, if MyDataBrowser is inside MyDataSource, then you should do:
>
> PRINT MyDataSource[FieldName]
>
> You have method to move the cursor of the DataSource: MoveFirst, MoveLast,
> MoveTo... Other methods change its editable state: Create, Save, Cancel...
> Actually all these methods are called by the DataBrowser toolbar.
>
> Regards,
>
> --
> Benoit Minisini
>
> -------------------------------------------------------------------------
> This SF.net email is sponsored by: Microsoft
> Defy all challenges. Microsoft(R) Visual Studio 2008.
> http://clk.atdmt.com/MRT/go/vse0120000070mrt/direct/01/
> _______________________________________________
> Gambas-user mailing list
> Gambas-user at lists.sourceforge.net
> https://lists.sourceforge.net/lists/listinfo/gambas-user
>

Thank you for your clear explanation, and of course for your wonderful work
on gambas.

May I ask if view support is planned for some future release? Will it be
hard/time consuming to implement?

Thank you :)
-- 
Paolo Fagni