Re: [Gambas-user] Snippets bug

2014-11-12 Thread B Bruen
On Wed, 12 Nov 2014 22:40:38 +0100
Jørn Erik Mørne  wrote:

> Hi!
> 
> I have these two snippets:
> 
> prb
> Private $b${1:VariableName} as Boolean
> prc
> Private $c${1:VariableName} as Collection
> 
> The first, prb, works as expected. But with the prb the initial c gets 
> selected in addition to VariableName.
> 
> -- 
> Kind regards
> 

Interesting but weird. The expansion macro works fine if the trigger string is 
something else, e.g.
prf
Private $c${1:VariableName} as Collection

then on the other hand if it is "prc" then I get a different expansion result 
from you. (It indents the line and leaves the cursor just before the P in 
Private). What is even stranger is that if I change the expansion string to 
something else for "prc" then I get a different result, for example
prc
Public $c${1:VariableName} as Collection
then in using the tab key everything from the "V" in VariableName is selected

But at the end-of-the-day, I'd suggest you use different trigger strings, I 
have tried 
vc
Private $c${1:VariableName} as Collection
vb
Private $b${1:VariableName} as Boolean
vi
Private $i${1:VariableName} as Integer
vx
Private $h${1:VariableName} as Object
vv
Private $v${1:VariableName} as Variant

and they all behave as you would expect.

hth
Bruce

-- 
B Bruen 

--
Comprehensive Server Monitoring with Site24x7.
Monitor 10 servers for $9/Month.
Get alerted through email, SMS, voice calls or mobile push notifications.
Take corrective actions from your mobile device.
http://pubads.g.doubleclick.net/gampad/clk?id=154624111&iu=/4140/ostg.clktrk
___
Gambas-user mailing list
Gambas-user@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/gambas-user


Re: [Gambas-user] New features on the wiki

2014-11-12 Thread Tobias Boege
On Wed, 12 Nov 2014, Beno?t Minisini wrote:
> Le 12/11/2014 13:39, Tobias Boege a ?crit :
> > On Sun, 09 Nov 2014, Beno??t Minisini wrote:
> >> Hi,
> >>
> >> I added "automatic documentation from source files" in the wiki. If a
> >> class, a property, an event, a constant or a method has an help comment
> >> in its source code, it will be used to make a default documentation page
> >> automatically.
> >>
> >
> > So how does it work? Is the documentation content taken from the .info
> > files?
> 
> Yes.
> 

Do you think we can insert my scripts into the process of the wiki reading
the .info files? They run over the whole source tree so that needs to be
present. If so, I can upload them (to the repository?) this weekend I think.

-- 
"There's an old saying: Don't change anything... ever!" -- Mr. Monk

--
Comprehensive Server Monitoring with Site24x7.
Monitor 10 servers for $9/Month.
Get alerted through email, SMS, voice calls or mobile push notifications.
Take corrective actions from your mobile device.
http://pubads.g.doubleclick.net/gampad/clk?id=154624111&iu=/4140/ostg.clktrk
___
Gambas-user mailing list
Gambas-user@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/gambas-user


[Gambas-user] Possible sqlite3 component error

2014-11-12 Thread B Bruen
The following query is a "standard" CTE based query to return the contents of a 
hierarchical table (i.e. columns are id, parentid, data):
WITH RECURSIVE tmp AS ( 
  SELECT *, 0 AS depth 
  FROM pages p 
  WHERE p.parent = 0 
 UNION ALL 
  SELECT p.*, tmp.depth + 1 
  FROM pages p 
JOIN tmp ON (p.parent=tmp.id)
) 
SELECT id, title, parent, category, indexed, htmlsrc, depth 
FROM tmp 
ORDER BY depth;

I use the following method in Gambas:
Private Sub LoadTOC() '' Build the 
index tree

  Dim rslt As Result
  Dim pnode As String
  Dim sQry As String = "WITH RECURSIVE tmp AS ( SELECT *, 0 AS depth FROM pages 
p WHERE p.parent = 0 UNION ALL SELECT p.*, tmp.depth + 1 FROM pages p JOIN tmp 
ON (p.parent=tmp.id)) SELECT id, title, parent, category, indexed, htmlsrc, 
depth FROM tmp ORDER BY depth"

  tvwIndex.Clear

db.Debug = True
  rslt = $conn.Exec(sQry) 'Find("pages")
db.Debug = False

  For Each rslt
pnode = rslt!parent
If Not pnode Then Continue
If Not rslt!indexed Then Continue
tvwIndex.Add(rslt!id, rslt!title,, IIf(pnode = 0, "", pnode))
  Next
  
  tvwIndex["1"].Expanded = True
  tvwIndex["1"].Text = "Index"
  tvwIndex["1"].Picture = Picture["icon:/32/book"]

Catch
Error Subst("&1\nERR: &2 (&3)\n&4\n&1\n", String$(40, "-"), Error.Text, 
Error.Code, Error.Backtrace.Join("\n"))
Error db.Error
Stop

End

When this is executed it fails at the rslt=$conn.Exec line with 
ERR: Query failed: SQL error or missing database (-1)
and db.Error is "1"
the $conn connection is valid and is open.

Similarly when I try to execute that query in the connection browser in the IDE 
I get the same error.

However, when I run the same query in the sqlite3 cli tool it works faultlessly.

The output produced by the db.debug is:
sqlite3: 0x8551560: WITH RECURSIVE tmp AS ( SELECT *, 0 AS depth FROM pages p 
WHERE p.parent = 0 UNION ALL SELECT p.*, tmp.depth + 1 FROM pages p JOIN tmp ON 
(p.parent=tmp.id)) SELECT id, title, parent, category, indexed, htmlsrc, depth 
FROM tmp ORDER BY d
epth

apart from the line break in the ORDER BY clause (which I dont think is the 
problem) I cannot see any corruption of the query string.

I am not sure but have a suspicion that this has arisen after the recent 
changes for db collations etc.

regards
Bruce
-- 
B Bruen 

--
Comprehensive Server Monitoring with Site24x7.
Monitor 10 servers for $9/Month.
Get alerted through email, SMS, voice calls or mobile push notifications.
Take corrective actions from your mobile device.
http://pubads.g.doubleclick.net/gampad/clk?id=154624111&iu=/4140/ostg.clktrk
___
Gambas-user mailing list
Gambas-user@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/gambas-user


[Gambas-user] Snippets bug

2014-11-12 Thread Jørn Erik Mørne
Hi!

I have these two snippets:

prb
Private $b${1:VariableName} as Boolean
prc
Private $c${1:VariableName} as Collection

The first, prb, works as expected. But with the prb the initial c gets 
selected in addition to VariableName.

-- 
Kind regards

--
Comprehensive Server Monitoring with Site24x7.
Monitor 10 servers for $9/Month.
Get alerted through email, SMS, voice calls or mobile push notifications.
Take corrective actions from your mobile device.
http://pubads.g.doubleclick.net/gampad/clk?id=154624111&iu=/4140/ostg.clktrk
___
Gambas-user mailing list
Gambas-user@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/gambas-user


Re: [Gambas-user] Release of Gambas 3.6.2

2014-11-12 Thread Jorge Carrión
Good work. This is a very expected Version :-) :-)

Thanks Benoît

Regards.

2014-11-12 21:04 GMT+01:00 Benoît Minisini :

> Le 12/11/2014 20:49, Jesus a écrit :
> > El 12/11/14 a las 17:39, Benoît Minisini escribió:
> >> Hi,
> >>
> >> I have made the release of Gambas 3.6.2 official.
> >>
> >> There is still a problem in the way the offline help is displayed: fixes
> >> to the wiki stylesheet must be duplicated by hand in the IDE at the
> moment.
> >>
> >> If I find a solution for that, it will be backported to a next 3.6.3
> >> version.
> >>
> >> Regards,
> >>
> >
> > The download link (big button) in the main page still points to gambas
> > 3.6.1
> >
> > Good job, anyway. No issues here.
> >
> > Regards
> >
>
> I forgot to update the web site. Fixed!
>
> Regards,
>
> --
> Benoît Minisini
>
>
> --
> Comprehensive Server Monitoring with Site24x7.
> Monitor 10 servers for $9/Month.
> Get alerted through email, SMS, voice calls or mobile push notifications.
> Take corrective actions from your mobile device.
>
> http://pubads.g.doubleclick.net/gampad/clk?id=154624111&iu=/4140/ostg.clktrk
> ___
> Gambas-user mailing list
> Gambas-user@lists.sourceforge.net
> https://lists.sourceforge.net/lists/listinfo/gambas-user
>
--
Comprehensive Server Monitoring with Site24x7.
Monitor 10 servers for $9/Month.
Get alerted through email, SMS, voice calls or mobile push notifications.
Take corrective actions from your mobile device.
http://pubads.g.doubleclick.net/gampad/clk?id=154624111&iu=/4140/ostg.clktrk
___
Gambas-user mailing list
Gambas-user@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/gambas-user


Re: [Gambas-user] Release of Gambas 3.6.2

2014-11-12 Thread Benoît Minisini
Le 12/11/2014 20:49, Jesus a écrit :
> El 12/11/14 a las 17:39, Benoît Minisini escribió:
>> Hi,
>>
>> I have made the release of Gambas 3.6.2 official.
>>
>> There is still a problem in the way the offline help is displayed: fixes
>> to the wiki stylesheet must be duplicated by hand in the IDE at the moment.
>>
>> If I find a solution for that, it will be backported to a next 3.6.3
>> version.
>>
>> Regards,
>>
>
> The download link (big button) in the main page still points to gambas
> 3.6.1
>
> Good job, anyway. No issues here.
>
> Regards
>

I forgot to update the web site. Fixed!

Regards,

-- 
Benoît Minisini

--
Comprehensive Server Monitoring with Site24x7.
Monitor 10 servers for $9/Month.
Get alerted through email, SMS, voice calls or mobile push notifications.
Take corrective actions from your mobile device.
http://pubads.g.doubleclick.net/gampad/clk?id=154624111&iu=/4140/ostg.clktrk
___
Gambas-user mailing list
Gambas-user@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/gambas-user


Re: [Gambas-user] Release of Gambas 3.6.2

2014-11-12 Thread Jesus
El 12/11/14 a las 17:39, Benoît Minisini escribió:
> Hi,
>
> I have made the release of Gambas 3.6.2 official.
>
> There is still a problem in the way the offline help is displayed: fixes
> to the wiki stylesheet must be duplicated by hand in the IDE at the moment.
>
> If I find a solution for that, it will be backported to a next 3.6.3
> version.
>
> Regards,
>

The download link (big button) in the main page still points to gambas 
3.6.1

Good job, anyway. No issues here.

Regards

-- 
Jesus Guardon

--
Comprehensive Server Monitoring with Site24x7.
Monitor 10 servers for $9/Month.
Get alerted through email, SMS, voice calls or mobile push notifications.
Take corrective actions from your mobile device.
http://pubads.g.doubleclick.net/gampad/clk?id=154624111&iu=/4140/ostg.clktrk
___
Gambas-user mailing list
Gambas-user@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/gambas-user


[Gambas-user] Release of Gambas 3.6.2

2014-11-12 Thread Benoît Minisini
Hi,

I have made the release of Gambas 3.6.2 official.

There is still a problem in the way the offline help is displayed: fixes 
to the wiki stylesheet must be duplicated by hand in the IDE at the moment.

If I find a solution for that, it will be backported to a next 3.6.3 
version.

Regards,

-- 
Benoît Minisini

--
Comprehensive Server Monitoring with Site24x7.
Monitor 10 servers for $9/Month.
Get alerted through email, SMS, voice calls or mobile push notifications.
Take corrective actions from your mobile device.
http://pubads.g.doubleclick.net/gampad/clk?id=154624111&iu=/4140/ostg.clktrk
___
Gambas-user mailing list
Gambas-user@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/gambas-user


Re: [Gambas-user] I think I might have a corrupt project

2014-11-12 Thread Charlie Reinl
Am Mittwoch, den 12.11.2014, 14:48 +0100 schrieb Tobias Boege:
> On Wed, 12 Nov 2014, Martin McGlensey wrote:
> > Tobi,
> > 
> >  
> > 
> > The project was created by user marty not root. The permissions on the
> > project directory and the backup directory are the same. Owner = marty read
> > and write, group = marty read and write and other read only. I've copied all
> > of the files into the new database using sources -> new -> form -> existing
> > .. I'm still getting unknown symbol errors. Newest is filechooser1 is
> > unknown. Is there a component missing?
> > 
> >  
> > 
> > I got the backup to run by using the save as suggested by Charlie. I know
> > the last form I was working on before the problems occurred. Should I delete
> > this form in the original project and import the one in the working backup?
> > I'm thinking that the problems are related to this form. I think I'll copy
> > or archive the working BU to some other location on the drive before I do
> > anything further. What do you think?
> > 
> 
> More backups are always good. Apart from that I'm out of ideas, sorry.
> 

Salut Martin,

did you give /Tools/Update all forms a chance?
If *.form files corrupted they throw some times strange errors. They
appear mostly in top of the project explorer.

I would only work with the newly per Save as created project .

And I would take a diff-tool (Meld p.ex.) and look for the diff of the
meant corrupted .form and .class. or the whole project. To find out what
was happened (but not to long, dont waste time). 
And then wipe the old corrupted project from your disk, or pack it with
'corrupted' in the name, and then wipe the corrupted project from your
disk .
-- 
Amicalement
Charlie


--
Comprehensive Server Monitoring with Site24x7.
Monitor 10 servers for $9/Month.
Get alerted through email, SMS, voice calls or mobile push notifications.
Take corrective actions from your mobile device.
http://pubads.g.doubleclick.net/gampad/clk?id=154624111&iu=/4140/ostg.clktrk
___
Gambas-user mailing list
Gambas-user@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/gambas-user


Re: [Gambas-user] I think I might have a corrupt project

2014-11-12 Thread Tobias Boege
On Wed, 12 Nov 2014, Martin McGlensey wrote:
> Tobi,
> 
>  
> 
> The project was created by user marty not root. The permissions on the
> project directory and the backup directory are the same. Owner = marty read
> and write, group = marty read and write and other read only. I've copied all
> of the files into the new database using sources -> new -> form -> existing
> .. I'm still getting unknown symbol errors. Newest is filechooser1 is
> unknown. Is there a component missing?
> 
>  
> 
> I got the backup to run by using the save as suggested by Charlie. I know
> the last form I was working on before the problems occurred. Should I delete
> this form in the original project and import the one in the working backup?
> I'm thinking that the problems are related to this form. I think I'll copy
> or archive the working BU to some other location on the drive before I do
> anything further. What do you think?
> 

More backups are always good. Apart from that I'm out of ideas, sorry.

-- 
"There's an old saying: Don't change anything... ever!" -- Mr. Monk

--
Comprehensive Server Monitoring with Site24x7.
Monitor 10 servers for $9/Month.
Get alerted through email, SMS, voice calls or mobile push notifications.
Take corrective actions from your mobile device.
http://pubads.g.doubleclick.net/gampad/clk?id=154624111&iu=/4140/ostg.clktrk
___
Gambas-user mailing list
Gambas-user@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/gambas-user


Re: [Gambas-user] I think I might have a corrupt project

2014-11-12 Thread Martin McGlensey
Tobi,

 

The project was created by user marty not root. The permissions on the
project directory and the backup directory are the same. Owner = marty read
and write, group = marty read and write and other read only. I've copied all
of the files into the new database using sources -> new -> form -> existing
.. I'm still getting unknown symbol errors. Newest is filechooser1 is
unknown. Is there a component missing?

 

I got the backup to run by using the save as suggested by Charlie. I know
the last form I was working on before the problems occurred. Should I delete
this form in the original project and import the one in the working backup?
I'm thinking that the problems are related to this form. I think I'll copy
or archive the working BU to some other location on the drive before I do
anything further. What do you think?

 

Thanks,

Marty

 

--
Comprehensive Server Monitoring with Site24x7.
Monitor 10 servers for $9/Month.
Get alerted through email, SMS, voice calls or mobile push notifications.
Take corrective actions from your mobile device.
http://pubads.g.doubleclick.net/gampad/clk?id=154624111&iu=/4140/ostg.clktrk
___
Gambas-user mailing list
Gambas-user@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/gambas-user


Re: [Gambas-user] New features on the wiki

2014-11-12 Thread Benoît Minisini
Le 12/11/2014 13:39, Tobias Boege a écrit :
> On Sun, 09 Nov 2014, Beno??t Minisini wrote:
>> Hi,
>>
>> I added "automatic documentation from source files" in the wiki. If a
>> class, a property, an event, a constant or a method has an help comment
>> in its source code, it will be used to make a default documentation page
>> automatically.
>>
>
> So how does it work? Is the documentation content taken from the .info
> files?

Yes.

-- 
Benoît Minisini

--
Comprehensive Server Monitoring with Site24x7.
Monitor 10 servers for $9/Month.
Get alerted through email, SMS, voice calls or mobile push notifications.
Take corrective actions from your mobile device.
http://pubads.g.doubleclick.net/gampad/clk?id=154624111&iu=/4140/ostg.clktrk
___
Gambas-user mailing list
Gambas-user@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/gambas-user


Re: [Gambas-user] New features on the wiki

2014-11-12 Thread Tobias Boege
On Sun, 09 Nov 2014, Beno??t Minisini wrote:
> Hi,
> 
> I added "automatic documentation from source files" in the wiki. If a 
> class, a property, an event, a constant or a method has an help comment 
> in its source code, it will be used to make a default documentation page 
> automatically.
> 

So how does it work? Is the documentation content taken from the .info
files?

I still have some scripts from a while ago which can extract specially
formatted comments from C/C++ source code and merge them to the appropriate
places in a component's .info file. If the wiki reads .info files, we can
chase those scripts over all the C/C++ components before it does so and get
(the possibility of) in-source documentation for _all_ components.

Regards,
Tobi

-- 
"There's an old saying: Don't change anything... ever!" -- Mr. Monk

--
Comprehensive Server Monitoring with Site24x7.
Monitor 10 servers for $9/Month.
Get alerted through email, SMS, voice calls or mobile push notifications.
Take corrective actions from your mobile device.
http://pubads.g.doubleclick.net/gampad/clk?id=154624111&iu=/4140/ostg.clktrk
___
Gambas-user mailing list
Gambas-user@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/gambas-user


Re: [Gambas-user] Pre-release of Gambas 3.6.2

2014-11-12 Thread Jesus
El 12/11/14 a las 01:39, Benoît Minisini escribió:
> Le 12/11/2014 01:28, Benoît Minisini a écrit :
>> Le 12/11/2014 01:13, Jesus a écrit :
>>> El 11/11/14 a las 17:58, Benoît Minisini escribió:
 Hi,

 I have uploaded a pre-release source package of Gambas 3.6.2 on
 sourceforge at:

 http://sourceforge.net/projects/gambas/files/gambas3/gambas3-3.6.2.tar.bz2/download


 Please check it and report any problem before I make it official.

 I will write the changelog with the backported bug fixes soon.

 Regards,

>>>
>>> Hi
>>>
>>> Hope it's not too late... I've updated Spanish language in 3.6 branch,
>>> r6644. Please, Benoît, could you merge it into 3.6.2 finally?
>>>
>>> Thanks in advance
>>>
>>
>> Not too late, as the release is not official.
>>
>
> I have uploaded a new archive of gambas 3.6.2 with your translation. Now
> I wait one or two days for people to confirm that they have no problem
> with compiling and installing it, and I make the release official.
>
> Regards,
>

Than you very much, Benoît. I will test it in a VM today.

Regards

-- 
Jesus Guardon

--
Comprehensive Server Monitoring with Site24x7.
Monitor 10 servers for $9/Month.
Get alerted through email, SMS, voice calls or mobile push notifications.
Take corrective actions from your mobile device.
http://pubads.g.doubleclick.net/gampad/clk?id=154624111&iu=/4140/ostg.clktrk
___
Gambas-user mailing list
Gambas-user@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/gambas-user