Solved

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

Posted on 2002-07-22
12
1,752 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
  • 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
 
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
Is Your Active Directory as Secure as You Think?

More than 75% of all records are compromised because of the loss or theft of a privileged credential. Experts have been exploring Active Directory infrastructure to identify key threats and establish best practices for keeping data safe. Attend this month’s webinar to learn more.

 
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

Is Your Active Directory as Secure as You Think?

More than 75% of all records are compromised because of the loss or theft of a privileged credential. Experts have been exploring Active Directory infrastructure to identify key threats and establish best practices for keeping data safe. Attend this month’s webinar to learn more.

Question has a verified solution.

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

Suggested Solutions

Title # Comments Views Activity
indy Tmemory stream non latin charcter issue 2 98
Unique identifier on a terminal server (rdp) 4 46
DBGrid or StringGrid ? 6 68
Graphics32 under Delphi 10.1 Berlin 2 36
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…
In my programming career I have only very rarely run into situations where operator overloading would be of any use in my work.  Normally those situations involved math with either overly large numbers (hundreds of thousands of digits or accuracy re…
This Micro Tutorial will give you a basic overview how to record your screen with Microsoft Expression Encoder. This program is still free and open for the public to download. This will be demonstrated using Microsoft Expression Encoder 4.
With the power of JIRA, there's an unlimited number of ways you can customize it, use it and benefit from it. With that in mind, there's bound to be things that I wasn't able to cover in this course. With this summary we'll look at some places to go…

911 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

Need Help in Real-Time?

Connect with top rated Experts

21 Experts available now in Live!

Get 1:1 Help Now