• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 293
  • Last Modified:

space between each record

i am wanting to do a search, yet the results look too crapped when displayed. Do you know how to put a blank line between each record?

e.g.

Name       Car       Address             Tel

j.smith    BMW     33 highfields    01426563135

k.brown    clio    14 bank way      01458922669

f.allen    smart     69 the view    01454323562

any ideas?????
0
jdeverell
Asked:
jdeverell
1 Solution
 
DaniProCommented:
Whict report tools are you using?
0
 
jdeverellAuthor Commented:
i dont know what report tool i am using, as i know i am not using any!!
0
 
gletiecqCommented:
What I think DaniPro was asking was what tool you're using to view the data from the database.  Are you looking at the data with SQLAdvantage?  or perhaps ISQL?

Greg
0
Free Tool: Path Explorer

An intuitive utility to help find the CSS path to UI elements on a webpage. These paths are used frequently in a variety of front-end development and QA automation tasks.

One of a set of tools we're offering as a way of saying thank you for being a part of the community.

 
jdeverellAuthor Commented:
i believe i am using SQL Advantage.
0
 
gletiecqCommented:
In SQL Advantage, there should be a menu that will configure your ouptut window.  If it doesn't specifically allow for double spaced output, you can tell it to append an extra  CR/LF to the row separator.  Essentially, look for what the code is and duplicate it.

Hope this helps.

Greg
0
 
jdeverellAuthor Commented:
OK, but what command do i need to type into the SQL code?
0
 
jdeverellAuthor Commented:
Also Do you know how to transfer the results from an SQL script in to a excel spreadsheet.

currently this is this code which displays the results:

SQL -o cdmc.xls << EOF -w600
select DISTINCT CMS_JOBDEF.JOBNO, JOBNAME, MEMNAME, WDAYSTR, FROMTIME, DESCRIPT, CONDNAME, ROWTYPE, CONTROL
FROM CMS_JOBDEF, CMS_CON_J, CMS_CTL_J
WHERE CMS_JOBDEF.JOBNO = CMS_CON_J.JOBNO
AND CMS_CON_J.JOBNO = CMS_CTL_J.JOBNO
AND APPLIC = 'CDMC'
go
CR
EOF

cheers
~
0
 
alpmoonCommented:
Try this (I have added char(10) at the end of select list):

SQL -o cdmc.xls << EOF -w600
select DISTINCT CMS_JOBDEF.JOBNO, JOBNAME, MEMNAME, WDAYSTR, FROMTIME, DESCRIPT, CONDNAME, ROWTYPE, CONTROL, char(10)
FROM CMS_JOBDEF, CMS_CON_J, CMS_CTL_J
WHERE CMS_JOBDEF.JOBNO = CMS_CON_J.JOBNO
AND CMS_CON_J.JOBNO = CMS_CTL_J.JOBNO
AND APPLIC = 'CDMC'
go
CR
EOF



0

Featured Post

Free Tool: IP Lookup

Get more info about an IP address or domain name, such as organization, abuse contacts and geolocation.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now