Error al usar SQLIte .Necesito ayuda
Publicado: Mar Dic 11, 2007 3:30 pm
Estoy creando un proyecto con una conexion SQLite
Cuando creo un query el debug me genera el siguiente mensaje
//Creacio de la select
nombre := ::oNombre:Value
pass := ::oPass:Value
cSel := "Select * from user where codigo='"+nombre+"' and
password='"+pass+"'"
oDataUser:= AppData:oSQLite:Query(cSel)
oDataUser:Open()
Mensaje del debuger
#1: SQLite Field type unknown: CHAR(10). Treated as string.
#2: SQLite Field type unknown: CHAR(40). Treated as string.
#3: SQLite Field type unknown: CHAR(10). Treated as string.
#4: SQLite Field type unknown: CHAR(20). Treated as string.
#5: SQLite Field type unknown: CHAR(50). Treated as string.
#6: SQLite Field type unknown: CHAR(10). Treated as string.
#7: SQLite Field type unknown: CHAR(1). Treated as string.
Efectivamente me aparecen la definicion de los 7 campos de la tabla pero por
que ?
Cuando creo un query el debug me genera el siguiente mensaje
//Creacio de la select
nombre := ::oNombre:Value
pass := ::oPass:Value
cSel := "Select * from user where codigo='"+nombre+"' and
password='"+pass+"'"
oDataUser:= AppData:oSQLite:Query(cSel)
oDataUser:Open()
Mensaje del debuger
#1: SQLite Field type unknown: CHAR(10). Treated as string.
#2: SQLite Field type unknown: CHAR(40). Treated as string.
#3: SQLite Field type unknown: CHAR(10). Treated as string.
#4: SQLite Field type unknown: CHAR(20). Treated as string.
#5: SQLite Field type unknown: CHAR(50). Treated as string.
#6: SQLite Field type unknown: CHAR(10). Treated as string.
#7: SQLite Field type unknown: CHAR(1). Treated as string.
Efectivamente me aparecen la definicion de los 7 campos de la tabla pero por
que ?