simple query failing on specific table with varified data.

Article View: comp.lang.pascal.delphi.databases

Article #14

Back to comp.lang.pascal.delphi.databases Previous Next

#14

From: Andy Seabrook
Date: Sun, 08 Oct 2000 00:00

28 lines
2085 bytes

New to Delphi!
Can anyone help with the following problem.
I run a SQLBase dbms for which I am considering writing client interfaces 
in delphi. Innitial consideration has shown a problem. Using ODBC in 
database explorer, one of my more important tables (company) inexplicably 
fails to returns any records unyet all other tables are fine and SQLBase's 
own tools show that the data has no apparant corruption and severall 
thousand records. Also using the "enter SQL" tab to try the obvious simple 
query against the table i.e. "select * from company" causes a general 
protection fault with the following output. The same also happens on 
setting TQuery objects active parameter to true (no problem with other 
tables)
Anybody able to help with this please email me your thoughts 
home@andyseabrook.fsnet.co.uk 

GPF output for TQuery
DELPHI32 caused an invalid page fault in
module KERNEL32.DLL at 015f:bff87ed0.
Registers:
EAX=c002f8d4 CS=015f EIP=bff87ed0 EFLGS=00010202
EBX=0098fa58 SS=0167 ESP=00890000 EBP=00890078
ECX=816a9ae0 DS=0167 ESI=816aaba8 FS=3267
EDX=388b5708 ES=0167 EDI=4da43458 GS=0000
Bytes at CS:EIP:
ff 75 08 8b 7d 0c 57 ff 75 10 6a 01 e8 ca 07 00 
Stack dump:
4da43458 816aaba8 0098fa58 00000000 00000000 00000000 00000000 00000000 
00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000

Technical Details

Message-ID: <8rqbf3$ujf$1@news5.svr.pol.co.uk>

Path: arc1-ca.pugleaf.net!unknown!not-for-mail

Show Full Headers

Complete Article Headers

X-Google-Language: ENGLISH,ASCII-7-bit
X-Google-Thread: ffff5,ccdb7f9abd5b5144,start
X-Google-Attributes: gidffff5,public
X-Google-Thread: 115d96,ccdb7f9abd5b5144,start
X-Google-Attributes: gid115d96,public
From: home@andyseabrook.fsnet.co.uk (Andy Seabrook)
Subject: simple query failing on specific table with varified data.
Date: 2000/10/08
Message-ID: <8rqbf3$ujf$1@news5.svr.pol.co.uk>
X-Deja-AN: 679007952
X-Complaints-To: abuse@theplanet.net
X-Trace: news5.svr.pol.co.uk 971026723 31343 62.137.85.50 (8 Oct 2000 17:38:43 GMT)
Organization: Your Company
User-Agent: Xnews/03.09.22
NNTP-Posting-Date: 8 Oct 2000 17:38:43 GMT
Newsgroups: comp.lang.pascal.delphi.databases,borland.public.delphi.database