C / C++ / MFC

FirstPrevNext

Accessing a Sybase Stored Procedure Unplugged7-May-03 5:37 Unplugged 7-May-03 5:37  I'm having some problems here. What I want to do is access a sybase stored procedure through a c++ program. The problem I'm having is, 1) adding a data source to an already existing program. (I'm using Microsoft Visual Studio). 2) how to call the stored procedure and how to acess the results. If anyone can give me any help it would be most appreciated. ICXC NIKA Re: Accessing a Sybase Stored Procedure jmkhael7-May-03 6:11 jmkhael 7-May-03 6:11  http://www.codeproject.com/database/readdb.asp[^] Update ur driver in the code to the sybase driver installed ( u can check it in the ODBC in control panel) and use SQL like EXEC storedProcedure ( or call , i dont recall exactly ) eg. exec sp_FileExist 'F', 'CLNHLDY_DBF' Hope this helps Papa while (TRUE) Papa.WillLove ( Bebe ) ; Re: Accessing a Sybase Stored Procedure basementman7-May-03 11:14 basementman 7-May-03 11:14  You need to either use the Sybase CTlib directly or use a higher level abstraction layer, such as ODBC or ADO. If using ODBC, you need the Sybase ODBC driver installed on the system and configured correctly. Once that is done, you can use SQLExecDirect or SQLPrepare/SQLExecute to invoke the SP. Remember that you either need to change to the appropriate database (using a CTLib function or SQL USE {database} query -OR- embed the database name in the procedure) sprintf(caSQLBuf,"exec %s.dbo.MyProcedure '%s'", caDBName, caParam1); SQLExecDirect(caSQLBuf). Let me know if you need a generic ODBC class library or if you don't want to roll your own. Simulating Jave 'package' access modifier in C++ roel_7-May-03 5:28 roel_ 7-May-03 5:28  Can anyone think of a way to simulate the Jave concept of a 'package' access modifier (next to public, protected, private) in C++? For those who don't know Java: 'package' will give access to members for all classes that are in the same package, that would be in the same directory in Java; but what I would like to have is something that works like a namespace. Basically, to restrict access to classes and class members to othere classes that are in the same 'namespace'. In concreto, I have written a library with a public interface, and I want to disallow access to the internals of the library. It's an in-house library, but still, I would like to make sure that people don't start doing stuff without using the 'official' API. Thanks. Why have my Classes disappeared? LittleYellowBird7-May-03 5:10 LittleYellowBird 7-May-03 5:10  Hi, I was happily editing my code today when I suddenly found that I had lost 30 classes! They no longer appear in the 'Workspace' area on the screen. If I look in the 'Files' tab the relevant files are there and the code compiles just fine. What the hell have I done???????? Any ideas of how I might get them to reappear would be brilliant. Many thanks & completely confused, Ali Re: Why have my Classes disappeared? Carlos Antollini7-May-03 5:14 Carlos Antollini 7-May-03 5:14  It;s a common bug, only modify the header, and you will be the class in your workspece. For example add an Enter in your header..... Best Regards Carlos Antollini. Pi Five[^]Creator Sonork ID 100.10529 cantollini Re: Why have my Classes disappeared? LittleYellowBird7-May-03 5:36 LittleYellowBird 7-May-03 5:36  Thank you, thank you, thank you I've been adding and deleteing files for the last hour trying to sort it out. I obviously hadn't got the right file. I took your advise and edited the headers, and bingo it is all there again. Phew, what a relief! Thanks again, Ali Re: Why have my Classes disappeared? Hari Krishnan (Noida)7-May-03 5:39 Hari Krishnan (Noida) 7-May-03 5:39  Hi, The .ncb file contains ClassView browser information. I believe, some of your .ncb(if you're using multiple projects) file permission may have changed. That is the cause. To check that, create a sample program and change .ncb file to read-only. Now you reload the project, you will not be able to see any classes in the classview. Hope this helps, if not better you move all your .ncb files to some other location. so that your .dsw/.dsp will recreate your class view again. regards ~Hari~ Re: Why have my Classes disappeared? LittleYellowBird7-May-03 22:43 LittleYellowBird 7-May-03 22:43  Thanks for the help, I ran my project in the morning and they had all gone again, and when I looked closely not all of my classes had come back. But I tried deleting that file and they are all there now! Cheers! Many Thanks, Ali Re: Why have my Classes disappeared? David Crow7-May-03 8:04 David Crow 7-May-03 8:04  For some strange reason, the temporay files .NCB, .CLW, and .APS need to be deleted every so often, letting VC++ rebuild them as necessary. Re: Why have my Classes disappeared? LittleYellowBird7-May-03 22:42 LittleYellowBird 7-May-03 22:42  Thanks for the help, I ran my project in the morning and they had all gone again, and when I looked closely not all of my classes had come back. But I tried deleting those files and they are all there now! Cheers! Many Thanks, Ali dynamic creation of buttons and tooltips? jimNLX7-May-03 5:01 jimNLX 7-May-03 5:01  I'm creating many buttons dynamically using this to initialize it: m_Icon[ndx].Create(_T(""), WS_CHILD WS_VISIBLE , CRect(0, 0, 0, 0), this,IDC_BTN ); Then later I'm adding in other information and then putting it on the screen: m_Icon[0].SetTooltipText((LPCTSTR)ps1,true); m_Icon[0].ActivateTooltip(true); m_Icon[0].SetIcon(IDI_ICON1,NULL); m_Icon[0].MoveWindow(iXpos ,(yscalestart + yscalediff*(profile.counter[0].iStationNum -10)),29,33,TRUE); Any ideas on why the tool tip doesn't work? I've used tool tips before using static items and it was never a problem Thanks, Jim Re: dynamic creation of buttons and tooltips? Hari Krishnan (Noida)7-May-03 5:26 Hari Krishnan (Noida) 7-May-03 5:26  Hi, You need to relayevent to the tooltip control. Otherwise, how tooltip control will know when & where to show what? Also, whether you are using CTooltipCtrl? If so, then you have to add some more stuff also like addtool, etc.. regards ~Hari~ Re: dynamic creation of buttons and tooltips? jimNLX7-May-03 5:38 jimNLX 7-May-03 5:38  Thanks for the reply. I'm using the CButtonST class that has the relay message in it. I've posted this to the Articles section... convert project file from visual c++.net to visual c++ 6.0 AhMan7-May-03 4:53 AhMan 7-May-03 4:53  I'd like to convert project file from visual c++.net to visual c++ 6.0 What should I do ? Thank you in advanced Re: convert project file from visual c++.net to visual c++ 6.0 John M. Drescher7-May-03 4:58 John M. Drescher 7-May-03 4:58  Use the VC++7 to VC++6 project converter: http://www.codeproject.com/tools/prjconverter.asp[^] John Re: convert project file from visual c++.net to visual c++ 6.0 Anonymous7-May-03 17:04 Anonymous 7-May-03 17:04  Thanks a lot AhMan version and problem with mscomm32 Dr-Kuulun7-May-03 4:32 Dr-Kuulun 7-May-03 4:32  hi, is the someone who knows the actual version of the mscomm32.ocx control? where can i search for a new release? i have problems with the parity option. after an undefined time of work the control sends only the parity replace char to my software. when i close and start the port again the problem is cleared until it occurs again. this problem happens mainly on laptops. i checked the correct bit stream with an oscilloscope. the bit stream is at any time correct. did you recognize the same problem? Dr-Kuulun Re: version and problem with mscomm32 David Crow7-May-03 4:38 David Crow 7-May-03 4:38  In Windows Explorer, right-click on the file and select Properties. You can then see what the version is. Re: version and problem with mscomm32 Sean Cundiff7-May-03 4:43 Sean Cundiff 7-May-03 4:43  According to: this[^] the latest version of mscomm32.ocx is 6.0.81.69 -Sean ---- Shag a Lizard make lowercase char to uppercase JensB7-May-03 4:28 JensB 7-May-03 4:28  Hi i subclassed CEdit to CMyEdit. I know when i have a lowercase char. but the problem is to make it uppercase. I checked the string.h but didn't find a proper function to work with (in VC5). void CMyEdit::OnChar(UINT nChar, ...) { .. if ( bLowercase ) { //Convert char to uppercase //nChar 'a' -> 'A' needs to be in uppercase } // let char. through CEdit::Onchar(nChar, nRepCnt, nFlags); } Re: make lowercase char to uppercase David Crow7-May-03 4:30 David Crow 7-May-03 4:30  Can you just use the ES_UPPERCASE style? If not, use toupper(), or CString::MakeUpper(). Re: make lowercase char to uppercase JensB7-May-03 4:39 JensB 7-May-03 4:39  well yes. i found that style earlier and checked it on. But in my onChar() routine i didn't allow lower cases, i just allowed it and now everything works. thanks Re: make lowercase char to uppercase jmkhael7-May-03 4:33 jmkhael 7-May-03 4:33  check _strupr or CString::MakeUpper or convert ur char to an int then add to it 20 hex or 32 dec Papa while (TRUE) Papa.WillLove ( Bebe ) ; Re: make lowercase char to uppercase Renjith Ramachandran7-May-03 4:34 Renjith Ramachandran 7-May-03 4:34  CString::MakeUpper() CodeTheDreams();

Last Visit: 31-Dec-99 18:00     Last Update: 28-Sep-24 15:26 Refresh ᐊ Prev1...14985149861498714988149891499014991149921499314994 Next ᐅ

General    News    Suggestion    Question    Bug    Answer    Joke    Praise    Rant    Admin   

Use Ctrl+Left/Right to switch messages, Ctrl+Up/Down to switch threads, Ctrl+Shift+Left/Right to switch pages.