Re: [Gambas-user] prb:Connection.Exec() bypass sql code
Brought to you by:
gambas
From: ron <ro...@ti...> - 2006-04-29 22:27:55
|
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 |