MS SQL oddity -- any clues?

sun...@rotfl.com (C. Myron Ware)

Delphi Developer

Wed, 18 Jun 1902 08:00:00 GMT

D4/MS SQL oddity -- any clues?

Hi all,
I have an MS SQL-7 table (Usage) with 3 fields (ACCOUNT, FILES, MB)
using 'SELECT * FROM Usage' in MS Query analyzer shows the three
fields and the rows in the Usage table. Using the same SQL statement
in a TQuery connecting to the same table will show only the FILES and
MB fields and their data. If the TQuery SQL is 'SELECT ACCOUNT from
Usage' I get a blank column header with lots of blank rows. A join
using another table on the ACCOUNT field will work, returning the
matching rows, but still no ACCOUNT column. I'm using Delphi4 C/S
with update pack3 installed. Any clues?
Thanks,
Myron
--------------------------------------------------------------------------
C. Myron Ware Senior Prog/Analyst, CNE
http://www.geocities.com/Colosseum/1370/

C. Myron Wa

Delphi Developer

Wed, 18 Jun 1902 08:00:00 GMT

Re:D4/MS SQL oddity -- any clues?

As with most things, the solution was a simple one once it was
found. The table in question stated that the ACCOUNT field was an
nvarchar. In another table that joins this one, the ACCOUNT field is
simply a varchar. I changed the Data Type to varchar and Delphi
could see the column and all was right in the world. I saved a trace
from the ODBC SQL log if you guys would like to take a look. It shows
that 3 columns were recognized and returns their names, then it begins
returning info for only two. Is the nvarchar a non-supported data
type for the BDE? It was also odd that the join between the tables
worked, even though the fieldbyname on the nvarchar wouldn't. These
are things that make you go 'Hmmmm...'
Myron

sun...@rotfl.com (C. Myron Ware) wrote:

Quote

>Hi all,
> I have an MS SQL-7 table (Usage) with 3 fields (ACCOUNT, FILES, MB)
>using 'SELECT * FROM Usage' in MS Query analyzer shows the three
>fields and the rows in the Usage table. Using the same SQL statement
>in a TQuery connecting to the same table will show only the FILES and
>MB fields and their data. If the TQuery SQL is 'SELECT ACCOUNT from
>Usage' I get a blank column header with lots of blank rows. A join
>using another table on the ACCOUNT field will work, returning the
>matching rows, but still no ACCOUNT column. I'm using Delphi4 C/S
>with update pack3 installed. Any clues?

--------------------------------------------------------------------------
C. Myron Ware Senior Prog/Analyst, CNE
http://www.geocities.com/Colosseum/1370/

Other Threads

1. D4:MS-SQL 7.0 without BDE

2. MS SQL Cursors and D4

3. D4 C/S and MS SQL 6.5 Need Help, BDE Crashes

4. Update Lock with MS SQL 7 and D4/TQuery

5. D4 C/S & MS SQL 7.0

6. BDE, MS SQL Server and DLL in D4 c/s

7. problem w/ d4 and ms sql server 7

8. Need help with DateTime D4 / MS SQL 7.0

9. BDE 5.10 shows less data that SQL Server 7 (Newbie needs a clue)

10. MS-SQL 6.5 & MS-SQL 2000