1. Alexis Colon Lugo
  2. Valentina Reports ADK
  3. Четверг, Январь 31 2019, 01:01 AM
  4.  Подписаться через email
Select numsocio,concat(apellidos,' ',dueno) As nombre,concat(direccionpostal,' ',ciudad,' ',estado,' ',codigopostal) As dir1 ,celularnumero,email,statussocio From socios Where statussocio='f'

Error
Datasource error: "ERROR: column "Nombre" does not exist
LINE 1: ... From socios Where statussocio='f') as foo ORDER BY "Nombre"
^
HINT: Perhaps you meant to reference the column "foo.nombre".
".
Комментарий
There are no comments made yet.
Alexis Colon Lugo Ответ принят
my code

RepStrConn="postgresql://host='" + Session.MSDB.Host + "' port='5432' dbname='" + Session.MSDB.DatabaseName + "' user='postgres' password='home123'"



projectPath = GetFolderItem( "adgreports.vsp" )

mProject = new VProject(projectPath)

mProject.Open()

if mProject <> nil then
session.MSDB.vCounts = mProject.ReportCount()
end if



try

mReport = mProject.MakeNewReport(RepCall, RepStrConn,MyQuery )


catch e as VException
dim errNumber as Integer = e.ErrorNumber
dim errString as String = e.Message
MsgBox "** Make Report error " + errString
MsgBox "** Make Report error num =" + Str(errNumber)
exit sub
end
Комментарий
There are no comments made yet.
Alexis Colon Lugo Ответ принят
thanks
i have found the error in the reports
i fix it
Комментарий
There are no comments made yet.
  • Страница :
  • 1


There are no replies made for this post yet.
However, you are not allowed to reply to this post.