Search found 7 matches

by belvasis
07.03.2011, 13:08
Forum: 6.6 - stable
Topic: Access violation with ExecSQL
Replies: 7
Views: 1060

Hm...that's something i don't understand. In Version 6.5.1 there was an protocol "mssql" and there is a driver MSSqlServer7 in the zeos source. Was this protcol removed? ADO is something i don't want to use. So i think i have to use the older version with c++. The funny thing is, that i up...
by belvasis
06.03.2011, 21:08
Forum: 6.6 - stable
Topic: Access violation with ExecSQL
Replies: 7
Views: 1060

I tried it with an SQLServer 2008 Database. I have no separate test application because this is a really simple use case. After the programm starts, it writes a simple status information to a specific table. This is where the error occurs.
by belvasis
06.03.2011, 12:09
Forum: 6.6 - stable
Topic: Access violation with ExecSQL
Replies: 7
Views: 1060

Yes....

...you are right, of course. I set the connection in code but missed it here in the code fragment of my post . And the connection object ist valid and connected. I switched back to version 6.5.1 now and all works as expected, without changing any code. The correct code is: TZQuery* pQuery = new TZQu...
by belvasis
05.03.2011, 15:22
Forum: 6.6 - stable
Topic: Access violation with ExecSQL
Replies: 7
Views: 1060

Access violation with ExecSQL

Hi, i use version 6.5.1 of zeos since five years now and had only little problems. Now i decided to upgrade to version 6.6 stable. I did it and now nothing works anymore :( Until now is simply used the following in C++ to execute a statement: TZQuery* pQuery = new TZQuery(Application); pQuery->SQL->...
by belvasis
13.11.2006, 13:23
Forum: Bug Reports
Topic: Handling of varchar/char - Fields
Replies: 5
Views: 3842

I use MSSQL 2000/2005. If i do the query using the EnterpriseManager the spaces are still part of the Resultset, so i don't think the SQLServer removes the spaces from the database. If i use ODBC i'm also able to test for the blanks. But moving to ODBC is not an option...
by belvasis
13.11.2006, 12:21
Forum: Bug Reports
Topic: Handling of varchar/char - Fields
Replies: 5
Views: 3842

Handling of varchar/char - Fields

Hi, i have a simple question: I have a varchar or char field and the data only contains blanks: STR_FIELD = ' ' If i use pQuery.FieldByName('STR_FIELD').AsString the result is an empty string ' ' . That means, the blank will be completly ignored. If i change the type of the field to text, the FieldB...
by belvasis
13.11.2006, 08:23
Forum: 6.5.1 (alpha) - 6.6.x (beta)
Topic: Fields containing spaces only
Replies: 0
Views: 547

Fields containing spaces only

Hi, i have a problem and don't know how to fix it. I have a Column that contains a single space character (' '). If i access the field via ZQuery the values is always empty (''). If i chagen the ' ' to any other character the value of the field is correct. The problem is, i need to know that the fie...