1. Alexis Colon Lugo
  2. Valentina Reports ADK
  3. Thursday, January 31 2019, 01:01 AM
  4.  Subscribe via 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".
".
Comment
There are no comments made yet.
Alexis Colon Lugo Accepted Answer
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
Comment
There are no comments made yet.
  1. more than a month ago
  2. Valentina Reports ADK
  3. # 1
Alexis Colon Lugo Accepted Answer
thanks
i have found the error in the reports
i fix it
Comment
There are no comments made yet.
  1. more than a month ago
  2. Valentina Reports ADK
  3. # 2
  • Page :
  • 1


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

Categories

Announcements & News
  1. 0 subcategories
Valentina Studio
  1. 2 subcategories
Valentina Server
  1. 4 subcategories
Valentina Database ADK
  1. 0 subcategories
Valentina Reports ADK
  1. 0 subcategories
Other Discussions
  1. 2 subcategories
BETA Testing
  1. 0 subcategories
Education & Research
  1. 0 subcategories