| Question: |
I am trying to open a query using SQLQuery that
selects rows from a table that has a char(1024) field
but it only returns 255 characters at
most |
| Answer: |
This is a limitation from the DBLIB driver, and
it seems as M$ won't fix it either. A workaround is to cast a
char as TEXT. This will work in cases where you only read the
resultset forward, but not if you read rows randomly from the
result set. |
|
|
| Question: |
Is the source code included? |
| Answer: |
Source code is included in site
licence. |
| |
|
| Question: |
I get the following exception message using
blobs: "Undefined SQL Server error:7134".
This only occurs for TEXT fields, not for VARCHAR
fields. What is the problem? |
| Answer: |
This is caused by a problem in SQL Server 6.5
Servicepack 3. Please upgrade to the latest
servicepack and it should disappear. |
| |
|
| Question: |
When I tried to install the library SQLQry40.bpl,
I received the following error message: The
procedure entry point @Db@TDataSet@GetBlobFieldData$qqrir25System@%DymanicArray$tuc%
could not be located in the dynamic link library
Vcldb40.bpl Can you tell me what the problem
is? |
| Answer: |
Install the latest UpdatePack for Delphi 4 |
| |
|
| Question: |
Can TSQLQuery be used in threads? |
| Answer: |
TSQLQuery has been tested within
several parallell threads and worked well. |
| |
|
| Question: |
Are there any limitations on distribution of
my .exe programs? |
| Answer: |
No, but you must follow Microsoft´s
licencing terms for the SQL Client DLL´s |
| |
|
| Question: |
Can I read and update TEXT and IMAGE fields? |
| Answer: |
Yes. |
| |
|
| Question: |
Which versions of SQL Server do you support? |
| Answer: |
SQLQuery works with SQL 6.0, 6.5, 7.0 and 2000. It
is also known to work with v4.2 as there are
customers using this. Note that there are some features from 7.0
and up that are not supported by the driver we use (DBLIB).
You won't be able to retrive char och varchar field that are
greater than 255 chars, data types NCHAR, NVARCHAR,
NTEXT and UniqueIdentifier are not supported and the
driver doesn't support identifiers (table or field names) that
are longer than 30 characters. |
| |
|
| Question: |
How do I minimize page and row locking in SQL
Server? |
| Answer: |
Use the Option AutoReadAhead to minimize page
locking. With very large result sets you can use
the NOLOCK optimizer hint in the SELECT statement.
But remember that this results in "dirty
reads" so it should be used with care. |
| |
|
| Question: |
Can SQLQuery be used with Stored Procedures? |
| Answer: |
Yes |
| |
|
| Question: |
Can I use compound statements (SQL batches)
with SQLQuery. |
| Answer: |
Yes, this works very well, but you can only
return one result set. |
