| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Size Limit for ADO query?
We are running VB 6.0 using ADO to connect to an Oracle backend. It seems continuations are limited to about 24 lines, so my rathe large query is strung out hundreds of bytes lengthwise. I'm getting an Oracle -923, from keyword not found where expecte error. The query runs in Toad when I take out the " " & _ continuatio characters so I think it's ok. Is there a byte restriction on the length of the ResultSet.ope command, or a line length at which the query may be getting truncated? Th -- ces ----------------------------------------------------------------------- cesw's Profile: http://www.excelforum.com/member.php...fo&userid=2711 View this thread: http://www.excelforum.com/showthread.php?threadid=46675 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Limit the size of a cell | Excel Discussion (Misc queries) | |||
| excel size limit? | Excel Discussion (Misc queries) | |||
| File size limit | Excel Discussion (Misc queries) | |||
| Cell size? Or size limit for Text data type? | Excel Discussion (Misc queries) | |||
| worksheet size limit | Excel Discussion (Misc queries) | |||
![cesw[_3_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Threaded Mode
