Problem with losts records
[1/5] from: sqlab:gmx at: 6-Feb-2001 8:54
> > Hi,
> >
<<quoted lines omitted: 17>>
> >
> >
Hi
I feared I would be facing a restless night after your message, until I
could assure myself, that I never used RTs ODBC interface in serious
applications.
Fortunately I used always my own ODBC interface based on dynamic libraries
without this and a few other bugs.
I consider the bug you discovered so serious, that I am ready to doubt RT
testing capabilities and /commands ability to be used in important
applications.(
regards
AR
--
Sent through GMX FreeMail - http://www.gmx.net
[2/5] from: g:gekko:arrakis:es at: 5-Feb-2001 12:33
Hi,
Rebol/Command drives me Crazy!.
The next code doesn't run (OK)
- - - Begin Code - - -
REBOL []
MySQL-Conn: open odbc://Radius
MySQL-Port: first MySQL-Conn
MySQL-CadenaSQL: "select * from limpia20010131"
insert MySQL-Port [MySQL-CadenaSQL]
while [Registro-LOG: pick MySQL-Puerto 1]
[
log-cadena: to-String Rejoin [
registro-log/1 "^(tab)"
registro-log/2 "^(tab)"
registro-log/3 "^(tab)"
registro-log/4 "^(tab)"
registro-log/5 "^(tab)"
registro-log/6 "^(line)" ]
write/append %salida_comprobacion.txt log-cadena
recycle
]
close MySQL-Conexion
- - - End Code - - -
Radius is the name of the System DSN to a MySQL (Under Linux)
I Don't obtain all the records of the table Limpia20010131, and I can't
find the cause, I found this problem so later ... I Lost a lot of info (and
Work) ... :'-(
Note: I use Recycle Command because (if i don't use it) rebol crashes with
an "Invalid Data Type During Recycle ...*** Press Enter to Quit." Message.
I Use Rebol/command 1.0.0.3.1
Any ideas . . .
Un Saludo,
Antonio Cortés <[antonio--cortes--arrakis--es]>
El ordenador es la evolución lógica del hombre: Inteligencia sin moral
:
John Osborne.
---
A nullo videbatur, ipse autem omnia videbat
---
Clave PGP Pública en: http://thor.prohosting.com/~nemesys/Antonio.Cortes.asc
[3/5] from: sqlab:gmx at: 5-Feb-2001 14:47
Ola Gordon
Do you know which records are missing,
maybe every 11th or nnth record or the last nn records ?
I used recycle just every 1000 records.
AR
> Hi,
> Rebol/Command drives me Crazy!.
<<quoted lines omitted: 19>>
> [rebol-request--rebol--com] with "unsubscribe" in the
> subject, without the quotes.
--
Sent through GMX FreeMail - http://www.gmx.net
[4/5] from: g::gekko::arrakis::es at: 5-Feb-2001 15:37
Hi,
The Table limpia20010131 got about 2 milliom of records, I missed 1 milliom
... every 2nd ...
if i use Recycle every 1000 records ... I must lost all the 1000th
Records (about 2000 records) ! (Less records that now)
At 14.47 05/02/01 +0100, you wrote:
[5/5] from: sqlab:gmx at: 5-Feb-2001 16:27
Hi
I never used pick, but always copy/part n.
I will check if I too loose one record after each recycle.
I hope, it's not true.
AR
> Hi,
>
> The Table limpia20010131 got about 2 milliom of records, I missed 1
> milliom
> ... every 2nd ...
>
> if i use Recycle every 1000 records ... I must lost all the 1000th
> Records (about 2000 records) ! (Less records that now)
>
--
Sent through GMX FreeMail - http://www.gmx.net
Notes
- Quoted lines have been omitted from some messages.
View the message alone to see the lines that have been omitted