Re: converting Access query to SQL (for oracle) [message #373010] |
Thu, 22 March 2001 07:30 |
Prem
Messages: 79 Registered: August 1998
|
Member |
|
|
Brad, try this SQL
SELECT TBL_CIT.CIT_ID,
TBL_CIT_DESC.CIT_DESC,
TBL_CIT_INTERNAL_NOTES.CIT_INTERNAL_NOTES,
TBL_CIT_RESOLUTION.CIT_RESOLUTION,
TBL_CIT_WORK_LOG.CIT_WORK_LOG,
TBL_CIT_WORKAROUND.CIT_WORKAROUND,
TBL_CIT.ABSTRACT,
TBL_CIT.CIT_NUMBER
FROM TBL_CIT,
TBL_CIT_DESC,
TBL_CIT_INTERNAL_NOTES,
TBL_CIT_RESOLUTION,
TBL_CIT_WORK_LOG,
TBL_CIT_WORKAROUND
WHERE TBL_CIT.CIT_ID = TBL_CIT_DESC.CIT_ID (+)
AND TBL_CIT.CIT_ID = TBL_CIT_INTERNAL_NOTES.CIT_ID (+)
AND TBL_CIT.CIT_ID = TBL_CIT_RESOLUTION.CIT_ID (+)
AND TBL_CIT.CIT_ID = TBL_CIT_WORK_LOG.CIT_ID (+)
AND TBL_CIT.CIT_ID = TBL_CIT_WORKAROUND.CIT_ID (+)
hth
Prem :)
|
|
|
|
Re: converting Access query to SQL (for oracle) [message #373043 is a reply to message #373010] |
Fri, 23 March 2001 13:00 |
Brad
Messages: 12 Registered: April 1999
|
Junior Member |
|
|
Actually your previous SQL statement worked. I found out there is a buffer size in my Perl module Win32::ODBC that was killing things if it hit any record with collumn data over 10K in size. Increasing this buffer to 50K allowed all records to be retrieved. Thanks MUCH for your help!
|
|
|
Re: converting Access query to SQL (for oracle) [message #373044 is a reply to message #373010] |
Fri, 23 March 2001 13:01 |
Brad
Messages: 12 Registered: April 1999
|
Junior Member |
|
|
Actually your previous SQL statement worked. I found out there is a buffer size in my Perl module Win32::ODBC that was killing things if it hit any record with collumn data over 10K in size. Increasing this buffer to 50K allowed all records to be retrieved. Thanks MUCH for your help!
|
|
|