Problem with TMSQuery SQL Generator after upgrading to v4

DWORD · Post by **DWORD** » Thu 25 Oct 2007 10:52

I have some TMSQuery in my project.
After installing v4 problems appear.

SQL='select f1,f2,f3,DOCDATE from DOCHEADS where f4=:parameter1'.

I press MSQuery Editor->SQLGenerator.GetFields.
But "Update Fields" list is empty.

Antaeus · Post by **Antaeus** » Thu 25 Oct 2007 14:04

I could not reproduce the problem.
Please provide exact steps to reproduce the problem from scratch, or send us a complete small sample at sdac*crlab*com to demonstrate it.

Also supply me the following information:
- exact version of your IDE;
- exact versions of SDAC (version 4 and previous version). You can see it in the About sheet of TMSConnection Editor;
- exact version of SQL Server and client for both SDAC versions. You can see it in the Info sheet of TMSConnection Editor;
- script to create the DOCHEADS table.

DWORD · Post by **DWORD** » Thu 25 Oct 2007 22:14

The problem is same in the new project with Form1, MSConnection1 and MSQuery1 only!

MSConnection.Database:="Northwind"
MSQuery.SQL:="select * from customers"

Borland Delphi Enterprise version 6.0(build 6.240) Update pack 2
4.30.0.12 for Delphi 6 (v3 was many different versions with no problems. I was trying v4.10 and has problem)
Microsoft SQL Server: 07.00.0961
Microsoft OLE DB Provider for SQL Server: 08.00.1117

Antaeus · Post by **Antaeus** » Fri 26 Oct 2007 13:58

Thank you for information. We have reproduced the problem. The investigation of the problem is in progress. As soon as we solve the problem we will let you know.

Antaeus · Post by **Antaeus** » Mon 29 Oct 2007 12:23

We have fixed the problem. This fix will be included in the next SDAC build.

DWORD · Post by **DWORD** » Mon 29 Oct 2007 15:15

Thank you...
What is your plan about date that build released?
Where can I find the v3 now? I must to build my project today...

Antaeus · Post by **Antaeus** » Tue 30 Oct 2007 07:41

Please send us your registration information to sdac*crlab*com.