ACCESS - String demasiado largo

[Laufwerk]

Hola amigos!
Estoy generando un string SQL pero nunca me pasa de 1477 caracteres.
Lo estoy declarando de la siguiente forma:

Código:

            stLinkCriteria = "SELECT Incidencias.id_incidencia AS idIncidencia, Administradores.nombre AS nombre, " _
            & "Incidencias.id_site AS idSite, Sites.nombre AS site, Categorias.descripcion AS categoria, " _
            & "Incidencias.titulo, Incidencias.descripcion, IncidenciasUsuariosApp.fecha, Incidencias.fecha_creacion, " _
            & "Incidencias.fecha_finalizacion, Impactos.descripcion AS impacto, Prioridades.Descripción AS prioridad, " _
            & "[Incidencias Estados].descripcion AS estado, IncidenciasUsuariosApp.id_administrador AS idAdmin, " _
            & "Incidencias.id_estado AS idEstado " _
            & "FROM Sites INNER JOIN (Prioridades INNER JOIN ((Impactos INNER JOIN ([Incidencias Estados] INNER JOIN " _
            & "(Categorias INNER JOIN Incidencias ON Categorias.id_categoria=Incidencias.id_categoria) ON " _
            & "[Incidencias Estados].id_estado=Incidencias.id_estado) ON Impactos.id_impacto=Incidencias.id_impacto) " _
            & "INNER JOIN ((CategoriasAdministradores INNER JOIN Administradores ON CategoriasAdministradores.id_categoriaAdministrador=Administradores.id_categoriaAdministrador) " _
            & "INNER JOIN IncidenciasUsuariosApp ON Administradores.id_administrador=IncidenciasUsuariosApp.id_administrador) ON " _
            & "Incidencias.id_incidencia=IncidenciasUsuariosApp.id_incidencia) ON Prioridades.id_prioridad=Incidencias.id_prioridad) " _
            & "ON Sites.id_site=Incidencias.id_site WHERE (((IncidenciasUsuariosApp.fecha)=(SELECT TOP 1  IncidenciasUsuariosApp.fecha " _
            & "FROM IncidenciasUsuariosApp WHERE id_incidencia=Incidencias.id_incidencia ORDER BY IncidenciasUsuariosApp.fecha DESC ))) " _
            & "AND idIncidencia=" & valor & " AND idEstado=" & idEstado

Me podeis ayudar?


Gracias!!!!

[Taribo007]

Segun la ayuda de access, una variable tipo string puede contener hasta 2.000.000 de caracteres. Por que dices que se corta en esa cifra?? Podria poner el codigo completo???

un saludo

[Laufwerk]

Eso es lo que yo también he leído, sin embargo, me devuelve este string

Código:

"SELECT Incidencias.id_incidencia AS idIncidencia, Administradores.nombre AS nombre, Incidencias.id_site AS idSite, Sites.nombre AS site, Categorias.descripcion AS categoria, Incidencias.titulo, Incidencias.descripcion, IncidenciasUsuariosApp.fecha, Ic"

como puedes ver se corta, pq?

[Taribo007]

Pero donde te devuelve eso?? Que estas haciendo exactamente??

un saludo

[Laufwerk]

Estoy debugando y antes de ejecutar la siguiente linea,

Código:

Set rsIncidencias = CurrentDb.OpenRecordset(stLinkCriteria)

agrego una inspección de stLinkCriteria y esto,
"SELECT Incidencias.id_incidencia AS idIncidencia, Administradores.nombre AS nombre, Incidencias.id_site AS idSite, Sites.nombre AS site, Categorias.descripcion AS categoria, Incidencias.titulo, Incidencias.descripcion, IncidenciasUsuariosApp.fecha, Ic"

es el valor de dicha variable.


Gracias!!!

[Taribo007]

Y si haces esto???

msgbox len(stLinkCriteria)

que valor te devuelve??

Un saludo

[Laufwerk]

1477 es lo que me devuelve.


Gracias

[Taribo007]

Y si añades mas caracteres??? Te muestra mas el msgbox??

un saludo

[Laufwerk]

nono, no pasa de 1477, no lo entiendo
...

[Taribo007]

Puedes poner el codigo completo, la decalarcion de la variable, etct etc.

Es que acabo de probarlo, he añadido mas caracteres, y el mensaje los muestra sin problemas.

Un saludo

[Laufwerk]

el codigo lo tienes en el primer post, y la declaración de la variable :

Código:

Dim stlinkCriteria as String

de toda la vida.

Tengo el problema solucionado ya que he hecho una consulta mucho mas corta, pero ahora tengo la intriga del error que daba.


Gracias!

[Taribo007]

Yo tambien, te importa probar esto a aver si funciona??

Dim var As String

var = "kjhlkjhlkjhlkjhlkjhlkjhlkjhlkjhlkjhlkjjjjjjjjjjjj jjjjjjjjjjjjxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx xxxxxxxxxxxxxxxxx"
var = var & "kjhlkjhlkjhlkjhlkjhlkjhlkjhlkjhlkjhlkjjjjjjjjjjjj jjjjjjjjjjjjxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx xxxxxxxxxxxxxxxxx"
var = var & "kjhlkjhlkjhlkjhlkjhlkjhlkjhlkjhlkjhlkjjjjjjjjjjjj jjjjjjjjjjjjxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx xxxxxxxxxxxxxxxxx"
var = var & "kjhlkjhlkjhlkjhlkjhlkjhlkjhlkjhlkjhlkjjjjjjjjjjjj jjjjjjjjjjjjxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx xxxxxxxxxxxxxxxxx"
var = var & "kjhlkjhlkjhlkjhlkjhlkjhlkjhlkjhlkjhlkjjjjjjjjjjjj jjjjjjjjjjjjxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx xxxxxxxxxxxxxxxxx"
var = var & "kjhlkjhlkjhlkjhlkjhlkjhlkjhlkjhlkjhlkjjjjjjjjjjjj jjjjjjjjjjjjxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx xxxxxxxxxxxxxxxxx"
var = var & "kjhlkjhlkjhlkjhlkjhlkjhlkjhlkjhlkjhlkjjjjjjjjjjjj jjjjjjjjjjjjxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx xxxxxxxxxxxxxxxxx"
var = var & "kjhlkjhlkjhlkjhlkjhlkjhlkjhlkjhlkjhlkjjjjjjjjjjjj jjjjjjjjjjjjxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx xxxxxxxxxxxxxxxxx"
var = var & "kjhlkjhlkjhlkjhlkjhlkjhlkjhlkjhlkjhlkjjjjjjjjjjjj jjjjjjjjjjjjxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx xxxxxxxxxxxxxxxxx"
var = var & "kjhlkjhlkjhlkjhlkjhlkjhlkjhlkjhlkjhlkjjjjjjjjjjjj jjjjjjjjjjjjxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx xxxxxxxxxxxxxxxxx"
var = var & "kjhlkjhlkjhlkjhlkjhlkjhlkjhlkjhlkjhlkjjjjjjjjjjjj jjjjjjjjjjjjxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx xxxxxxxxxxxxxxxxx"
var = var & "kjhlkjhlkjhlkjhlkjhlkjhlkjhlkjhlkjhlkjjjjjjjjjjjj jjjjjjjjjjjjxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx xxxxxxxxxxxxxxxxx"
var = var & "kjhlkjhlkjhlkjhlkjhlkjhlkjhlkjhlkjhlkjjjjjjjjjjjj jjjjjjjjjjjjxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx xxxxxxxxxxxxxxxxx"
var = var & "kjhlkjhlkjhlkjhlkjhlkjhlkjhlkjhlkjhlkjjjjjjjjjjjj jjjjjjjjjjjjxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx xxxxxxxxxxxxxxxxx"
var = var & "kjhlkjhlkjhlkjhlkjhlkjhlkjhlkjhlkjhlkjjjjjjjjjjjj jjjjjjjjjjjjxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx xxxxxxxxxxxxxxxxx"
var = var & "kjhlkjhlkjhlkjhlkjhlkjhlkjhlkjhlkjhlkjjjjjjjjjjjj jjjjjjjjjjjjxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx xxxxxxxxxxxxxxxxx"
var = var & "kjhlkjhlkjhlkjhlkjhlkjhlkjhlkjhlkjhlkjjjjjjjjjjjj jjjjjjjjjjjjxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx xxxxxxxxxxxxxxxxx"
var = var & "kjhlkjhlkjhlkjhlkjhlkjhlkjhlkjhlkjhlkjjjjjjjjjjjj jjjjjjjjjjjjxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx xxxxxxxxxxxxxxxxx"
var = var & "kjhlkjhlkjhlkjhlkjhlkjhlkjhlkjhlkjhlkjjjjjjjjjjjj jjjjjjjjjjjjxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx xxxxxxxxxxxxxxxxx"
var = var & "kjhlkjhlkjhlkjhlkjhlkjhlkjhlkjhlkjhlkjjjjjjjjjjjj jjjjjjjjjjjjxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx xxxxxxxxxxxxxxxxx"
var = var & "kjhlkjhlkjhlkjhlkjhlkjhlkjhlkjhlkjhlkjjjjjjjjjjjj jjjjjjjjjjjjxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx xxxxxxxxxxxxxxxxx"
var = var & "kjhlkjhlkjhlkjhlkjhlkjhlkjhlkjhlkjhlkjjjjjjjjjjjj jjjjjjjjjjjjxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx xxxxxxxxxxxxxxxxx"
var = var & "kjhlkjhlkjhlkjhlkjhlkjhlkjhlkjhlkjhlkjjjjjjjjjjjj jjjjjjjjjjjjxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx xxxxxxxxxxxxxxxxx"
var = var & "kjhlkjhlkjhlkjhlkjhlkjhlkjhlkjhlkjhlkjjjjjjjjjjjj jjjjjjjjjjjjxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx xxxxxxxxxxxxxxxxx"
var = var & "kjhlkjhlkjhlkjhlkjhlkjhlkjhlkjhlkjhlkjjjjjjjjjjjj jjjjjjjjjjjjxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx xxxxxxxxxxxxxxxxx"
var = var & "kjhlkjhlkjhlkjhlkjhlkjhlkjhlkjhlkjhlkjjjjjjjjjjjj jjjjjjjjjjjjxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx xxxxxxxxxxxxxxxxx"
var = var & "kjhlkjhlkjhlkjhlkjhlkjhlkjhlkjhlkjhlkjjjjjjjjjjjj jjjjjjjjjjjjxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx xxxxxxxxxxxxxxxxx"
var = var & "kjhlkjhlkjhlkjhlkjhlkjhlkjhlkjhlkjhlkjjjjjjjjjjjj jjjjjjjjjjjjxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx xxxxxxxxxxxxxxxxx"
var = var & "kjhlkjhlkjhlkjhlkjhlkjhlkjhlkjhlkjhlkjjjjjjjjjjjj jjjjjjjjjjjjxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx xxxxxxxxxxxxxxxxx"

MsgBox Len(var)
Debug.Print var


Deberia salir 3364

Un saludo

[Laufwerk]

pues me sale 3422