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...
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...
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.
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...
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...
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...
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...
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) /(...
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 =...
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 =...
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...
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...
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()...
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...
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 =...
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 =...
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.
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...
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...
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 -->...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.