Search results for query: *

Hi friends, I am facing a problem.I have a main page which includes two tab pages.Now I am using TabPro Active X and not Property Sheets.The user naviagates between the two tab pages.In case one of the page is not active I am supposed to do something. My problem here is that:I am trying to use...

Hi, Thanks for your response actually I am getting this problem while populating workspace variables.This workspace variable is actually an array of variables which is used by our Front End to pass on the values to the backend. What can be a possible solution to get this thing in ordrer ! Any...

Hi all, I am faced with a very difficult situation.We have an application with a thin client(on VC++) on a fat server.The application uses a pop-up page that is running fine in the development environment.However when run on the production environmnet it is giving a Windows failure as soon as...

Hi all, I am planning to use grids in my application using VC++.Can someone please suggest what control to use and is any product available for that?Also how to go about doing that? TIA Somnath

Hi, I have created a bitmap and trying to load it but on debugging I find that the LoadBitmap function is returning 0 i.e it is failing.What are the reasons because of which this might fail? Thanks Somnath

Hi friends, I would like to know if anyone of you have taken the certification test of Sybase SQL Developer.In case you have taken it can you please revert to me with some practical tips or how yo go about preparing for it. Thanks in advance Somnath

Hi Manoj, 1> select dateadd(dd,-1,getdate()) 2> go -------------------------- May 9 2002 3:50PM (1 row affected) Regards Somnath

Hi friends, I want to know whether there is any coomand in sybase clients by which we can direct the query into an html page? Thanks Somnath

Just adding to this:- This again depends on the 'Style' you choose in the Combo Box of the properties.In case you make it a Child you do not get to see the maximise and minimise options.However it is visible for the Overlapped and Popup settings. Somnath

Hi friends, Can anyone please explain the significance of the columns : segmap lstart size vstart pad unreservedpgs in the sysusages table . Thanks in advance

Hi, Let us take a query like this 1).select * from tab group by col1,col2 having and clause 1 and caluse 2 and clause 3 and clause4=MAX(value) now take this query 2).select * from tab where clause 1 and caluse 2 and clause 3 group by col1,col2 having and clause 1 and caluse...

Thanks a lot for the response.The sp_lock in the rep server is really different Best Regards Somnath

Hi friends, I have come across a very strange feature.Can someone please explain to me as to how it works out.Basically a query to get the row counts of a group by having caluse. This is the pseudo code select count(isnull MAX(TAB.COL2),0)) from TAB where TAB.COL1=<value> and...

Hi , I have come across a very interesting situation and I need some light on it.While using the sp_lock command in the production database I do not get the column table_name in the output .However when it is used in the replication server I am get to see the table_name column. Can someone...

Hi, If time is not of any concern in the query you may use the 112 format for date. 112 will express the date in yyyymmdd format and will be easy to order by. Thanks Somnath

Hi Greg and friends, I had actually gone through the manual but unfortunately it hardly is of any help.The same query which runs perfectly fine for the same set of data suddenly pops this error.Again when the batch job is restarted it runs fine.I an totally at a loss to make out what the...

Hi friends, I usually get a problem when I run embedded queries through a COBOL batch program.It gives me the following SQL message:- &quot;SQL_MSG: 0001 <SQL ERROR> SQLCODE IS 00000774Q <SQL ERROR> MESSAGE TEXT IS Pseudo-column 'SYB_IDENTITY' used incorrectly. No table in the query has the...

Hi friends, While trying to compile a prog that uses a file to place data ,I am getting the following compilation error:- C:\Vectors.cpp(26) : warning C4129: 'l' : unrecognized character escape sequence C:\Vectors.cpp(33) : error C2872: 'cout' : ambiguous symbol C:\Vectors.cpp(40) : error...

Thanks it works !

Hi beltion , The only place they talk about spurious group by in Sybase is when you use group by without using an aggregate function.It might or might not group by and is not dependable.To check out whether your query is giving a warning set fipsflagger on before running the query.As per Sybase...