package main
    	
import (
	"fmt"
	"mgodbc"
	"database/sql"
	"strconv"
)
     
func main() {
	mgodbc.RegisterMGODBC()
	
	db, errDriver := sql.Open("mgodbc", "Driver={SQL Server Native Client 10.0};Server=XXX;Database=XXX;Uid=XXX;Pwd=XXX")
	if errDriver != nil {
		fmt.Printf("Failed: %v", errDriver)
	}
	fmt.Printf("Success new driver ")	
	
	rows, errQuery := db.Query("select top 1 clmno from clh where neg = 'LSL' and PendCode NOT IN ('Y', 'Z')")
	if errQuery != nil {
		fmt.Printf("Failed: %v", errQuery)
	}
	fmt.Printf("Success query ")	
	
	type row struct {
		clmno  int
	}
	
	for rows.Next() {
		var r row
		rows.Scan(&r.clmno)
		fmt.Println(" Claim number: " +  strconv.Itoa(r.clmno))
	}
	
	errClose := db.Close()
	if errClose != nil {
		fmt.Printf("Failed: %v", errClose)
	}
	fmt.Printf("Success close driver ")	
	
}