PC SOFT

GRUPOS DE DISCUSSÃO PROFISSIONAL
WINDEV, WEBDEV e WINDEV Mobile

Inicio | Mensagens recentes | Conecte-se... |  | Português FR
Inicio → WINDEV 2024 → Pivot control and query from OLEDB (ACCESS)
Pivot control and query from OLEDB (ACCESS)
Iniciado por Mauro, out., 09 2019 9:33 AM - Sem resposta
#1
Membro registado
1 mensagem
Publicado em outubro, 09 2019 - 9:33 AM
Hi to all.
I'm a very beginner in Windev and an OLD VB programmer.

I have a query as follows
SELECT
Int(Year(BilSorge.Data)) AS [Yr],
Int(Month(BilSorge.Data)) AS [Mnth],
LEFT(BilSorge.Sottoconto,2) AS Master,
MID(BilSorge.Sottoconto,3,3) AS HeadAccount,
RIGHT(BilSorge.Sottoconto,5) AS Account,
BilSorge.Descrizione AS Description,
BilSorge.Dare AS Debit,
BilSorge.Avere AS Credit,
BilSorge.Dare - BilSorge.Avere AS Balance
FROM
BilSorge

The connection is to an ACCESS database via OLEDB connection

The int function has to be passed as is. If I run the test on the query it works fine because I set

"run with hQueryWithoutCorrection in test mode."

The problem is that in the PVT_Control it returns an error because the system is changing the int() into Integer()

I read somewhere that you need to set that option in the Query description Advanced option but I don't see advanced option in the query description form.

Any Help?

Thank you
→ Voltar para WINDEV 2024