[Gambas-user] prb:Connection.Exec() bypass sql code

[ron]

On Sunday 30 April 2006 00:14, Benoit Minisini wrote:
> On Sunday 30 April 2006 00:08, ron wrote:
> >
> > May I suggest in that case to add a method .UseTable(tablename as string)
> > that do the "select * from tablename" and a .MoveFirst() automatic.
> > In that way you can direct use the Result without additional commands.
> >
> >   hResult = hConn.UseTable("mytable")
> >   for each hResult
> >     print hResult["fieldname"] ' do something
> >   next
> >
> 
> Do 'hResult = hConn.Find("mytable")', that's all.
Not look at that one, as the name did suggest me something 
else with true/false or a index in the hConn.Tables as return.

> 
> Use DB.Debug=TRUE to understand what DB.Create(), DB.Find(), DB.Edit(), and 
> Result.Update() do.
> 
> Regards,
> 
enough stuff to play/search/try the next steps.

Thanks,

Ron