您好!
请问:
表1: 字段: 商品ID 商品名称 ... 分别表示“商品编号”,“商品名”...
表2: 字段: spbh dj ... 分别表示“商品编号”,“单价”,...
现我:
unit1.dfm
.....
object ADOTable1: TADOTable
Active = True
Connection = ADOConnection1
CursorType = ctStatic
LockType = ltBatchOptimistic
OnNewRecord = ADOTable1NewRecord
TableName = 'order1'
Left = 328
Top = 200
object ADO_incoming_itemg_name: TStringField
FieldKind = fkLookup
FieldName = 'g_name'
LookupDataSet = ADOTable2
LookupKeyFields = '商品ID'
LookupResultField = '商品名称'
KeyFields = 'spbh'
Lookup = True
end
object ADO_incoming_itemID2: TWideStringField
FieldName = 'spbh'
LookupDataSet = ADOTable2
LookupKeyFields = '商品名称'
LookupResultField = '商品ID'
Size = 50
end
object ADO_incoming_itemDSDesigner: TBCDField
FieldName = 'dj'
DisplayFormat = '0.00'
EditFormat = '0.00'
Precision = 19
end
object ADO_incoming_itemDSDesigner2: TIntegerField
FieldName = 'sl'
end
object ADO_incoming_itemDSDesigner3: TBCDField
FieldName = 'je'
DisplayFormat = '0.00'
EditFormat = '0.00'
Precision = 19
end
end
....运行添加记录后出错:‘多步操作产生错误,请检查每一步的状态’,为什么,谢!
请问:
表1: 字段: 商品ID 商品名称 ... 分别表示“商品编号”,“商品名”...
表2: 字段: spbh dj ... 分别表示“商品编号”,“单价”,...
现我:
unit1.dfm
.....
object ADOTable1: TADOTable
Active = True
Connection = ADOConnection1
CursorType = ctStatic
LockType = ltBatchOptimistic
OnNewRecord = ADOTable1NewRecord
TableName = 'order1'
Left = 328
Top = 200
object ADO_incoming_itemg_name: TStringField
FieldKind = fkLookup
FieldName = 'g_name'
LookupDataSet = ADOTable2
LookupKeyFields = '商品ID'
LookupResultField = '商品名称'
KeyFields = 'spbh'
Lookup = True
end
object ADO_incoming_itemID2: TWideStringField
FieldName = 'spbh'
LookupDataSet = ADOTable2
LookupKeyFields = '商品名称'
LookupResultField = '商品ID'
Size = 50
end
object ADO_incoming_itemDSDesigner: TBCDField
FieldName = 'dj'
DisplayFormat = '0.00'
EditFormat = '0.00'
Precision = 19
end
object ADO_incoming_itemDSDesigner2: TIntegerField
FieldName = 'sl'
end
object ADO_incoming_itemDSDesigner3: TBCDField
FieldName = 'je'
DisplayFormat = '0.00'
EditFormat = '0.00'
Precision = 19
end
end
....运行添加记录后出错:‘多步操作产生错误,请检查每一步的状态’,为什么,谢!
解决方案 »
免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货