Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations TouchToneTommy on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  • Users: PavelGur
  • Content: Threads
  • Order by date
  1. PavelGur

    Daylight time change in C++

    I have a time problem since last Sat. Though my computer automatically got daylight saving time my C++ program that adds new row to MS Access table using CTime::GetCurrentTime()is still inserting time that one hour less than currentt iime. I checked Control Panel and it has correct daylight...
  2. PavelGur

    Deleting Class from project

    I'm having problem deleting class deriving from DB table from the project. Normally I delete cpp and h files for the class and also delete clw file and when I open workspace I offered to rebuld all classes and then can add new class with the same name. However I am having problem to follow the...
  3. PavelGur

    Data type conversion

    I need to convert some data that I receive over Internet in String format to float and integer. So far I was not able to find conversion functions in C# help. I was looking for equivivalent of C++ atof and atoi but did not find them. Thanks in advance, Pavel.
  4. PavelGur

    Insertion of data in MS Access table.

    I'm new to C# coming from C++ 6.0. I need to insert data into MS Access table. I was able to read data from table with Reader. However when I try to insert simple one item I've got from one table into another table it runs w/o errors but data is not in the table. Here is my code: private...
  5. PavelGur

    Syntax error in INSERT INTO

    I got this error on Recordset AddNew which I used many times before and have never had any prblems. I checked all values and column names and did not find any suspects. I also searched Web and did not find any meaningful answers. Here is the code: pBTCH->AddNew(); pBTCH->m_CurBatch...
  6. PavelGur

    CArchive class is not recognized by VC++ compiler

    I'm trying to use CArchive to read a text file line by line. I create a file object and then try to create CArchive object. The first trouble, if I put file creation in try/catch then CArchive does not see the file object. If I comment out try/catch then CArchive see the file but I'm getting...
  7. PavelGur

    MS Access Office XP DB is not displayed

    Something happened today with my DB that I was working with for long time. I probably hit some key or clicked on something. Now when I double click on DB file in Windows Explorer MS Access window is displayed but I can not see my data base even if I click on file and select it from drop down...
  8. PavelGur

    order by does not work

    I'm running the following query from time to time and though I specified "ORDER BY Stock, Date" it is always coming in Date sequence disregarding the Stock field. SELECT * FROM Advice WHERE (Date>#3/27/2007 16:00:00#) AND (ProjPercent > .03) AND ( RankParm >5000) AND (((Price - ProjMin) /(...
  9. PavelGur

    NULL in numeric field

    I'm getting data from brokerage company that's supposed to be numeric. But actually it is not. I try to put it in the table and getting MS exception: try { pPRC->AddNew(); pPRC->m_Stock = szStock; pPRC->m_Date = CTime::GetCurrentTime(); pPRC->m_DayNum = iDayTrades; pPRC->m_Price =...
  10. PavelGur

    Getting data from Internet

    I have the same program on two computers that gets data from Internet. It is using the following code to do it: <code> if (hSession) { hURL = ::InternetOpenUrl( hSession, szURL, NULL, NULL, INTERNET_FLAG_DONT_CACHE, NULL ); if (hURL) bFile =...
  11. PavelGur

    Recordset is read-only for one opened as appendOnly

    I have a program that worked all right for a while. I added to the table that is being opened by the program couple of fields. And immediatelly program gives me 1009 error "Recordset is read-only" on AddNew. I had CRecordset::none originaly and had no problem to add new row. I changed it to...
  12. PavelGur

    invalid descriptor index

    I'm puzled with this error. I have a query in MS Access that works perfectly fine. However when I try to open recordset in VC++ 6.0 with the same query I'm getting "invalid descriptor index" error. Here is the query: CString szPLCString = "SELECT TOP 60 C.Stock \ FROM [SELECT B.* FROM Policies...
  13. PavelGur

    First-chance exception from MS Access

    I'm getting exception claiming that I put (null) in numeric field though it is not true. Here is the code and the messages: Here is the table layout in header file: CString m_Stock; CTime m_Date; float m_fAsk; float m_fBid; int m_iAskSize; int m_iBidSize; try { pAB->AddNew()...
  14. PavelGur

    Test numeric in VC++

    I work in VC++ for years and have never needed until recently to check whether data in the field is numeric. I have a vendor who sends me data in float format. When I try to put it in the SQL table I'm getting exception claimiing that field has NULL value. I'm copying the data before putting it...
  15. PavelGur

    Opening the Access table gives assertion error

    I have very strange program behavior. In the process of obtaining date period from Access table I'm getting assertion error and not even on every execution of the code. I have try - catch set but it do not give me exception but stops at the table openning. Here is the code: szPrevDate =...
  16. PavelGur

    Navigating Exel web page

    I'm getting the Web page that is actually Exel7. The way I get it is: Dim oIE Dim sURL As String Set oIE = New SHDocVw.InternetExplorer sURL = "http://ichart.finance.yahoo.com/table.csv?s=A&d=4&e=10&f=2006&g=d&a=10&b=18&c=1999&ignore=.csv" oIE.Navigate sURL Do Until oIE.ReadyState =...
  17. PavelGur

    Getting Web data

    I'm trying to get some Web data using VB6 program. I navigate to URL I compiled and then before opening the page I'm getting pop-up box asking me whether I want to save or open the spread sheet. What should I do to answer the question in the code? Thanks, Pavel.
  18. PavelGur

    subscript out of range message

    I'm debugging Excel macro that I partialy copied from another macro that works perfectly well. However in the new one I'm getting error 9 "subscript out of range" on statement Sheets("560 Stocks").select. The name matches perfectly to the name of spreadsheet. In my working macro the same...
  19. PavelGur

    pointer functions and variables

    I'm working with VC++ 6.0 for years and one thing puzzles me. When I need to code variable or function of the entity that is addressed by pointer sometimes after entering XXX-> I'm getting the box that shows me all possible variables and functions available and sometimes it does not. I can not...
  20. PavelGur

    Resizing the window with Javascript

    I'm using the function I found on Microsoft site to resize the browser window. The function looks like this: <script language="JavaScript"> window.onload = maxWindow; function maxWindow() { window.moveTo(0,0); if (document.all) { <!-- I changed the following to constant sizes -->...

Part and Inventory Search

Back
Top