Re: [Gambas-user] Questions about SQLIte and Data Objects

Benoît Minisini wrote: > > Le 10/08/2012 01:34, acidblue a écrit : >> >> I noticed when i use 'datetime' as a type in sqlite it also adds a time >> at >> the end the date: >> 8/9/2012 00:00:00 when displayed in a dataview box. >> >> Is

Re: [Gambas-user] Update DataView??

"Unknown Symbol DataView1 in class FMain" Is the error I'm getting. Sorry for the late reply. Code: Try rTable.Update If Error Then Print "Update failed" Message.Error(ERROR.Text) Else FMain.DataView1.Update Message.Info("Update was successful")

[Gambas-user] Questions about SQLIte and Data Objects

I noticed when i use 'datetime' as a type in sqlite it also adds a time at the end the date: 8/9/2012 00:00:00 when displayed in a dataview box. Is there a way to NOT display the time, just the date? I have to re-adjust the column widths every time program loads,(using dataview),this is inherit

Re: [Gambas-user] Adding a date to a number

I tried this and it works fine. Dim $date As Date $date = DateBox1.Value + vbxFlwrTime.Value txtFin.Text = $date acidblue wrote: > > I have a date box that I want to use for adding a number of days to. > EX: say user picks date 9/10/12(American style date format) and enters >

Re: [Gambas-user] Adding values to fields in SQLite table??

Ahh I like that idea! I 'm now using Gambas 3 ;) When you say make module do you mean make an actual module(Right click>>new>>module) or can i add this code to the FMain form?? CODE Public sub Main() Connections["MyConnection"].Open End Fabien Bodard-4 wrote: > > 2012/8/8 Adam Ant > >> On

Re: [Gambas-user] Adding values to fields in SQLite table??

Fabien Bodard-4 wrote: > > 2012/8/8 Adam Ant > >> On Wed, Aug 8, 2012 at 2:59 PM, Fabien Bodard >> wrote: >> > Le 8 août 2012 04:49, "Adam Ant" a écrit : >> >> The answer is: >> >> >> > It's create >> >> rTable=$hConn.create("Inventory",> >> want to update>) >> >> IF rTable.Available then >