Search results for query: *

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...

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...

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...

Is there a way to load a sql statement written in a text file with the object "execute SQL task"?

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...

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(&quot;NVL([CPG], &quot;REC_NULL&quot;)&quot;), 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...

Hi, I'm looking for a good free cobol compiler I could run on NT. I'm using Cobol II... Can U help?