Delphi Pages Forums  

Go Back   Delphi Pages Forums > Delphi Forum > General

Lost Password?

Reply
 
Thread Tools Display Modes
  #1  
Old 04-03-2001, 07:47 AM
Mirek Mirek is offline
Junior Member
 
Join Date: Apr 2001
Posts: 2
Default BDE : Non-blob column in table required to perform operation

Helo
I use tTable component to access MS SQL 2000 using BDE. There are 2 tTable component connected in master/detail relation. When add new record to master table I receive following error:
EDBEngine error 12292
"Non-blob column in table required to perform operation"
What is wrong?
Regards
Mirek
Reply With Quote
  #2  
Old 04-03-2001, 07:56 PM
digitiger digitiger is offline
Senior Member
 
Join Date: Jan 2001
Posts: 716
Default RE: BDE : Non-blob column in table required to perform operation

what is the field structure of your tables and what is the datatype of master field ?
post them and i think your problem can be solved
Reply With Quote
  #3  
Old 04-05-2001, 07:43 AM
Mirek Mirek is offline
Junior Member
 
Join Date: Apr 2001
Posts: 2
Default RE: RE: BDE : Non-blob column in table required to perform operation

Hello
Tables are bound on field Doklad (integer, in master table it is an
autoincrement field).
Except of BeforInsert event handler, which is declared on detail table to
ensure that master record is posted in order to prepare binding value, there
are no other event handler on any other field. Exception is raised when I
try to add new record into master table but before any command is send to
SQL server (it is raised inside some prepare process in BDE). To bypass this
error I close detail table in "BeforeInsert" event of master table and in
"After post" event again reopen it.
Of course it is not a solution!

Best regards
Mirek

There are structures of tables and some properties of used tTable and
tFields components (but I'm afraid that it will not be helpful).


Master table:
CREATE TABLE OBJMATHL (
DOKLAD int IDENTITY (1, 1) NOT NULL ,
DODCIS int NULL ,
FIRMA varchar (25) NULL ,
JMENO varchar (15) NULL ,
PRIJMENI varchar (15) NULL ,
ODDELENI varchar (20) NULL ,
ULICE varchar (30) NULL ,
PSC varchar (6) NULL ,
MISTO varchar (20) NULL ,
TLF varchar (20) NULL ,
TELEX varchar (20) NULL ,
FAX varchar (20) NULL ,
DATUM datetime NULL ,
ZAPSAL varchar (20) NULL
)
GO
CREATE UNIQUE CLUSTERED INDEX PK_OBJMATHL ON dbo.OBJMATHL(DOKLAD)
GO

(tTable).Autorefresh = true
(tTable DOKLAD).AutoGenerateValue = arAutoInc



Detail table:
CREATE TABLE OBJMATPOL (
DOKLAD int NOT NULL ,
POLCIS int IDENTITY (1, 1) NOT NULL ,
CISMAT int NOT NULL ,
MOTCIS varchar (20) NULL ,
NAZEV varchar (30) NOT NULL ,
MNOZOBJED float NOT NULL ,
CENAPRIJ money NULL ,
MJ varchar (2) NULL
)
GO

CREATE UNIQUE CLUSTERED INDEX PK_OBJMATPOL ON dbo.OBJMATPOL(POLCIS)
GO
CREATE INDEX ObjDleDokladu ON dbo.OBJMATPOL(DOKLAD, POLCIS)
GO

(tTable).Autorefresh = true
(tTable DOKLAD).AutoGenerateValue = arDefault
(tTable POLCIS).AutoGenerateValue = arAutoInc

procedure TfObjed.OBJMATPOLBeforeInsert(DataSet: TDataSet);
begin
if OBJMATHL.State in [dsEdit, dsInsert] then
OBJMATHL.Post;
end;
Reply With Quote
Reply

Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is On

Forum Jump


All times are GMT. The time now is 08:51 AM.


Powered by vBulletin® Version 3.8.8
Copyright ©2000 - 2019, vBulletin Solutions, Inc.