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?????
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?????
Whict report tools are you using?
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
Greg
ASKER
i believe i am using SQL Advantage.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
OK, but what command do i need to type into the SQL code?
ASKER
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
~
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
~
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
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