Search results for query: *

I use the following VB function as embedded code in SQL reporting to generate a message box if the date entered is NOT Monday. The message box pops up fine when the date is NOT Monday. The report spans 90 pages(group inserted with page break) and I have to click the message box (vbOkCancel) 90...

Hi all, I have a datastage job executing a stored procedure in sybase(version 12.5). The stored procedure basically drops and creates a clustered index on a table. Needless to say non-clustered indexes are also created. During non-clustered index creation, sybase sends a informational message -...

I am working with VS2002/VB.NET/ASP.NET. I have a Modal Dialog as PopUp window. I can create and close the PopUp. The below are the two scenarios when i need the PopUp. I am using JavaScript to create and close PopUp. 1) I need the PopUp to occur only the first time the page loads. Subsequent...

I am using OpenDatasource function to retrieve data(filename) from a #table ( using cursor, one row(filename) at a time) and process the contents of the text file..say n rows in a file. If the file has no contents(no rows), i get an error. How do i work around this?? I would like to insert the...

I am using a SP to update a nText column. The update is fine. The next column is a DateTime column..and in few cases the datetime col gets updated to NULL. The SP does not touch the DateTime col at all. I have looked for any triggers being fired..but none seem to exist. I have run trace to check...

Hello, I want to write the DBCC INPUTBUFFER output to a text file. I have created a temp table and the DBCC output is loaded into the temp table. The aim is to write the output to a text file to know the EventInfo of SPID. Any help would be appreciated. Thanks.........

I have nText and DateTime columns in a table. A stored procedure updates the nText col for X number of users. The stored procedure does NOT query the DateTime column. But for few users, only some records(not all records), the DateTime column is being set to NULL. Clearly, a trigger is being...

I am using SQLBase 7 database. I have a PROD database and a DEV database. The data in PROD database is till date. 1.When i try to copy(copy and paste in explorer)the .dbs file from PROD to DEV, i find that DEV database is not updated. Is there anything else i have to do after copying the .dbs...

I have to use the following query with subquery in CR6. I know i cannot use subqueries in CR. What would be the work around ?? The query below works in Crystal Query Designer. SELECT PERSONNEL."PERSONNELNO", PERSONNEL."PERSONNELNAME" FROM...

I refer tothe question i posted under " SqlBase and Java" on 12/8/03. Gupta website informs me that it is a problem with the JDBC driver and it has been fixed under the fixes for SqlBase 8.5. My question now is, would anybody know whether the JDBC driver used for SqlBase 8.5 be...

Hello, I am using SqlBase 7.0 with a Java application. An Amount column in a table(in SqlBase) was defined as Amount(8,2) with Decimal datatype. The java application used to access the database and fetch the data through a regular SQL "Select" query. I changed the column width and set...

Hi, I have CR6 on a network. The users access the CR6 on the network. Two of the users have their Export button enabled, but on clicking it nothing happens. No export dialog box appears. Am i missing any DLL?? Or is any DLL corrupted??? The other users accessing the CR6 on the same network have...

Hi...i am using SlqBase 6.0 and trying to change the length of the column with decimal datatype(from 8,2 to 10,2). I used unload command to unload the table into a .sql file, opened the file in notepad, changed the length, dropped the table and loaded the file back into sqlbase. I find that...