[Webinar] Streamline your web hosting managementRegister Today

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 1376
  • Last Modified:

TClientDataSet master/detail error Column unknown

Hi all,

I'm receive a Column unknown error after set a master/detail betwen two clientdatasets:
MasterSource = dsMaster
MasterFields = fdMaster
IndexFieldNames = fdDetail
Looks to be quotes error or something else.

---------------------------
Error
---------------------------
SQL Server Error: Column unknown
NM_ITEM_GRUPO.
---------------------------
OK  
---------------------------

---------------------------
Debugger Exception Notification
---------------------------
Project Proflex.exe raised exception class EDatabaseError with message 'SQL Server Error: Column unknown
NM_ITEM_GRUPO'. Process stopped. Use Step or Run to continue.
---------------------------
OK   Help  
---------------------------

I'm using D7 IB6.0

tanks
Paulo
0
paulo_psa
Asked:
paulo_psa
1 Solution
 
TheRealLokiSenior DeveloperCommented:
can we see the sql statement?
0
 
paulo_psaAuthor Commented:
Sure,

select * from "item_structure" order by "ord_item", node, master, detail
0
 
mikelittlewoodCommented:
So I presume the table item_structure actually contains the columns ord_item, node, master, detail ..
Or are you missing a link to another table which one of these columns is supposed to be from?
0
[Webinar] Kill tickets & tabs using PowerShell

Are you tired of cycling through the same browser tabs everyday to close the same repetitive tickets? In this webinar JumpCloud will show how you can leverage RESTful APIs to build your own PowerShell modules to kill tickets & tabs using the PowerShell command Invoke-RestMethod.

 
TheRealLokiSenior DeveloperCommented:
any idea what table the NM_ITEM_GRUPO is in?
0
 
paulo_psaAuthor Commented:
Hi,


nm_item_grupo is the link column and it is in both the master and detail table.

ord_item, node, master, detail are only for order by, there are others fields on that table.

It's really a very strange error, looks to be a bug.

0
 
moduloCommented:
PAQed with points refunded (250)

modulo
Community Support Moderator
0

Featured Post

Take Control of Web Hosting For Your Clients

As a web developer or IT admin, successfully managing multiple client accounts can be challenging. In this webinar we will look at the tools provided by Media Temple and Plesk to make managing your clients’ hosting easier.

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