Solved

BDE error: 12292 Non-blob column in table required to perform operation

Posted on 2002-07-22
12
1,783 Views
Last Modified: 2013-11-23
Hi experts,

I have an empty database (ACCESS). With test data I have tested the application but if I'd like to start the new application I get the error message:

BDE error: 12292 Non-blob column in table required to perform operation. (otherwise I found an interessant answer concerning this error at http://www.experts-exchange.com/questions/Q_10629401.html but the question was an other)

How can I catch this error better said by which way can I fill the first data in the database??

For other databases differs this first data filling??

Regards

Janos
0
Comment
Question by:kacor
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 8
  • 3
12 Comments
 
LVL 27

Expert Comment

by:kretzschmar
ID: 7171163
what kind of operation you want to do?
0
 

Expert Comment

by:kiranramesh
ID: 7171279
Hi Kacor,

Do you have a column in the table which is of a NON-BLOB data type and whose width exceeds 250 chars ???
If yes then you need to change that column to a blob field.
Else write a query to select all columns from that table.
Note : Name all the columns in the query
for example : Select code, name .... from table.
If the query Executes and fetched no records then check then BDE Settings in the local machine.

It has to work.

Regards
Kiran.
0
 
LVL 10

Author Comment

by:kacor
ID: 7171353
Hi Meikl and Kiran,

there are only simple fields with max 50 char or number data. After deleteing the last record will you get this message. Then I tried to open the application with a new empty database I've got the same message. This message appears before the first form creating so I can't catch it to use a try procedure to handle the exception

wbr

Janos
0
Independent Software Vendors: We Want Your Opinion

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

 
LVL 10

Author Comment

by:kacor
ID: 7171355
Sorry ...  
After deleteing the last record of the test data will you get this message

Janos
0
 
LVL 27

Expert Comment

by:kretzschmar
ID: 7171369
sounds, that you have to update the bde,
there is a bof/eof->empty table reported

go to

www.borland.com/devsupport/bde

and get the latest bde-update

meikl ;-)
0
 
LVL 10

Author Comment

by:kacor
ID: 7171428
Sorry ...  
After deleteing the last record of the test data will you get this message

Janos
0
 
LVL 10

Author Comment

by:kacor
ID: 7171444
Meikl,

this is the D6 engine and no update for. You have rigth I'm trying to get existing info from other datasets too and probably I'd like to get some info from this empty dataset. I will look at

Regards

Janos
0
 
LVL 10

Author Comment

by:kacor
ID: 7172241
I have tested again the mentioned dataset. If it has min. 1 record no error message is displayed.
There are two possibilities:
1. The easier way : to have everytime min. one record e.g. to have a test record while installing - this runs
2. The harder way: I have to solve how can I catch the BDE error message this would be the good solution but unfortunately my knowlegde now isn't sufficient to solve this question :-(

So if somebody has idea what have I to do please support me. As my points will increase so I can give more points for the good solution

Janos
0
 
LVL 27

Accepted Solution

by:
kretzschmar earned 135 total points
ID: 7172308
janos,

the bde is independent from any delphi-version
well, i don't know which bde version is shipped with d6
as i don't have d6, but i guess a bde update could solve the problem.

btw. i use d5 with bde 5.01 and cannot reproduce your problem.

other question:
do you use the access-native driver or do u use odbc?
any thought about to use ado?

meikl ;-)
0
 
LVL 10

Author Comment

by:kacor
ID: 7176553
I'm now using ODBC-connection. In the near future I'd like to learn the ado technolgy

wbr

Janos
0
 
LVL 10

Author Comment

by:kacor
ID: 7309715
Thanks for your aid

Janos
0
 
LVL 10

Author Comment

by:kacor
ID: 7314412
Thanks for your help. I'd like to close this question

wbr

Janos
0

Featured Post

Technology Partners: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Introduction The parallel port is a very commonly known port, it was widely used to connect a printer to the PC, if you look at the back of your computer, for those who don't have newer computers, there will be a port with 25 pins and a small print…
Introduction I have seen many questions in this Delphi topic area where queries in threads are needed or suggested. I know bumped into a similar need. This article will address some of the concepts when dealing with a multithreaded delphi database…
In a recent question (https://www.experts-exchange.com/questions/29004105/Run-AutoHotkey-script-directly-from-Notepad.html) here at Experts Exchange, a member asked how to run an AutoHotkey script (.AHK) directly from Notepad++ (aka NPP). This video…

733 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question