Devart Forums

Hi Team.
Im using linux ubuntu 10 and mysql 5.5 all my table names are in lowercase

when using a master/detail there is a problem when establishing master field and detail field

Master Table : mtable
Master Field : id

detail Table : dtable
detail field : id

relation id = id



but when running on linux the query result from devart is MTABLE.ID = DTABLE.ID

i mean it makes it uppercase and then as you know in linux the tablename is case sensitive and so it throws an error saying that the MTABLE doesnt exist.

is there any way to solve this, is there any configurable parameter?

using the property SQLFilter doesnt work for me because using this there is no automatic asignation of the master value to the detail value.

Hello,

Please specify the way you establish master/detail relationship. Do you use MasterSource, MasterFields, and DetailFields properties, or SQL code? Also please specify all the SQL code you are using (to select data from tables and to establish master/detail relationship).

Hi Andrey,

I think OP is using Delphi IDE property editor to make the master-detail relationship , it has a wizard that allows to set the master-detail, which automatically sets the relationship based on user input, and this makes the table and field names uppercase.

Regards,
Steve F

I cannot reproduce the problem. UniDAC creates master/detail relationship based on table names and field names which were received from MySQL server. Please specify the following:
- the script to create both master and detail tables;
- the OS (Windows, Linux) of the computer where MySQL server you are working with is installed;
- the OS of the computer where your program is running.
- the exact version of UniDAC. You can learn it from the About sheet of TUniConnection Editor.

Go to the TDataSetProvider and set ResolveToDataSet to true