Results 1 to 4 of 4

Thread: update problem

  1. 11-17-2005, 09:56 PM #1
    sql
    sql is offline Registered User
    Join Date
    Jul 2003
    Posts
    421

    update problem

    Hi all,
    yesterday, I update from SQl 2000 package 1 to server package 4, I did not change anything. today, I found out, one of my column sequence have a lot of empty space.
    1)the frontend is java it work fine.
    2) the basic select work fine
    select sequence
    from Sec02
    where Name='Ck/HK/SF203/02'
    it display the sequence, but if I open the table and click return all rows , a lot of row is empty, Why??
    ________
    Chevrolet hhr
    Last edited by sql; 03-06-2011 at 01:54 AM.
    Reply With Quote Reply With Quote
  2. 11-18-2005, 10:09 AM #2
    rmiao
    rmiao is offline Registered User
    Join Date
    Sep 2002
    Posts
    5,938
    What do you mean 'row is empty'? There are room for you to add new rows.
    Reply With Quote Reply With Quote
  3. 11-18-2005, 10:25 AM #3
    sql
    sql is offline Registered User
    Join Date
    Jul 2003
    Posts
    421
    Hi , sorry, the begin of the column is empty, wnat you open the table you can see anything, but want you select you can see it, is fine when you select it from frontend( handle by jsp)
    what is the problem?
    ________
    Angelina jolie pic
    Last edited by sql; 03-06-2011 at 01:55 AM.
    Reply With Quote Reply With Quote
  4. 11-18-2005, 01:21 PM #4
    rmiao
    rmiao is offline Registered User
    Join Date
    Sep 2002
    Posts
    5,938
    Don't understand your issue. Can you post same samples? What did you see in query analyzer, from app, and in enterprise manager for those rows?
    Reply With Quote Reply With Quote
« Previous Thread | Next Thread »

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  

Forum Rules