Search results for query: *

LKBrwnDBA , but I set it as u told me but it is not working. I supposed the same thing but the problem is alive... Thanks for your time. SantaMufasa I will see this option. If u can fix the problem I will let you know. Thanks for your time. The life is too short to cry and long enough to...

HI! ( thank for answering quickly ) I've used this NLS_LANG values: AMERICAN_AMERICA.WE8MSWIN1252 SPANISH_SPAIN.WE8ISO8859P1 AMERICA_AMERICAN.WE8ISO8859P15 ( I got INVALID NLS.. ) But, I can't see my special characters. If I run this from the server (unix): select 'cáll' CALL from dual; I...

Hi! I have an Oracle Database and I can save special characters into my db ( for instance á, é, ñ ... ). I am using Oracle 8.1.7 in an unix server (SUN). I can see all my data with special character into my db... if I run a sql "Select name from employees" the resultset can be read as...

I am not sure what u are trying to do, 'cause it's a bad idea to perform a sql to retrieve too many rows. I think u should keep your data retrieved as short as u can. Think if u have 100 users trying to execute your sql. Regards. The life is too short to cry and long enough to try it...

I have some time with no use pb. But I think u have a problem when you are using parameters when u want to create a sql dynamicly. If it is your problem, write me 'cause I can help u, 'cause I made some routines to perform this. Regards. The life is too short to cry and long enough to try...

I think it's not a good idea, u should install a new hard disk in your server if u don't have enough space. Regards The life is too short to cry and long enough to try it... God bless us. [thumbsup2]

hi! you should make a new table to keep OS data, 'cause u will avoid more problems later. Regards The life is too short to cry and long enough to try it... God bless us. [thumbsup2]

u should capture only startdate: to capture today calls : select count(*) from mytable where startDate >= '2004-01-01' and startDate < '2004-01-02' and finishDate < '2004-01-02' Now, u have to capture the calls which started &quot;yesterday&quot; and finish...

u should explain more what u want, 'cause i have worked with trigeers and in many times i've needed to set them NOT FOR REPLICATION, but i am not sure if it's what u want to know. Regards The life is too short to cry and long enough to try it... God bless us. [thumbsup2]

it's required and u will need a global unique identifier. What kind of replication are u talking about ? The life is too short to cry and long enough to try it... God bless us. [thumbsup2]

Here goes an example: ( u should look up CONNECTTONEWOBJECT ) Regards. datastore lds_control, lds_detalle integer li_resultado long ll_fila = 10, ll_total, i, j, ll_totdet string ls_ente, ls_monant, ls_moneda OLEObject lobjExcel lobjExcel = CREATE OLEObject li_resultado =...

U can create a COM Object and u can access this object from differents tools like word, excel, delphi, visual basic, etc... Regards The life is too short to cry and long enough to try it... God bless us. [thumbsup2]

and if u use ONLY a SELECTBLOB with no Cursor, what happen ? It's 'cause I've worked with images and i haven't had problems. Let me know your results. The life is too short to cry and long enough to try it... God bless us. [thumbsup2]

hi! something could be executing before your last getitemstatus, 'cause your code seems good. The life is too short to cry and long enough to try it... God bless us. [thumbsup2]

CODE NAME PARENT 1 John 0 2 Ann 0 3 Luis 0 4 Nick 1 5 Abril 4 6 Carmen 3 .... I have done some data models with this structure. You can use it for designing trees. if u are on the row Nick ( CODE 4 and PARENT 1 ) , you have to go through PARENT until it...

i am sending u some code, i hope it helps u. ************************************************ SELECT @pub_qualified_name=QUOTENAME(@subscriber_db)+'.'+QUOTENAME(@tableowner)+'.'+QUOTENAME(@tablename) SELECT...

if u want to improve the performance in your table, u could use particioned views. I try to avoid the null fields, I like using a default value for each field when it's possible 'cause I don't have to use isnull function ( or similars ) . Regards. The life is too short to cry and long enough...

HI! bluenoseer wrote that he has 10000 rows per day, i guess that he needs to improve the performance in his table. bluenoseer: I agree with them, I think u should review your indexes, later, u should be your queries for understanding if these queries are using indexes. If u have a huge...

I have done this update mytable set mykey = mykey + 1 where ... select mykey into @mykey from mytable ... if u use the update u will lock it. Regards The life is too short to cry and long enough to try it... God bless us. [thumbsup2]

look up this in the help &quot;partitioned views&quot; regards The life is too short to cry and long enough to try it... God bless us. [thumbsup2]