Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations Rhinorhino on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Recent content by royjimenez

  1. royjimenez

    NLS_LANG Problem

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

    NLS_LANG Problem

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

    NLS_LANG Problem

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

    Rows retrieving

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

    Need a Professional here

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

    Move a database to new hard drive

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

    Using a Like condition

    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]
  8. royjimenez

    Complex SQL Query?? I can't seem to come up with the logic.

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

    Triggers and replication

    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]
  10. royjimenez

    Primary Key on Replication

    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]
  11. royjimenez

    open Word document with OLE control

    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 =...
  12. royjimenez

    call powerbuilder function from C++

    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]
  13. royjimenez

    Selectblob

    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]
  14. royjimenez

    Changing status of a row/column

    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]
  15. royjimenez

    how to make a trigger do more iterations

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

Part and Inventory Search

Back
Top