Solved

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

Posted on 2002-07-22
12
1,763 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:János Szabó
  • 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:János Szabó
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
ScreenConnect 6.0 Free Trial

Discover new time-saving features in one game-changing release, ScreenConnect 6.0, based on partner feedback. New features include a redesigned UI, app configurations and chat acknowledgement to improve customer engagement!

 
LVL 10

Author Comment

by:János Szabó
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:János Szabó
ID: 7171428
Sorry ...  
After deleteing the last record of the test data will you get this message

Janos
0
 
LVL 10

Author Comment

by:János Szabó
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:János Szabó
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:János Szabó
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:János Szabó
ID: 7309715
Thanks for your aid

Janos
0
 
LVL 10

Author Comment

by:János Szabó
ID: 7314412
Thanks for your help. I'd like to close this question

wbr

Janos
0

Featured Post

Does Powershell have you tied up in knots?

Managing Active Directory does not always have to be complicated.  If you are spending more time trying instead of doing, then it's time to look at something else. For nearly 20 years, AD admins around the world have used one tool for day-to-day AD management: Hyena. Discover why

Question has a verified solution.

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

Suggested Solutions

This article explains how to create forms/units independent of other forms/units object names in a delphi project. Have you ever created a form for user input in a Delphi project and then had the need to have that same form in a other Delphi proj…
Objective: - This article will help user in how to convert their numeric value become words. How to use 1. You can copy this code in your Unit as function 2. than you can perform your function by type this code The Code   (CODE) The Im…
This Micro Tutorial demonstrates using Microsoft Excel pivot tables, how to reverse engineer competitors' marketing strategies through backlinks.
Email security requires an ever evolving service that stays up to date with counter-evolving threats. The Email Laundry perform Research and Development to ensure their email security service evolves faster than cyber criminals. We apply our Threat…

773 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