Recent content by selavarti

hello, I am using Visio 2003 and I am trying to look for the option where there are command busttions, check boxes, combo boxes etc to create a dummie VB screen. I used them in 2002 and just can't find them in 2003. Can anyone please tell where is the option in 2003 Thanks

Thank you guys for the correction. Mufasa..the code seems to be correct..but it's in processing state for ever...I have to see why.

I am trying to update some fields in a table. But the condition for the update includes fields from other tables. Can some one please tell me what is wrong with this query. It says [1]: (Error): ORA-00933: SQL command not properly ended update ctrn set ctrn_cldt_clnt_id = 3002...

I just realised it and finished the job. So dumb of me. Thanks anyways :)

Hello, I have to trim trailing spaces on a feild on both sides. I did select TRIM(eqvn_name) as eqvn_name from eqvn where eqvn_name like '% '; eqvn_name is varchar I feel this is right. But after running TRIM function when I query to check if there are any with trailing spaces. It is...

Thank you.

And yes that field is Varchar

I am using SQL Navigator, but the database is in Orcale :) I am looking at the options you guys gave..thank you

Hello, I have to trim trailing spaces on a feild on both sides. I did select TRIM(eqvn_name) as eqvn_name from eqvn where eqvn_name like '% '; I feel this is right. But after running TRIM function when I query to check if there are any with trailing spaces. It is returning same set of...

I have written a count function that gives a reuslt of count of each client. How can I get he total of all the counts. Here is the SQL. select count(*) as Records, ctrn_cldt_clnt_id, ctrn_apply_code, ctrn_transaction_type_code_txt from ctrn where ctrn_cldt_clnt_id in (2201, 3002, 3014,5803...

Hi, I am giving a print command where the print style is landscape and the papaer size is 17"/ 8". but it's taking paper size as 11/8. can any one tell me what can i do to avoid this problem. thanks

Hi, Can any one please tell me how to set up a webpage in CSS so when given print command it prints in Legal size paper and in Lanscape. Thanks in advance

try this SELECt....where ((week_no & year) >= (10 & 2003)) &(week_no & year) <= (10 & 2004))

got it Thanks

Hi, I am writing a query to perform a search by keyword. the keyword is accepted from the text box in the form. I have written the condition as Select..... WHERE (((tbl_issues.issue_desc)=' % [forms]![frm_issues]![text38] % ')). But this query is not working. Can anyone tell me what's wrong...