SELECT @s:=@s+1 serial_number,student_id,student_name,student_avg
FROM students, (SELECT @s:= 0) AS s
4 Ana Karerina Leon Tolstoi
5 Guerra y Paz Leon Tolstoi
6 El Conde de Montecristo Alejandro Dumas
8 Los Miserables Victor Hugo
sql = 'SELECT CAST(@s:=@s+1 AS UNSIGNED) AS new_id, title, author FROM book, (SELECT @s:= 0) AS s'
(1, 'Ana Karerina', 'Leon Tolstoi')
(2, 'Guerra y Paz', 'Leon Tolstoi')
(3, 'El Conde de Montecristo', 'Alejandro Dumas')
(4, 'Los Miserables', 'Victor Hugo')
sBaseDatos = "mysql"
'Establecemos la consulta SQL
sSQL = "SELECT CAST(@s:=@s+1 AS UNSIGNED) AS new_id, title, author FROM book, (SELECT @s:= 0) AS s"
'Creamos el servicio para acceder y manipular las bases de datos
oDBC = createUnoService("com.sun.star.sdb.DatabaseContext")
'Nos aseguramos de que exista la base de datos
If oDBC.hasByName( sBaseDatos ) Then
'Si existe, accedemos por el nombre
oBD = oDBC.getByName( sBaseDatos )
'Creamos una conexion a la base de datos
oConexion = oBD.getConnection("","")
'Creamos un objeto para las instrucciones SQL
oDeclaracion = oConexion.createStatement()
'Ejecutamos la consulta
oResultado = oDeclaracion.executeQuery( sSQL)
'Si hay resultados
If Not IsNull( oResultado ) Then
Do While oResultado.next
'Mostramos el contenido del campo
msg = CStr(oResultado.getLong(1)) + " " + oResultado.getString(2) + " " + oResultado.getString(3)
MsgBox msg
Loop
End If
End If
sSQL="SELECT CAST(@s:=@s+1 AS UNSIGNED) AS Reg ,ID,Compania " &_
"FROM tblcompania ,(SELECT @s:=0) AS s "
con=util.conODBC("baseMysql","admin","admin")
data=util.query(con,sSQL,True)
doc=util.newDoc("")
address = createUnoStruct("org.universolibre.EasyDev.CellRangeAddress")
address.Doc = doc
address.Current = True
address.Sheet= "Full1"
cell = util.getCell(address)
util.setData(cell, data)
Error de temps d'execució del BASIC.
S'ha produït una excepció
Type: com.sun.star.uno.RuntimeException
Message: <class 'KeyError'>: ('integer unsigned',), traceback follows
/home/ramon/.config/libreoffice/4/user/uno_packages/cache/uno_packages/lu32802q14n0.tmp_/EasyDev_v2.7.2.oxt/pythonpath/easydev/comun.py:203 in function <genexpr>() [cols_type = ('',) + tuple(DATA_TYPES[info.getColumnTypeName(c).lower()] for c in cols)]
/home/ramon/.config/libreoffice/4/user/uno_packages/cache/uno_packages/lu32802q14n0.tmp_/EasyDev_v2.7.2.oxt/pythonpath/easydev/comun.py:203 in function parse_data_type() [cols_type = ('',) + tuple(DATA_TYPES[info.getColumnTypeName(c).lower()] for c in cols)]
/home/ramon/.config/libreoffice/4/user/uno_packages/cache/uno_packages/lu32802q14n0.tmp_/EasyDev_v2.7.2.oxt/pythonpath/easydev/lodb.py:55 in function query() [return comun.parse_data_type(resulset)]
.
Usuarios navegando por este Foro: Google [Bot] y 3 invitados