| formatting [message #371884] |
Mon, 18 December 2000 05:30  |
geetha
Messages: 20
Registered: August 2000
|
Junior Member |
|
|
I HAVE A TABLE CALLED PRODECT IN THAT I HAVE n NUMBER OF FIELDS, THERE I WANTED TO CHOOSE ONLY PRODUCTNO, PRODUCTNAME, CATEGORY SO I JUST GO FOR FORMATTING LIKE
COLUMN PRODUCTNO FORMAT A15
COLUMN PRODUCTNAME FORMAT A15
COLUMN CATEGORY FORMAT A15
SET FEEDBACK ON
SELECT PRODUCTNO,PRODUCTNAME,CATEGORY FROM PRODUCT (WHERE CONDITION)
NOW MY QUESTION IS, WHEN I SEE THE OUTPUT, I DONT GET THE PRODUCT NO INSTEAD I GET ##### (BECAUSE OF FORMATTING), WHT IS THE PROBLEM AND HOW WILL I OVER COME FROM THIS. AND I NEED THE CORRESSPONDING PRODUCT NO TO BE DISPLAYED WITH THE ABOVE FORMAT.
THANKING U IN ADVANCE
B.GEETHA
|
|
|
|
| Re: formatting [message #371896 is a reply to message #371884] |
Mon, 18 December 2000 15:45  |
chandra
Messages: 31
Registered: October 2000
|
Member |
|
|
|
The reason behind getting ###### is, the width you gave to that particular column is not sufficient to hold the data in the formatted column. Try to change the width of the column and watch it working.
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
