?
Solved

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

Posted on 2002-07-22
12
Medium Priority
?
1,822 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 405 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

Industry Leaders: 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

A lot of questions regard threads in Delphi.   One of the more specific questions is how to show progress of the thread.   Updating a progressbar from inside a thread is a mistake. A solution to this would be to send a synchronized message to the…
In this tutorial I will show you how to use the Windows Speech API in Delphi. I will only cover basic functions such as text to speech and controlling the speed of the speech. SAPI Installation First you need to install the SAPI type library, th…
Sometimes it takes a new vantage point, apart from our everyday security practices, to truly see our Active Directory (AD) vulnerabilities. We get used to implementing the same techniques and checking the same areas for a breach. This pattern can re…
In this video, Percona Director of Solution Engineering Jon Tobin discusses the function and features of Percona Server for MongoDB. How Percona can help Percona can help you determine if Percona Server for MongoDB is the right solution for …
Suggested Courses
Course of the Month7 days, 22 hours left to enroll

765 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