Max. length of SQL string in openrecordset statement 
Author Message
 Max. length of SQL string in openrecordset statement

(sorry for my bad english)

I tried to select records from table in Access database. I have VB 5.0 with

The statement is:

set data1.recordset = database.openrecordset("Select A, B, C from tbname
where A=a order by C asc, D desc")

When lenght of string "Select ... " is smaller then 261, then it is OK. But
when lenght is bigger then 260, vb send message about error in string. Error
description is always the same, but string, which is shown in
err.description, not. If I want to create a select longer then 260, I must
use a querydef. There is no problem.

Does anybody know more about this problem?


Mon, 11 Sep 2000 03:00:00 GMT  
 [ 1 post ] 

 Relevant Pages 

1. Max Length of SQL statements ??

2. VB3 and ACCESS 2 - SQL max string length?

3. Finding the length of a string in an SQL statement

4. String length limits hit in SQL statement

5. Maximum Length of characters for SQL statement (or string)

6. Help me please - Max String length 2 Billion chars - I don't think so

7. max string length, vbs

8. max string length of formulas

9. Max String Length when using PESetSelectionFormula API?

10. what is the max length of string ?

11. way to find max var char field lengths of fields in SQL Server table

12. SQL 7 field length max


Powered by phpBB® Forum Software