I've read the post on tek-tips (thread68-469381 and I have the same kind of trouble. I want to have a chart with 1 stacked column and 2 normal columns.
My data could look like:
Stack1 Stack2 Column2 Column3
5 0 5 8
2 5 5 8
7 7 5 8
3 14 5 8
5 17 5 8
5 22 5 8
9 27 5 8
0 36 5 8
0 36 5 8
5 36 5...
Hi,
I've to modify a web page written in asp.net / c#.
The web page is only a header and a datagrid. The thing is that the datagrid can contain like 30 pages of data.
I would like to print all of them correctly but when i'm using the standard print button from explorer, it truncates the...
The trouble with this is that if someone inserts in another table or there is delete in the table, this value becomes rapidly not accurate.
Or it is a trouble if the las inserted record in another table was from a table having a lower key the the maximal value of the table I want to insert into....
I'm using sql server 7.0...
How can I extract the next identity of a table column?
the best solution I've got is:
dbcc checkident(tbl_PHA_Info) 'Refresh the field
select autoval from syscolumns where id = object_id('tbl_PHA_Info') and name = 'id'
The result looks like this...
Thx alot guys,
I've tried the Matt solution and Jonh24 too but none seems to kill the process completely.
When I do my application.quit (if I look in the taks manager) it changes the USER Object but doesn't kill the process.
The application.userName is blank at this stage.
I set my objet...
I've tried this but I cannot do it because I want the excel document to be visible to the user.
If I do the quit procedure, it quits immediately the excel process and the user cannot look at the document.
I'm using an excel application object in VB to create an excel document to show to the user.
The trouble is that when the user quits the excel application I have created, the excel process continues to run in the background. It seems to shut down only when my main VB application is closed.
I...
thx alot!
but is there a way of like automatically load the file into the SQL Statement.
I'm presently using the "Dynamic parameter object" to change things and I'd like to do the same to specify the script file to execute.
The trouble with your solution is that my server and...
I have a query that returns a perfect xml for one record. It looks like
<People>
<Artist>
<Info><TheInfo ddd></info>
<otherInfo><TheInfo2 eee></otherInfo>
<MoreInfo><TheInfo3 fff></MoreInfo>
</Artist>
</People>
I've done this with parent tags. I think I've followed all the steps...
The trouble is not really the sql thing is how to write it in C++. The SQL query is exactly the the query I wrote before.
I just don't know how to write this un C++... do you JohnFill?!?!?
If you still don't understand what I don't understand it's: if I try to put this query my m_strFilter...
I am trying to do a union query between 2 tables.
I used to make my querie with the GetDefaultSQL and m_srtFilter of the CRecordset class.
I cannot figure how to make an sql query like this:
SELECT ** FROM A WHERE X=X UNION SELECT *** FROM B WHERE Y=Y
Thx
I need to know how to pinpoint if a database query has returned a NULL value.
I do a left join with 2 tables so it is possible that I have NULL values in one of my table fields.
I've tried to use NVL like this:
RFX_Text(pFX, _T("NVL([CPG], "REC_NULL")"), m_CPG);
It's not...
I'm a newbie programmer and I have to write a program that must to be running background (invisible an without any icons or dialogs). It will perform some actions on a database and write a log afterward.
There's sureley a way to do that easely...
Can U help?
Is my question clear enough...
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.