Re: [Gambas-user] Question on editing database tables

2015-12-19 Thread willy
On 2015-12-19 02:15, zainudin ahmad wrote: > This trick(0=0) worked for sqlite > > "0=0 ORDER BY Code, Date, Amount" > > May be any better idea ? > Thanks, I'll give it a try after the holidays (in 2 weeks) when I am back at work. gbWilly

Re: [Gambas-user] Question on editing database tables

2015-12-18 Thread zainudin ahmad
This trick(0=0) worked for sqlite "0=0 ORDER BY Code, Date, Amount" May be any better idea ? On Wed, Dec 16, 2015 at 10:24 PM, wrote: > Hi all, > > > I have used editing on tables multiple times like this for example: > > rResultEdit = $hConn.Edit("KasAanvullingen", "KassaCode = &1 AND Time =

[Gambas-user] Question on editing database tables

2015-12-16 Thread willy
Hi all, I have used editing on tables multiple times like this for example: rResultEdit = $hConn.Edit("KasAanvullingen", "KassaCode = &1 AND Time = &2 AND Date = &3", sKasAanvulCode, rResultAanvul!Time, rResultAanvul!Date) Now I'm facing a harder one: I have this table and it needs to be edit