Riebens Blog

Engaging Infinite Improbability Drive...

My first Windev sql qry

Posted by Benjamin Dell
Benjamin Dell
Benjamin Dell has not set their biography yet
User is currently offline
on Thursday, 24 November 2011
in Development Chat

Decided I needed to look at my mssql data without the help of tables or other visual aids.

I created my sql connection, coded my qry, gave it a name and then called the qry.

Compiled my program and ran the program .. all in a few minutes without having done any hand coded sql connections or queries in windev before.
I returned the data and read the reply .. smiley It works ..

For the inquisitive with us ...This is an mssql2008R2 Server connect to via OLEDB and the connection seems about as fast as native clarion, but I cannot be sure of that unless I run some real intensive tests.

I am not even sure if I have to have the SqlChangeConnection in there ... just thought I would throw it in there for good measure..

This is definitely a 2*'way cool' on my coolness scale

0 votes
Tags: mssql, Windev
Benjamin Dell has not set their biography yet