• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 1938
  • Last Modified:

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

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
kacor
Asked:
kacor
  • 8
  • 3
1 Solution
 
kretzschmarCommented:
what kind of operation you want to do?
0
 
kiranrameshCommented:
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
 
kacorretiredAuthor Commented:
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
Upgrade your Question Security!

Your question, your audience. Choose who sees your identity—and your question—with question security.

 
kacorretiredAuthor Commented:
Sorry ...  
After deleteing the last record of the test data will you get this message

Janos
0
 
kretzschmarCommented:
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
 
kacorretiredAuthor Commented:
Sorry ...  
After deleteing the last record of the test data will you get this message

Janos
0
 
kacorretiredAuthor Commented:
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
 
kacorretiredAuthor Commented:
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
 
kretzschmarCommented:
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
 
kacorretiredAuthor Commented:
I'm now using ODBC-connection. In the near future I'd like to learn the ado technolgy

wbr

Janos
0
 
kacorretiredAuthor Commented:
Thanks for your aid

Janos
0
 
kacorretiredAuthor Commented:
Thanks for your help. I'd like to close this question

wbr

Janos
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Get expert help—faster!

Need expert help—fast? Use the Help Bell for personalized assistance getting answers to your important questions.

  • 8
  • 3
Tackle projects and never again get stuck behind a technical roadblock.
Join Now