Link to home
Start Free TrialLog in
Avatar of jdeverell
jdeverell

asked on

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?????
Avatar of DaniPro
DaniPro
Flag of Italy image

Whict report tools are you using?
Avatar of jdeverell
jdeverell

ASKER

i dont know what report tool i am using, as i know i am not using any!!
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
i believe i am using SQL Advantage.
ASKER CERTIFIED SOLUTION
Avatar of gletiecq
gletiecq

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
OK, but what command do i need to type into the SQL code?
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
~
Avatar of alpmoon
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