edpmatrix
Posts: 3
|
| Posted: 08/03/2007, 3:53 AM |
|
I'm using MS SQL 2005 + ASP +CCS .3.2 and I had many problems with query builder and buided query.
The first is that if I put in query more table linked trought field that are not for the select the alias name is not created in the <PKFields> section of the cpp file and the code in
function InitCachedColumns and in the form Show Method is wrong.
For converted project and in the case some tables are removed from original query this problem is solved only manualy removing from cpp file of the wrong <PKFields> row.
In every case you have to recreate the link in query builder making selection of every PK linked field if there are field with the same name in more tables.
Other problem is making a 'WHERE ... IN(.....)' filter over a table where the condition is imported from a Session variable. I tray every way but finaly i had to delete filter from visual query and put it in the beforebuildselect event and so it is working. Is possible that the problem is that the filed in the table to look for is an integer and the IN(...) list is a string and this fact make wrog code in automatic construction?
|
 |
 |
mamboBROWN
Posts: 1713
|
| Posted: 08/05/2007, 8:08 PM |
|
edpmatrix
Have you contacted support about these issues??
|
|
|
|
|
