[Gambas-user] ODBC how to linuxers debian

2017-06-05 Thread PICCORO McKAY Lenz 
This documentation has two parts, and overall ODBC documentation and a
specific Devuan ODBC documentation. The firs part are provided due most
administrators and developers must understand the ODBC infrastructure to
property debug problems. This documentation starts on the "friendofdevuan"
wiki due ODBC information was very poor inclusivelly in oficial Debian wiki

http://qgqlochekone.blogspot.com/2017/06/odbc-devuan-and-debian-complete-how-to.html#

The post describe the most basic non referenced settings and some reasons
why.. for debian users and debian derived distros there are the second part
of the documentation with proper how to for each of the packages for odbc
module drivers>

http://qgqlochekone.blogspot.com/2017/06/odbc-devuan-and-debian-complete-how-to.html#about_devuan_odbc_packages

At the Gambas wiki i improve an ODBC gambas example most better with steps
rather than only paste a simple code>

http://gambaswiki.org/wiki/howto/odbcdatabase

For now, currently only the spanish page are ready, and the english are a
work in progress.. the other odbc driver present some problems and i report
the respective gambas bug today, the ODBC MySQL driver module its the only
that works perfectly, the other ODBC module drivers present some problems


Lenz McKAY Gerardo (PICCORO)
http://qgqlochekone.blogspot.com
--
Check out the vibrant tech community on one of the world's most
engaging tech sites, Slashdot.org! http://sdm.link/slashdot
___
Gambas-user mailing list
Gambas-user@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/gambas-user

[Gambas-user] [Gambas Bug Tracker] Bug #1113: ODBC driver problem: driver connects but does not exec query

2017-06-05 Thread bugtracker 
http://gambaswiki.org/bugtracker/edit?object=BUG.1113=L21haW4-

PICCORO LENZ MCKAY reported a new bug.

Summary
---

ODBC driver problem: driver connects but does not exec query

Type : Bug
Priority : High
Gambas version   : 3.9.90 (TRUNK)
Product  : ODBC driver


Description
---

The following simple code does not execute, when used a driver different rather 
than Mysql odbc driver module for ODBC type connections:


   Public Sub Main()
Dim $con As New Connection
Try $con.Close()  '
$con.Type = "odbc"'
$con.Host = "testdb"'
$con.Login = ""'
$con.Password = "" '
$con.Open()   '
Try $con.Exec("CREATE TABLE IF NOT EXISTS tabla1 ( columna1 
VARCHAR(20), columna2 VARCHAR(20))")
Print Error.Text
   End

If the ODBC connection tipe are using a ODBC mysql driver the code will work, 
but with any other type will fails always, i tested in each gambas version 
since 3.5, tested with 3.4 and 3.8 and 3.9 and trunk

the connection string are tested, the ODBC definition are globally at the 
/etc/odbc.ini and its:

[testdb]
Description=Mysql3
Driver=SQLite3
Database=/home/systemas/TEST
# optional lock timeout in milliseconds
Timeout=2000


the connection was tested and working sucessfully with UnixODBC isql command 
line tool:

isql testdb
+---+
| Connected!|
|   |
| sql-statement |
| help [tablename]  |
| quit  |
|   |
+---+
SQL> CREATE TABLE IF NOT EXISTS tabla1 ( columna1 TEXT, columna2 TEXT)
SQLRowCount returns 0
SQL> select * from tabla1
+-+-+
| columna1  


  | columna2



|
+-+-+
+-+-+
SQLRowCount returns 0
SQL> DROP TABLE tabla1
SQLRowCount returns 0
SQL> 

the Gambas code due driver implementation does not return why get and error, in 
second comment i attached image for gambas ide variables in execution


System information
--

[System]
Gambas=3.9.1
OperatingSystem=Linux
Kernel=2.6.38-bpo.2-686
Architecture=x86
Distribution= 6.1
Desktop=
Theme=Gtk
Language=es_VE.UTF-8
Memory=2958M

[Libraries]
Cairo=libcairo.so.2.11000.2
Curl=libcurl.so.4.2.0
DBus=libdbus-1.so.3.4.0
GStreamer=libgstreamer-0.10.so.0.27.0
GTK+2=libgtk-x11-2.0.so.0.2000.1
Poppler=libpoppler.so.5.0.0
QT4=libQtCore.so.4.7.4

[Gambas-user] Class HtmlDocument

2017-06-05 Thread Hans Lehmann 

Hello,

why creates the following source text:

Public Sub btnCreateHTMLDocument_Click()
  Dim hHtmlDocument As HtmlDocument

  hHtmlDocument = New HtmlDocument

*hHtmlDocument.Html5 = False**
*
  Print hHtmlDocument.ToString(True)
  hHtmlDocument.Save(Application.Path &/ "test.html", True)

End

this HTML5 document? I would have expected: strict HTML 1.0!



 
  
  
  
 
 
 


Hans
--
Check out the vibrant tech community on one of the world's most
engaging tech sites, Slashdot.org! http://sdm.link/slashdot
___
Gambas-user mailing list
Gambas-user@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/gambas-user