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

Did you try putting the distinct values into a temp / separate table and then do count(*) or count(column)?

We are using Ascential 7.5, windows 2000 server. The error log says "Non-Clustered indexes are being rebuilt". Then Ascential aborts. No we did not turn on any debugging. Is there a way to do debugging in Ascential?

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

What do you want to insert into the database ?? Do you want to insert the checkbox.text or just a boolean value to check whether the checkbox was checked/not checked ??

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 have checked for defaults...none there. No i am not using VB...i have to do this in SQL. Is there a way i can capture the command / command name which kicks in the trigger / update ???

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

this is done as an in T-SQL code. No front end App is present. This code will be a part of a trigger.

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

Hello, One can copy data from one source table to another the following maner, Copy <cursor number> source table to <cursor number> destination table; e.g SQL> COPY EMP TO 2.EMPLOYEES; NOTE : THE DESTINATION TABLE MUST EXIST. If you have toconnect toanother DB and copy from another table...

Does your statement include a "where" clause too ?? or is it a simple "select * from <tablename>" ??

Did you try SQLTalk ?? Just point the Sql.ini file to where the .dbs file exists. Also give the path for Log files in sql.ini file. Le me know if this helps....

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

Hi Ken, I hope you can help me. 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 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...

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.&quot;PERSONNELNO&quot;, PERSONNEL.&quot;PERSONNELNAME&quot; FROM...

BigDogIV, Crystal reports may not be able to read your U2D*.DLL and U2F*.DLL. Make sure they are in System32 dir or in System dir. As a last resort i would remove the exicsting runtime files and load them again..... pls let me know if you can get them to work. regards, indoaryaan.

Hello repelsteelkie, Try using all DLL's in U2D*.DLL and U2F*.DLL. U2D*.DLL determine the esport destination. U2F*.DLL determine the export formats. Guess you can find the DLL's on another machine where this button is working. Let me know if this works. Regards, Indoaryaan.