Closed

Fix function bug in VS2008 c++

Here is the function

__________________________________

CString CRDoc::GetChairNo(CString strAcctNum, CString strDepNum, CString strSequence)

{

CString strChairNo;

TCHAR sql[300];

TCHAR temp[32];

void* val;

SWORD type;

int size;

// [login to view URL]

memset(temp, 0, sizeof(temp));

val = temp;

size = sizeof(temp);

type = SQL_C_CHAR;

// [login to view URL] the patient email from resp table.

// 2.1 Create the sql.

memset(sql, 0, sizeof(sql));

sprintf_s(sql, sizeof(sql), "select first chair from [login to view URL] where acctnum='%s' and depnum='%s' and sequence in (%s) ",

strAcctNum, strDepNum, strSequence);

// 2.2 Execute the sql.

CSCISet::GetSQLValues(sql, &val, &size, &type, 1);

strChairNo = temp;

return strChairNo;

}

___________________________________________________________

Most times it return the correctly but sometimes it returns zero (which is incorrect)

Need knowledge of VS2008 c++ and sql

Skills: MySQL, SQL

See more: fix flash bug, freelancer fix network bug, jquery val function bug, microsoft vs 2008 sp1, visual studio 2008 installer, visual studio 2015 the application cannot start, php sql injection xss fix function, fix graphics bug, fix css bug joomla, average time fix php bug, fix myspace bug, fix magento bug, fix function php, asp fix function, fix jquery bug safari, fix youtube bug beatz, fix asterisk bug, mysql fix function, fix java bug blackberry, fix android bug

About the Employer:
( 97 reviews ) Phoenix, United States

Project ID: #17944158

9 freelancers are bidding on average $40 for this job

Yknox

Hello I'm interesting your project very well I'm a Good expert of C++, C#, PHP, Node.JS, Angular.JS, Java, Swift, Object C, Android, iOS, HTML5, Mathmatics, Algorithm. I m quite well experienced in these jobs. Le More

$35 USD in 1 day
(46 Reviews)
6.7
ripasahasl

I think - Your issue is in select first chair from [login to view URL] where acctnum='%s' and depnum='%s' and sequence in (%s) are You getting the result from it?

$30 USD in 1 day
(26 Reviews)
5.1
vano101

Hello I have 17 years of experience with C++, Windows API and Microsoft Visual Studio. Also, I have installed VS2008 on my computer

$25 USD in 1 day
(85 Reviews)
5.3
xinglong717

Hi. I have read your description and have interests in your project. I would like to have a discussion with chat to get more about your project. Thanks.

$35 USD in 1 day
(13 Reviews)
4.6
chongyin429

Hello, I have carefully checked your code. The issue might be occurred when you entered invalid param and database could not find correct result. If you want, I can fix this bug just in a moment. If you can accept my More

$100 USD in 1 day
(1 Review)
4.6
Tikdragon

Hi, there. I've experienced in C++ since VS6. So, I'm sure I can fix your bugs successfully. I want to help you. Thanks.

$55 USD in 0 days
(6 Reviews)
3.7
BorisSchalk

I found 2 bugs in SQL. sprintf_s(sql, sizeof(sql), "select first chair from [login to view URL] where acctnum='%s' and depnum='%s' and sequence in (%s) ", strAcctNum, strDepNum, strSequence); 1) Error Code : 1054 Unknow More

$25 USD in 1 day
(1 Review)
0.6
dollarzhaole

Maybe the SQL is not right, I havn't seen the first key word in SQL syntax. Which database are you using? MySQL? If MySQL, select the first column, using the following SQL: SELECT column_name(s) FROM table_name WHE More

$25 USD in 1 day
(0 Reviews)
0.0
arcsoft16

Dear Prospect Hiring Manager. Thank you for giving me a chance to bid on your project. i am a serious bidder here and i have already worked on a similar project before and can deliver as u have mentioned I have More

$28 USD in 7 days
(0 Reviews)
0.0