> ? Sorry, but underscores are very common in Firebird database table
> names and I've never found them hard to read.

In addition to the previous post, and at least partially off topic....

I always find I have to try really hard to seperate the tables from the
fields when underscores are used, especially when the outcome of my scrutiny
doesnt result in money in my pocket. This is a support group and my advice
is given with the best of intentions. What I expressed was my personal
opinion just as the reply poster expressed theirs (I prefer option 3), but
you can decide for yourself based on the following 3 identical queries from
the original post.

SELECT FIRST 10 SKIP 0 ticket.ticket_pid, ticket.ticket_no,
job_order.job_order_no, staff.staff_c_codename, oper.oper_c_name,
ticket.ticket_qty, ticket.ticket_size_code, ticket.ticket_rcv_date
FROM ticket , job_order , staff , oper
WHERE
oper.oper_pid=ticket.ticket_oper_pid
AND staff.staff_pid=ticket.ticket_rcv_staff_pid
AND job_order.job_order_pid=ticket.ticket_jo_pid
AND ticket.ticket_pid > '0'
ORDER BY ticket_no ;



SELECT FIRST 10 SKIP 0 TICKET.TICKET_PID, TICKET.TICKET_NO,
JOB_ORDER.JOB_ORDER_NO, STAFF.STAFF_C_CODENAME, OPER.OPER_C_NAME,
TICKET.TICKET_QTY, TICKET.TICKET_SIZE_CODE, TICKET.TICKET_RCV_DATE
FROM TICKET , JOB_ORDER , STAFF , OPER
WHERE
OPER.OPER_PID=TICKET.TICKET_OPER_PID
AND STAFF.STAFF_PID=TICKET.TICKET_RCV_STAFF_PID
AND JOB_ORDER.JOB_ORDER_PID=TICKET.TICKET_JO_PID
AND TICKET.TICKET_PID > '0'
ORDER BY TICKET_NO ;



SELECT FIRST 10 SKIP 0 TICKET.TICKETPID, TICKET.TICKETNO,
JOBORDER.JOBORDERNO, STAFF.STAFFCCODENAME, OPER.OPERCNAME,
TICKET.TICKETQTY, TICKET.TICKETSIZECODE, TICKET.TICKETRCVDATE
FROM TICKET , JOBORDER , STAFF , OPER
WHERE
OPER.OPERPID=TICKET.TICKETOPERPID
AND STAFF.STAFFPID=TICKET.TICKETRCVSTAFFPID
AND JOBORDER.JOBORDERPID=TICKET.TICKETJOPID
AND TICKET.TICKETPID > '0'
ORDER BY TICKETNO ;



Do yourself a favour, and read what my friend joel has to say about the
business we are in and the newsgroup style of debate.

http://www.joelonsoftware.com/articles/NotJustUsability.html

Dont forget to access the archives as well