Re: [Gambas-user] Cursor in wrong place in gambas 3

2013-04-04 Thread Rocko
Sort of. Upgrading to 3.4 fixed it On Apr 4, 2013 11:04 AM, "Zach Smith" wrote: > On 4/1/2013 1:01 PM, rocko wrote: > > I have a very strange and irritating problem in Gambas 3. > > > > The Cursor is off by about 2 characters, when I'm typing/editing code in

Re: [Gambas-user] Output to Libre Office Writer ??

2013-04-04 Thread Rocko
you say quote but you use parentheses in your example which is it? On Apr 4, 2013 7:21 AM, "Tobias Boege" wrote: > On Wed, 03 Apr 2013, rocko wrote: > > I discovered the Trim$ function. :) > > So far so good. > > You don't need to remove the spaces if it har

Re: [Gambas-user] Output to Libre Office Writer ??

2013-04-03 Thread rocko
I discovered the Trim$ function. :) So far so good. On 04/03/2013 02:01 PM, rocko wrote: > Thanks for all you help. > > I figured out why it saves as .zip instead of .odt. > Apparently there a spaces at the end of the names in the database I'm > using. > So it looks

Re: [Gambas-user] Output to Libre Office Writer ??

2013-04-03 Thread rocko
/2013 10:55 AM, Willy Raets wrote: > On Wed, 2013-04-03 at 19:36 +0200, Willy Raets wrote: >> On Wed, 2013-04-03 at 10:13 -0700, rocko wrote: >>> Ok thanks for suggestions. >>> >>> I'm now having problems with zipping the files. >>> I "m naming

Re: [Gambas-user] Output to Libre Office Writer ??

2013-04-03 Thread rocko
wrote: > On Wed, 2013-04-03 at 09:18 -0700, rocko wrote: >> Ok I got that to work, but the code is kinda long and ugly >> as I have to save the file after doing a /Replace/. >> >> I have 6 fields I have to replace, so thats 6 Replace statements with 6 >> File.Sav

Re: [Gambas-user] Output to Libre Office Writer ??

2013-04-03 Thread rocko
Replace could take multiple arguments for replacing multiple fields. But oh well.. On 04/03/2013 08:57 AM, Willy Raets wrote: > On Wed, 2013-04-03 at 08:39 -0700, Rocko wrote: >> so each value needs it's own the replace statement? > YES > >> On Apr 3, 2013 8:28 AM, "Fabi

Re: [Gambas-user] Output to Libre Office Writer ??

2013-04-03 Thread Rocko
so each value needs it's own the replace statement? On Apr 3, 2013 8:28 AM, "Fabien Bodard" wrote: > Ok so it's one call by entry. > > Unzip odt > Load the file in a string > Replace as many as need > Save the string in the file > Zip the directory >

Re: [Gambas-user] Output to Libre Office Writer ??

2013-04-03 Thread Rocko
I don't think you understanf, I want to replace different fields with different values not all the same value On Apr 3, 2013 1:41 AM, "Fabien Bodard" wrote: > Replace, > Replace all the words that match the pattern > Read the doc! > Le 3 avr. 2013 01:10, "rocko&

Re: [Gambas-user] Output to Libre Office Writer ??

2013-04-02 Thread rocko
Is it possible to do multiple replacing with/Replace/ I have several fields that I want to change in an .odt file do I have to do multiple Replace statements or can I put them all in one /Replace/ statement?? On 04/02/2013 03:34 AM, Fabien Bodard wrote: > Le 2 avr. 2013 01:37, "rocko&q

[Gambas-user] adjust widths of data broswer

2013-04-02 Thread rocko
Is there a way to change the width of the fields in data browser?? -- Minimize network downtime and maximize team effectiveness. Reduce network management and security costs.Learn how to hire the most talented Cisco Cer

Re: [Gambas-user] Output to Libre Office Writer ??

2013-04-02 Thread rocko
variable naming convention, example: > Dim sName As String > Dim fVar As Float > Dim iVar As Integer > Dim hFile As File > > etc. > This makes reading the code much easier; you almost always know enough > about variable type from it's name. > > Jussi > > > >

Re: [Gambas-user] Output to Libre Office Writer ??

2013-04-02 Thread rocko
BTW this is the offending code: _ newFile = Replace(File.Load(xName), "$(Name)", mName)_ On 04/02/2013 03:34 AM, Fabien Bodard wrote: > Le 2 avr. 2013 01:37, "rocko" a écrit : >> Not sure I'm using /Replace$/ correctly. >> I want to replace instance of $

Re: [Gambas-user] Output to Libre Office Writer ??

2013-04-02 Thread rocko
ng Public Sub Main() Dim mName As String Dim newFile As File mName = "Rocko" fName = "/home/rocko/Documents/Proposal.odt" xName = "/home/rocko/Zip/content.xml" If Exist(fName) Then /'test if file exists using th testFile function/ testFile() Print "F

Re: [Gambas-user] Output to Libre Office Writer ??

2013-04-01 Thread rocko
Not sure I'm using /Replace$/ correctly. I want to replace instance of $(Name) in the XML file with the value of the /mName/ variable Code: /xName = "home/rocko/Zip/content.xml"// // newFile = Replace$(xName, "$(Name)", mName)/ Of course this doesn't work, But I do

Re: [Gambas-user] Output to Libre Office Writer ??

2013-04-01 Thread rocko
Thanks, after some googleing i discovered the -d option. On 04/01/2013 09:59 AM, Jussi Lahtinen wrote: > unzip takes -d switch for defining folder to extract files. > > Jussi > > > > On Mon, Apr 1, 2013 at 5:19 AM, rocko wrote: > >> Ok I got this to unzip the .odt

[Gambas-user] Cursor in wrong place in gambas 3

2013-04-01 Thread rocko
I have a very strange and irritating problem in Gambas 3. The Cursor is off by about 2 characters, when I'm typing/editing code in the editor, the cursor is never where it supposed to be, it doesn't go to the end of a line or character/word, its back by 1 to 2 characters, Which makes it very har

Re: [Gambas-user] Output to Libre Office Writer ??

2013-03-31 Thread rocko
Ok I got this to unzip the .odt file, but where does it unzip to??? I looked in all my directories and I cannot find it. My Code: '/Gambas module file// // //Public nFile As File// //Public fName As String// // //Public Sub Main()// // // //fName = "/home/rocko/Documents/Pr

Re: [Gambas-user] Output to Libre Office Writer ??

2013-03-31 Thread rocko
Should there be a time after WAIT?? On 03/31/2013 05:21 PM, Benoît Minisini wrote: > Le 01/04/2013 01:32, rocko a écrit : >> I actually tried that after sending my response. >> lo and behold! XML file woo hoo! >> >> So I assume I can just do a search thru th XML file a

Re: [Gambas-user] Output to Libre Office Writer ??

2013-03-31 Thread rocko
Thanks, I'll give this a try. I'll post back if I have any problems. On 03/31/2013 05:21 PM, Benoît Minisini wrote: > Le 01/04/2013 01:32, rocko a écrit : >> I actually tried that after sending my response. >> lo and behold! XML file woo hoo! >> >> So I assu

Re: [Gambas-user] Output to Libre Office Writer ??

2013-03-31 Thread rocko
kind of search functions does gambas have?? regex I assume, any others?? On 03/31/2013 04:25 PM, Benoît Minisini wrote: > Le 01/04/2013 01:06, rocko a écrit : >> Unzip the .ods file??? >> Ok you lost me. > 'ods' is actually a zip file. If you unzip it, you will get a dir

Re: [Gambas-user] Output to Libre Office Writer ??

2013-03-31 Thread rocko
Unzip the .ods file??? Ok you lost me. On 03/31/2013 02:53 PM, Benoît Minisini wrote: > Le 31/03/2013 23:44, rocko a écrit : >> I don't know much about the capabilities of Gambas writing to Libre Office, >> as I don't think I ever heard of it being done before. >&

[Gambas-user] Output to Libre Office Writer ??

2013-03-31 Thread rocko
I don't know much about the capabilities of Gambas writing to Libre Office, as I don't think I ever heard of it being done before. I would like to read the names and addresses from an SQLite data base and put them into a Libre Office Writer template(.ods). Is this possible? Using Gambas 3 on L

Re: [Gambas-user] TableView Data from database

2012-09-30 Thread rocko
how the IF Then statement that is actually a requirement that I'm seeking, oops my bad. On 09/29/2012 03:38 AM, Bruce wrote: > On Fri, 2012-09-28 at 20:11 -0700, rocko wrote: >> Ok that makes a little more sense. >> But I have some questions. >> >> Do I have to use a Tab

Re: [Gambas-user] TableView Data from database

2012-09-30 Thread rocko
Oh yes, but can I do an 'IF Then" that that limits the fields returned from the database? If (daysLeft < 21) Then sResult!DaysLeft = DataView1.Columns1.Daysleft And so on.. On 09/29/2012 03:47 AM, Benoît Minisini wrote: > Le 29/09/2012 05:11, rocko a écrit :

Re: [Gambas-user] TableView Data from database

2012-09-28 Thread rocko
t being filled with any data. On 09/28/2012 07:39 PM, Bruce wrote: > On Fri, 2012-09-28 at 19:27 -0700, rocko wrote: >> Huh? >> I'm sorry Bruce I'm not following. >> I want the fields to update when the form opens. >> Just the ID, Location and Days Left fields

Re: [Gambas-user] TableView Data from database

2012-09-28 Thread rocko
Huh? I'm sorry Bruce I'm not following. I want the fields to update when the form opens. Just the ID, Location and Days Left fields. On 09/28/2012 07:17 PM, Bruce wrote: > On Fri, 2012-09-28 at 18:55 -0700, rocko wrote: >> I get a "Bad Row Index" error when I do th

Re: [Gambas-user] TableView Data from database

2012-09-28 Thread rocko
t!location = TableView1[TableView1.Row, 1].Text* > sResult.Update > > 2012/9/28 rocko > >> I'm using a Table view to view data from an SQLite database. >> I would use a dataview but I only need to display some database fields >> not all of them. >> >> This

[Gambas-user] TableView Data from database

2012-09-27 Thread rocko
I'm using a Table view to view data from an SQLite database. I would use a dataview but I only need to display some database fields not all of them. This is the code I have so far: Public Sub Form_Open() Dim sResult As Result Dim id As Integer TableView1.Columns.Count = 3 TableView1.Rows.Cou

[Gambas-user] Grid view or dataView

2012-09-12 Thread rocko
7. Is this possible with a dataView or should I be using a grid view? -- rocko -- Live Security Virtual Conference Exclusive live event will cover all the ways today's security and threat landscape has cha

Re: [Gambas-user] Changing text color in dataBrowser or Viewer

2012-09-05 Thread rocko
On Thu, 2012-09-06 at 01:08 +0200, Benoît Minisini wrote: > Le 05/09/2012 21:40, rocko a écrit : > > Can I change the text color in a data object like a browser or viewer? > > > > I think you are looking for the DataView / DataBrowser "Data" event, > that

[Gambas-user] Column and Row Properties in DataView?

2012-09-05 Thread rocko
Can I a DataViewer or Browser like a GridView? What I mean is this , can I use the .Column and .Row properties in a Grid View also In a DataView? -- rocko -- Live Security Virtual Conference Exclusive live event

Re: [Gambas-user] Frame Borders not displaying correctly

2012-09-05 Thread rocko
___ > Gambas-user mailing list > Gambas-user@lists.sourceforge.net > https://lists.sourceforge.net/lists/listinfo/gambas-user -- rocko -- Live Security Virtual Conference Exclusive live event w

Re: [Gambas-user] Scrollbars

2012-09-05 Thread rocko
ich is a container itself. You can > also have a ScrollBar which is shown unless you set the Visible property to > false. I have no problems maximizing the window: the ScrollBar is shown > properly. > > Csaba > > 2012/9/5 rocko > > > If I put a scrollbar on a fo

[Gambas-user] Changing text color in dataBrowser or Viewer

2012-09-05 Thread rocko
field I could do a FOR EACH NEXT Loop. Maybe: sResult = DB.Edit("databsename" id = &1, ID) For Each sResult If sResult!daysLeft < 22 Then DataBrowser1.Column.Foreground = Green Else

Re: [Gambas-user] Frame Borders not displaying correctly

2012-09-05 Thread rocko
> > Csaba > > 2012/8/29 rocko > > > Using Gambas 3.2.1 > > > > The frame container is not displaying correctly. > > The sides of the border are fading about midway and are > > completely absent at the bottom. > > See attached screenshot. > >

[Gambas-user] DataControl as Text Area

2012-09-05 Thread rocko
t to have a separate button just for the 'notes' field. rocko -- Live Security Virtual Conference Exclusive live event will cover all the ways today's security and threat landscape has changed and

Re: [Gambas-user] Display only some fields in data View

2012-09-05 Thread rocko
On Tue, 2012-09-04 at 11:46 -0700, rocko wrote: > I have a table with several fields but I only want certain fields > to be displayed in a dataviewer. > Not sure on how to do this. > So far i only have this, which isn't much. > > Dim sView As Result > Dim ID As Inte

[Gambas-user] Scrollbars

2012-09-05 Thread rocko
ainer?? -- rocko -- Live Security Virtual Conference Exclusive live event will cover all the ways today's security and threat landscape has changed and how IT managers can respond. Discussions will includ

[Gambas-user] Display only some fields in data View

2012-09-04 Thread rocko
sView!daysLeft < 22 'put the name and days left in the name and daysleft field of the dataview Next -- rocko -- Live Security Virtual Conference Exclusive live event will cover all the ways today's se

[Gambas-user] Send data back to SQLite3 Table??

2012-09-02 Thread rocko
is read only and I also tried rTable but that adds a new record, I need to update the daysLeft field only. -- rocko -- Live Security Virtual Conference Exclusive live event will cover all the ways today's security and

Re: [Gambas-user] Questions about the 'database' example

2012-08-30 Thread rocko
On Thu, 2012-08-30 at 18:37 -0700, John Spikowski wrote: > On Thu, 2012-08-30 at 18:15 -0700, rocko wrote: > > Been looking at the database example in Gambas 3.2.1. > > I believe it's the first one simply named 'Database'. > > I noticed on the Ftest.Form that

[Gambas-user] Questions about the 'database' example

2012-08-30 Thread rocko
er. I would love yo know how that was done. I looked thru the code but couldn't see anything that would give me a clue. Could some one point out the code that does this. I'm currently working on a similar project and that is just what I need. But I can't

Re: [Gambas-user] getting dataview to expand??

2012-08-30 Thread rocko
forge.net > https://lists.sourceforge.net/lists/listinfo/gambas-user -- rocko -- Live Security Virtual Conference Exclusive live event will cover all the ways today's security and threat landscape has changed and how

Re: [Gambas-user] getting dataview to expand??

2012-08-30 Thread rocko
igned > > button. You have tools, then it's just matter of imagination > > Le 29 août 2012 23:10, "rocko" a écrit : > > > > > > > Rocko, > > I have attached a project which I hope might help you. > > (Forgive me Richard!) It was Richar

Re: [Gambas-user] getting dataview to expand??

2012-08-29 Thread rocko
how IT managers can respond. Discussions > will include endpoint security, mobile security and the latest in malware > threats. http://www.accelacomm.com/jaw/sfrnl04242012/114/50122263/ > ___ Gambas-user mailing list > Gambas-user@lists.sourceforge.net >

Re: [Gambas-user] getting dataview to expand??

2012-08-29 Thread rocko
On Wed, 2012-08-29 at 19:37 +0930, Bruce wrote: > On Wed, 2012-08-29 at 11:57 +0200, Tobias Boege wrote: > > On Tue, 28 Aug 2012, rocko wrote: > > > Been trying to get a dataview to expand when the window is maximized. > > > I assume the dataview needs a container to d

[Gambas-user] getting dataview to expand??

2012-08-28 Thread rocko
Been trying to get a dataview to expand when the window is maximized. I assume the dataview needs a container to do that, but which container? -- rocko -- Live Security Virtual Conference Exclusive live event will

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

2012-08-16 Thread rocko
s" > > But when I double click either the datacomdo or the comboview to enter code > > gambas crashes. > > > > The DataView control needs to be enhanced so that we can configure each > column: displayed format, alignment... > Is there anyway i can 'enhance&#x

[Gambas-user] Trying to update table in SQLite

2012-08-14 Thread rocko
I'm trying to send data back to a table after retrieving it and doing some math to it. I tried doing a table update like>> table.Update But that doesn't seem to work. CODE: FNew.rTable = FMain.$hConn.Create("inventory") sResult = $hConn.Find("inventory", id = &1, ID) For Each sResult

[Gambas-user] Update DataView??

2012-08-10 Thread rocko
Is it possible to update a dataview in realtime? I Have an SQlite database that i acces with a dataSource and dataview. I have a form that enables users to add records to the database, But the dataview doesn't update untill i re-run the program. I would like to have the dataview update when it add

Re: [Gambas-user] Getting data from table

2012-08-10 Thread rocko
gt; Yes, in parenthesis > > > > > > Cordialement, > > > > Olivier Cruilles > > Mail: linu...@club-internet.fr > > > > Le 10 août 2012 à 18:15, rocko a écrit : > > > >> Should the table name be in parenthesis?? > &g

Re: [Gambas-user] Getting data from table

2012-08-10 Thread rocko
fr > > Le 10 août 2012 à 18:15, rocko a écrit : > > > Should the table name be in parenthesis?? > > I'm getting an error: > > "Unknown Identifier: inventory" > > > > sResult = $hConn.Find(inventory, "id = &1 ", ID) > >

Re: [Gambas-user] Getting data from table

2012-08-10 Thread rocko
, gb.Day) On Fri, 2012-08-10 at 16:27 +1000, Shane wrote: > On 10/08/12 15:13, rocko wrote: > > I've read the help files and seen a lot of examples on how > > to add data to a table but I can' find any examples on how > > to get data from a table. > > >

[Gambas-user] Getting data from table

2012-08-09 Thread rocko
I've read the help files and seen a lot of examples on how to add data to a table but I can' find any examples on how to get data from a table. I need to get total number of fields from a table. I've looked at: 'Property Read Count As Integer' in the Help file. Can i simply put this at the top o

[Gambas-user] Check if a form is opened/show

2012-08-09 Thread rocko
Is there a way to check if a form is opened?? If Fmain.Open = True Then do...something endif I tries .Show but got an error. -- Live Security Virtual Conference Exclusive live event will cover all the ways tod

[Gambas-user] Adding a date to a number

2012-08-09 Thread rocko
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 30 days in a value box to add to the date and then display that in another text box. But I'm not sure what the formula in Gambas is for adding dates. I want

Re: [Gambas-user] Second Form not reading Public variable from first form

2012-08-09 Thread rocko
r. On Thu, 2012-08-09 at 21:48 +0200, Olivier Cruilles wrote: > You repeat the same problem than yesterday. > > > > Cordialement, > > Olivier Cruilles > Mail: linu...@club-internet.fr > > Le 9 août 2012 à 21:37, rocko a écrit : > > FNew CODE:>

Re: [Gambas-user] Second Form not reading Public variable from first form

2012-08-09 Thread rocko
Sure can. FMain CODE:>>>>>>>>>>>>>>>>>>>>>>>>> ' Gambas class file Public $hConn As Connection Public Sub _new() End Public Sub Form_Open() $hConn = New Connection With $hConn .Host = "/home/rocko/DataBa

Re: [Gambas-user] Second Form not reading Public variable from first form

2012-08-09 Thread rocko
iable from another Form you need to rewrite the first > Form like that: > > > In the second Form use this: FMain.$hConn(But only if the variable is > declared as PUBLIC, not PRIVATE) > > > > Cordialement, > > Olivier Cruilles > Mail: linu...@club-i

[Gambas-user] Second Form not reading Public variable from first form

2012-08-09 Thread rocko
If I declare a Public variable is it available across all Forms and Modules?? I ask because I'm having difficulty with a $hConn variable I have a FMain form that connects to an sqlite database when the form is opened. Public Sub Form_Open() $hConn = New Connection With $hConn

Re: [Gambas-user] Syntax help for IF after a Try statement

2012-08-08 Thread rocko
The first one works. Haven't tried the second one. Wasn't aware of '$conn.Opened(). But it's good to know On Thu, 2012-08-09 at 12:51 +0930, Adam Ant wrote: > On Thu, Aug 9, 2012 at 12:35 PM, rocko wrote: > > Ok if I replace the 'Else If' with an 'E

Re: [Gambas-user] Syntax help for IF after a Try statement

2012-08-08 Thread rocko
Ok if I replace the 'Else If' with an 'Else' I get an error: Else without If. But there is an 'If' after the 'Try'. unless you can't put an 'Else' after an 'Try...If' On Thu, 2012-08-09 at 12:25 +0930, Adam Ant wrote: >

[Gambas-user] Syntax help for IF after a Try statement

2012-08-08 Thread rocko
Trying to get a message.info to display when a successful connection to a database is made. Tried using an 'Else If' after a 'Try $hConn.Open' statement but that gives an error. So tried a simple 'If' but I'm not sure how the syntax should be. CODE: Try $hConn.Open If Error Then Print "Database

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

2012-08-08 Thread rocko
eclare your variable at the beginning of this Form and not in a PUBLIC SUB > > When you use a Connection object to open a database, after initialized it and > opened it, the object Connection keep connected to the database, so you just > need to use it. > > Cordialement, > &

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

2012-08-08 Thread rocko
program, you close the database > > So to do that use it like that: > > > > PUBLIC $hConn AS Connection <= Error corrected > > btnConnect CODE: > > PUBLIC SUB btnConnect_Click() > > $hConn = NEW Connection &

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

2012-08-08 Thread rocko
d wrote: > Do not do dim hconn... > > Just say > Private $hconn as new connection > Le 8 août 2012 20:14, "rocko" a écrit : > > > Is it DB.Create/DB.Commit?? I was using $hConn.Create and so on. > > > > I'm getting 'Connection Not Opened" erro

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

2012-08-08 Thread rocko
Is it DB.Create/DB.Commit?? I was using $hConn.Create and so on. I'm getting 'Connection Not Opened" error when click the Add_new btn. btnConnect CODE: PRIVATE $hConn AS Connection PUBLIC SUB btnConnect_Click() DIM $hConn AS NEW Connection $hConn.Host = "/

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

2012-08-08 Thread rocko
Oh yes forgot to mention I have that code in a 'connect' button. PUBLIC SUB btnConnect_Click() DIM $hConn AS NEW Connection WITH $hConn .Type = "sqlite3" .Host = "/home/rocko/DataBases" .Name = "my_test.sqlite" END WITH TRY $hC

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

2012-08-08 Thread rocko
PRINT "Update failed" Message.Error(ERROR.Text) ENDIF ENDIF $hConn.Commit $hConn.Close On Wed, 2012-08-08 at 19:17 +0200, Fabien Bodard wrote: > 2012/8/8 rocko > > > Is there anyway to translate that?? > > > google ? >

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

2012-08-08 Thread rocko
Is there anyway to translate that?? On Wed, 2012-08-08 at 19:01 +0200, Fabien Bodard wrote: > it's in french but ... > > http://www.gambasforge.org/code-56-apprehender-sqlite-avec-gambas.html > -- > Live Security Virtual

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

2012-08-08 Thread rocko
Ok I've tried all the suggestions you all have made and none of them work. I don't get any error's printed, the table just wont update. Should 'rtable' be AS Result or AS String?? On Wed, 2012-08-08 at 15:33 +0930, Adam Ant wrote: > On Wed, Aug 8, 2012 at 2:59 PM, Fabien Bodard wrote: > > Le 8

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

2012-08-07 Thread rocko
$hConn.Close On Wed, 2012-08-08 at 12:18 +0930, Adam Ant wrote: > On Wed, Aug 8, 2012 at 4:48 AM, rocko wrote: > 8< > > > PUBLIC SUB btnAdd_Click() > > > > DIM $hConn AS NEW Connection > > DIM rTable AS Result > > > > $hConn.Open > >

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

2012-08-07 Thread rocko
t.asp > > The &1, &2 ... system used by gambas is to provide correct escaping and to > prevent sql injections. > > 2012/8/8 rocko > > > No, there are several. > > I justed wanted to test it with the first column to see if it works, > > which it doesn't.

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

2012-08-07 Thread rocko
Oh yes '&' not '$', that was a typo. In my code it's '&'. Still can't get this to work. Here is my full code: PUBLIC SUB btnConnect_Click() 'DIM sName AS String DIM $hConn AS NEW Connection WITH $hConn .Type = "sqlite&qu

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

2012-08-07 Thread rocko
en wrote: > Try > > $hConn.Begin > $hConn.Exec("INSERT INTO inventory VALUES(&1)", txtName.Text) > $hConn.Commit > > Do you only have one column in that table? > > 2012/8/8 rocko > > > Ok I tried this: > > $hConn.Beg

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

2012-08-07 Thread rocko
S(&1,&2,..&N)",var1,var2,...varN) > $hConn.Commit > > And I use Begin and Commit only for the large amount of insertions. > Csaba > > 2012/8/7 rocko > > > Having a bit of trouble with trying to get Ganbas to add a value to a > > field in a table.

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

2012-08-07 Thread rocko
1.9 as a basis. Here is my code for the 'connect' button: PUBLIC SUB btnConnect_Click() DIM $hConn AS NEW Connection TRY $hConn.CLOSE WITH $hConn .Type = "sqlite" .Host = "/home/rocko/DataBases" .Name = "plant_trax" END WITH TRY $h

Re: [Gambas-user] Set Tab Focus

2012-07-31 Thread rocko
ouldn't get the focus via TAB, you set the property > "NoTabFocus" to yes. > > > Am 30.07.2012 19:41, schrieb rocko: > > Is there a way to set the tab focus > > so it focuses on the buttons I want in the order I Want?? > >

[Gambas-user] Set Tab Focus

2012-07-30 Thread rocko
Is there a way to set the tab focus so it focuses on the buttons I want in the order I Want?? -- Live Security Virtual Conference Exclusive live event will cover all the ways today's security and threat landscape has cha

[Gambas-user] Gambas Package maker problems

2012-07-30 Thread rocko
Ubuntu 10.10 Gmabas3 compiled from svn. After finishing a small app I made I used Gambas to make an Ubuntu package. But when I try to install the package I get the following error for the Software center package manager: "Dependency is not satisfiable: gambas3-runtime (>= 3.0.90) " Do I need to i

Re: [Gambas-user] Rounding to 2 decimals

2012-07-27 Thread rocko
t; All topics: > http://www.gambasdoc.org/help?v3 > > Keywords: > http://www.gambasdoc.org/help/lang?v3 > > > Jussi > > > > > On 27 July 2012 21:21, rocko wrote: > > > AHA! That works, I forgot about using 'Float' > > > > I

Re: [Gambas-user] Rounding to 2 decimals

2012-07-27 Thread rocko
int precision > problem, > which arises from automatic conversion from float to single. > > You can fix it by changing; > Dim perAmnt As Single > > to > > Dim perAmnt As Float > > > Jussi > > > > > On 27 July 2012 21:05, rocko wrote: >

Re: [Gambas-user] Rounding to 2 decimals

2012-07-27 Thread rocko
use TextBoxes and do the conversion properly with Val(). > > Jussi > > > > > On 27 July 2012 21:05, rocko wrote: > > > On Fri, 2012-07-27 at 19:49 +0200, Tobias Boege wrote: > > > On Fri, 27 Jul 2012, rocko wrote: > > > > On Fri, 2012-07

Re: [Gambas-user] Rounding to 2 decimals

2012-07-27 Thread rocko
On Fri, 2012-07-27 at 19:49 +0200, Tobias Boege wrote: > On Fri, 27 Jul 2012, rocko wrote: > > On Fri, 2012-07-27 at 19:25 +0200, Tobias Boege wrote: > > > On Fri, 27 Jul 2012, rocko wrote: > > > > Using '.value instead of .text gives an error: > > >

Re: [Gambas-user] Rounding to 2 decimals

2012-07-27 Thread rocko
valuebox! not textbox > perAmnt = Round((prmAmnt / totAmnt * 100), 2) > ValueBox1.Value = perAmnt & "%" > > I not tested the code but it should work. > > 2012/7/27 rocko : > > Trying to get my result to just 2 decimal places using the 'Round" >

Re: [Gambas-user] Rounding to 2 decimals

2012-07-27 Thread rocko
On Fri, 2012-07-27 at 19:25 +0200, Tobias Boege wrote: > On Fri, 27 Jul 2012, rocko wrote: > > Using '.value instead of .text gives an error: > > "Unknown symbol "value" in class TextBox" > > > > On Fri, 2012-07-27 at 02:05 +0200, LeszekK

Re: [Gambas-user] Rounding to 2 decimals

2012-07-27 Thread rocko
perAmnt As Single > > prmAmnt = prmBox.value 'valuebox! not textbox > totAmnt = totBox.value 'valuebox! not textbox > perAmnt = Round((prmAmnt / totAmnt * 100), 2) > ValueBox1.Value = perAmnt & "%" > > I not tested the code but it should work. &g

[Gambas-user] Rounding to 2 decimals

2012-07-26 Thread rocko
Trying to get my result to just 2 decimal places using the 'Round" function but it' not working for me. This code gives a result of 0% ??? Code: Dim prmAmnt As Integer Dim totAmnt As Integer Dim perAmnt As Single prmAmnt = prmBox.Text totAmnt = totBox.Text perAmnt = Round((prmAmnt /

Re: [Gambas-user] System.User question

2012-07-26 Thread rocko
Ahh I see now, thanks. On Thu, 2012-07-26 at 17:35 -0300, Sebastian Kulesz wrote: > "Print System.User.Name" should do. To access a property of this > virtual class you can do: > Print System.User.[PROPERTY] > > > On Thu, Jul 26, 2012 at 5:30 PM, rocko wrote: >

Re: [Gambas-user] System.User question

2012-07-26 Thread rocko
It returns a virtual object not a string. I checked the docs on virtual class/objects but still I'm a bit clueless on how to interact/print them. On Thu, 2012-07-26 at 21:51 +0200, Tobias Boege wrote: > On Thu, 26 Jul 2012, rocko wrote: > > I'm trying to print the user by usin

[Gambas-user] System.User question

2012-07-26 Thread rocko
I'm trying to print the user by using 'System.User' but I am getting a 'mismatch' error. CODE: iusr = System.User Print iusr This also happens if I use a listbox to list the User. In a gui app. The System.User is a class right? so do have to convert it to string to print? Others like System.Ho

Re: [Gambas-user] Install problems

2012-07-25 Thread rocko
Forgot to mention I am getting one error when I run gambas3 from the command line: gb.qt4: warning: unable to load Qt translation: en_US.utf8 But gambas3 seems to run fine. On Wed, 2012-07-25 at 21:24 +0200, Jesus wrote: > El 25/07/12 02:04, rocko escribió: > > On Wed, 2012-07-25

Re: [Gambas-user] Install problems

2012-07-25 Thread rocko
0, Jesus wrote: > El 25/07/12 02:04, rocko escribió: > > On Wed, 2012-07-25 at 00:16 +0200, Jesus wrote: > >> El 24/07/12 22:26, rocko escribió: > >>> DOH! I forgot to run ./reconf -all, ./configure does work, BUT > >>> I'm now getting "Components

Re: [Gambas-user] Install problems

2012-07-25 Thread rocko
gt; Is this really problem? > > Jussi > > > > > On 25 July 2012 03:04, rocko wrote: > > > On Wed, 2012-07-25 at 00:16 +0200, Jesus wrote: > > > El 24/07/12 22:26, rocko escribió: > > > > DOH! I forgot to run ./recon

Re: [Gambas-user] Install problems

2012-07-24 Thread rocko
On Wed, 2012-07-25 at 00:16 +0200, Jesus wrote: > El 24/07/12 22:26, rocko escribió: > > DOH! I forgot to run ./reconf -all, ./configure does work, BUT > > I'm now getting "Components Disabled" warning after ./configure -C > > > > || > > ||

Re: [Gambas-user] Install problems

2012-07-24 Thread rocko
"sudo make clean" in trunk folder. > > Jussi > > > > > > > On 20 July 2012 20:16, rocko wrote: > > > No matter which version/revision I download I get gbx error's. > > > > gbx_extern.c:786: error: expected ‘=’, ‘,’, ‘;’, ‘asm’ or &

Re: [Gambas-user] Install problems

2012-07-24 Thread rocko
k folder? > That way you can update sources correctly in easy way. > Before trying to compile again, run "sudo make clean" in trunk folder. > > Jussi > > > > > > > On 20 July 2012 20:16, rocko wrote: > > > No matter which version/

Re: [Gambas-user] Install problems

2012-07-20 Thread rocko
No matter which version/revision I download I get gbx error's. gbx_extern.c:786: error: expected ‘=’, ‘,’, ‘;’, ‘asm’ or ‘__attribute__’ before ‘EXTERN_get_function_info’ make[4]: *** [gbx3-gbx_extern.o] Error 1 make[4]: Leaving directory `/home/rocko/Gambas/main/gbx' make[3]: *** [all

Re: [Gambas-user] Install problems

2012-07-20 Thread rocko
Ok I downloaded the stable version and got the same error's. I'll try downloading the latest version and give it a go. On Thu, 2012-07-19 at 21:27 +0200, Benoît Minisini wrote: > Le 19/07/2012 21:21, Randall Morgan a écrit : > > Ok, sorry I didn't see your last message. That looks to me like an >

Re: [Gambas-user] Install problems

2012-07-19 Thread rocko
No, i got reconf and configure to work, but make gave me errors about gb3x Here they are: gbx3-gbx_api.o:(.data+0x350): undefined reference to `EXTERN_get_function_info' collect2: ld returned 1 exit status make[4]: *** [gbx3] Error 1 make[4]: Leaving directory `/home/rocko/Gambas/trunk/mai

  1   2   >