PC SOFT

FOROS PROFESIONALES
WINDEVWEBDEV y WINDEV Mobile

Inicio → WINDEV 2024 → How to Connect to a MS SQL-Server-View ?
How to Connect to a MS SQL-Server-View ?
Iniciado por b.rohde, 06,jun. 2016 15:35 - No hay respuesta
Publicado el 06,junio 2016 - 15:35
Hi,
I bought the "SQL Server Native Access" (V21) and installed it.
I can establish a connection with WD19/21 to a server in the server farm of my client.
But I cannot access to a record to one of the five views.

I ONLY have access to data with "OLEdb SQL Server" TO 5 views (no tables !) from my client.
These views I also can see with the Microsoft "SQL Server 2014 Managament Console".
Within the HFSQL Control Center I can also connect manually. But I don´t see these 5 views.
If I fill the SQL-Code in the HFSQL-Console f.i. with "SELECT * FROM clnt_view_getProjects" I see all the related records.

But: How can I access with Windev after establishing the connection to these records?
Is there an example in the documentation?

I would be very happy for answers or a short code example.

Best Regards
Bertrand