var sidebar_align = 'right';
var content_container_margin = parseInt('290px');
var sidebar_width = parseInt('270px');
Unanswered: How Set Ansi_nulls And With Ansi C And Db-library Supplied By Msql7
I am trying to connect to msql7 to use a store procedure that have a heterogeneous query and I cant do that without set ANSI_NULLS and ANSI_WARNINGS, but I dont know how to do it.
What should I add to my code to do that?
(I saw that setting must be done before the connection begin, and I also tried to set ansi_nulls and ansi_warnings in the store procedure but it doesn't work.)
PDBPROCESS dbproc; // The connection with SQL Server.
PLOGINREC login; // The login information.
// Install user-supplied error- and message-handling functions.
// Initialize DB-Library.
// Get a LOGINREC.
login = dblogin ();
DBSETLUSER (login, "my_login");
DBSETLPWD (login, "my_password");
DBSETLAPP (login, "example");
// Get a DBPROCESS structure for communication with SQL Server.
dbproc = dbopen (login, "my_server");
// Retrieve some columns from the authors table in the
// pubs database.
// First, put the command into the command buffer.
dbcmd (dbproc, "SELECT au_lname, city FROM pubs..authors");
dbcmd (dbproc, " WHERE state = 'CA' ");
// Send the command to SQL Server and start execution.
thank you in advance
(and sorry for my english)