Displaying 4 results from an estimated 4 matches for "sqlstring".
2007 Apr 18
1
How to call stored procedure on iodbc
...h 1 parameter is out parameter and other 5 are input parameters.
So it uses 5 IN parameters as values for inserting a row in database
and returns its max id as out parameter.
Code Snippet is given below :--
SWORD returnCode = 0;
SDWORD bindReturnCode = 0;
RETCODE returnVal;
char sqlString[500];
memset(sqlString,0,sizeof(sqlString));
HSTMT hstmt = ptrDB->GetHSTMT();
returnVal = SQLAllocStmt(ptrDB->GetHDBC(), &hstmt);
if (returnVal == SQL_SUCCESS)
{
returnVal = SQLBindParameter(hstmt, 1, SQL_PARAM_OUTPUT,
SQL_C_SLONG, SQL_INTEGER,...
2010 Feb 16
1
RODBC missing values in integer columns
...t and
do not alternate to null. Also, if we increase the rows_at_time to 1024
there are larger gaps between the 0's and actual data. The server is a
sybase IQ database. We have tested it on a different database sybase ASE and
we still get this issue.
For example :
We have the following query
sqlString = "Select ActionID, Velocity from ActionDataTable"
#where ActionID is of integer type and Velocity is of double type.
connection = odbcConnect("IQDatabase"); #this database is a sybase IQ
database
sqlData = sqlQuery(connection, sqlString);
sqlData$ActionID might be 1,2,3,4,5,...
2005 May 18
2
R -SQL
Hello,
I've got a problem in a sql query!
for(j in 1:length(criteria$Title))
{
graphe_par<-sqlQuery(channel,"select q.type,crit.Title, r.Value from criteria crit, reply r,question_reply qr, question q, question_criteria qc, form_question fq where qr.reply=r.ID and qr.question=q.ID and qc.question=q.ID and crit.ID=qc.criteria and fq.question=q.ID and fq.form=4 and
2009 Jan 12
0
Problems with RMySQL and MySQL server version 5.1
...en <Erik.Jorgensen at agrsci.dk>
> To: jeff.horner at vanderbilt.edu
>
> Hi Jeffrey
>
> I have some problems with the use of RMySQL since upgrading to RMySQL
> version 0.7-2 and MySQL server version 5.1. The RGUI crashes, when I
> e.g. call the function dbGetQuery(conn, sqlstring) (but not e.g.
> dbListTables(conn)).
>
> It seems that it is due to incompatibility with MySQL version 5.1.
> When I replace the libMySQL.dll file from version 5.1 with the 5.0
> version of the file, the problem disappears.
>
> Best regards
>
> Erik J?rgensen
> Fac...