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