blocks|key|976747|text|使用JDBC和Filemaker+12，我可以使用括号访问重复字段，因为它是以索引1开头的表。在ODBC中应该是相同的。当然，我建议进行标准化，但它可以帮助了解还有其他选项。|type|unstyled|depth|inlineStyleRanges|entityRanges|data|976748|entityMap^0|0^^$0|@$1|2|3|4|5|6|7|D|8|@]|9|@]|A|$]]|$1|B|3|-4|5|6|7|E|8|@]|9|@]|A|$]]]|C|$]]

With JDBC and Filemaker 12 I can access the repeating field using brackets as it was table beginning with index 1.
It should be the same in ODBC.
Of course I recommend to normalize but it can help to know there is other options.

blocks|key|4760523|text|根据我的经验，关于重复字段的文档是一个谎言。:)|type|unstyled|depth|inlineStyleRanges|entityRanges|data|4760524|如果你能让它工作，请张贴一个答案。但是我想你必须使用csv导出来解决这个问题。|4760525|entityMap^0|0|0^^$0|@$1|2|3|4|5|6|7|F|8|@]|9|@]|A|$]]|$1|B|3|C|5|6|7|G|8|@]|9|@]|A|$]]|$1|D|3|-4|5|6|7|H|8|@]|9|@]|A|$]]]|E|$]]

In my experience the documentation about repeating fields is a lie. :)

If you can get it to work, please, please post an answer. But I imagine you'll have to do the workaround using the csv export.

blocks|key|4760565|text|关于这一点，我的建议是将重复字段规范化到FileMaker中的单独表中，然后执行数据传输。您可以在FileMaker中创建相关表，然后使用脚本将重复字段值填充到该表中。如果你需要帮助写这样的脚本，请让我知道。|type|unstyled|depth|inlineStyleRanges|entityRanges|data|4760566|entityMap^0|0^^$0|@$1|2|3|4|5|6|7|D|8|@]|9|@]|A|$]]|$1|B|3|-4|5|6|7|E|8|@]|9|@]|A|$]]]|C|$]]

My recommendation regarding this would be to normalize the repeating fields to a separate table within FileMaker and then perform the transfer of the data. You can create a related table in FileMaker and then use a script to populate the table with the repeating field values. Let me know if you need assistance writing such a script.

blocks|key|976790|text|我想在上面提供有关@Signix答案的详细信息。我能够从JDBC中获取重复的字段，但这很棘手。在FileMaker+"ODBC+and+JDBC+Guide“的第30页上，它指出：|type|unstyled|depth|inlineStyleRanges|entityRanges|data|976791|976792|注意，像数组一样支持FileMaker重复字段。|blockquote|976793|976794|示例|976795|插入到mytable(repField3)值(‘this+is+rep+3’)+SELECT+repField1，repField2+FROM+mytable|976796|976797|这是唯一的文档！因此从理论上讲，您可以使用以下查询：|976798|ResultSet+resultSet+=+fmStatement.executeQuery("SELECT+id,+repField[1],+repField[2]+FROM+mytable");|code-block|syntax|javascript|976799|但棘手的部分是获得结果。唯一的方法似乎是使用列索引。|976800|System.out.println(resultSet.getString("repField[1]"));+//+fails,+throws+FMSQLException
System.out.println(resultSet.getString("repField[2]"));+//+fails,+throws+FMSQLException
System.out.println(resultSet.getString("repField"));+//+returns+repField[1]
System.out.println(resultSet.getString(2));+//+returns+repField[1]
System.out.println(resultSet.getString(3));+//+returns+repField[2]|976801|我认为原因是因为字段的命名没有括号部分。|976802|System.out.println(resultSet.getMetaData().getColumnName(1));+//+returns+"id"
System.out.println(resultSet.getMetaData().getColumnName(2));+//+returns+"repField"
System.out.println(resultSet.getMetaData().getColumnName(3));+//+returns+"repField"|976803|因此，当使用resultSet.getString("repField")时，它返回具有该名称的第一个列值。这很愚蠢，但它是有效的。|offset|length|style|CODE|976804|entityMap^0|0|0|0|0|0|0|0|0|0|0|0|0|0|6|V|0^^$0|@$1|2|3|4|5|6|7|18|8|@]|9|@]|A|$]]|$1|B|3|-4|5|6|7|19|8|@]|9|@]|A|$]]|$1|C|3|D|5|E|7|1A|8|@]|9|@]|A|$]]|$1|F|3|-4|5|6|7|1B|8|@]|9|@]|A|$]]|$1|G|3|H|5|6|7|1C|8|@]|9|@]|A|$]]|$1|I|3|J|5|6|7|1D|8|@]|9|@]|A|$]]|$1|K|3|-4|5|6|7|1E|8|@]|9|@]|A|$]]|$1|L|3|M|5|6|7|1F|8|@]|9|@]|A|$]]|$1|N|3|O|5|P|7|1G|8|@]|9|@]|A|$Q|R]]|$1|S|3|T|5|6|7|1H|8|@]|9|@]|A|$]]|$1|U|3|V|5|P|7|1I|8|@]|9|@]|A|$Q|R]]|$1|W|3|X|5|6|7|1J|8|@]|9|@]|A|$]]|$1|Y|3|Z|5|P|7|1K|8|@]|9|@]|A|$Q|R]]|$1|10|3|11|5|6|7|1L|8|@$12|1M|13|1N|14|15]]|9|@]|A|$]]|$1|16|3|-4|5|6|7|1O|8|@]|9|@]|A|$]]]|17|$]]

I want to provide details about @Signix answer above. I was able to fetch repeating fields from JDBC but it's tricky. At page 30 of FileMaker "ODBC and JDBC Guide", it states:

<blockquote>
 Note FileMaker repeating fields are supported like arrays.
 
 Example

<pre><code>INSERT INTO mytable(repField[3]) VALUES (‘this is rep 3’)
SELECT repField[1], repField[2] FROM mytable
</code></pre>
</blockquote>

This is the only documentation! So in theory you could use this query:

<pre><code>ResultSet resultSet = fmStatement.executeQuery("SELECT id, repField[1], repField[2] FROM mytable");
</code></pre>

But the tricky part is getting the results. The only way seems to use the column index.

<pre><code>System.out.println(resultSet.getString("repField[1]")); // fails, throws FMSQLException
System.out.println(resultSet.getString("repField[2]")); // fails, throws FMSQLException
System.out.println(resultSet.getString("repField")); // returns repField[1]
System.out.println(resultSet.getString(2)); // returns repField[1]
System.out.println(resultSet.getString(3)); // returns repField[2]
</code></pre>

I think the reason is because fields are being named without their bracket parts.

<pre><code>System.out.println(resultSet.getMetaData().getColumnName(1)); // returns "id"
System.out.println(resultSet.getMetaData().getColumnName(2)); // returns "repField"
System.out.println(resultSet.getMetaData().getColumnName(3)); // returns "repField"
</code></pre>

So when using <code>resultSet.getString("repField")</code> it returns the first column value with that name. It's stupid but it works.

So I'm transferring an old filemaker database to MySQL and some repeating fields are causing me some problems. I've read that the ODBC standard support those fields, only when their types is "Text" and that each repetition is concatenated with a certain delimiter (<a href="http://www.filemaker.com/downloads/documentation/fm10_odbc_jdbc_guide_en.pdf" rel="nofollow noreferrer">see page 47 (PDF)</a>). However, I just can't reproduce this. All I get is the first repetition. 

If I export the database to the .csv format, the fields are correctly concatenated, so I'm not completely stuck, but if possible, I'd like to be able to obtain the same result with the ODBC connection. Thanks!

Filemaker repeating fields and ODBC

翻译质量差，导致语言生硬或混乱。

没有提供实际的解决方法或示例。

解答不清晰，无法理解或解决问题。

页面排版不美观，阅读体验差。

文章

问答

视频

学习中心

腾讯云实验室

直播

竞赛

腾讯云代码分析专区

腾讯iOA零信任安全管理系统专区

腾讯云架构师技术同盟交流圈

腾讯云数据库专区

腾讯云顾问专区

腾讯云原生专区

腾讯混元专区

腾讯云TCE专区

腾讯云Lighthouse专区

腾讯云HAI专区

腾讯云Edgeone专区

腾讯云存储专区

腾讯云智能专区

腾讯轻联专区 

腾讯云开发专区

TAPD专区

腾讯轻量云游戏服专区

腾讯云最具价值专家

腾讯云架构师技术同盟

腾讯云创作之星

腾讯云开发者先锋

腾讯云代码助手

云原生构建

TAPD 敏捷项目管理

Cloud Studio

SDK中心

API中心

命令行工具

涵盖代码开发、场景应用、自动测试全流程，助你从零构建专属AI助手

一站式MCP教程库，解锁AI应用新玩法

因此，我正在将一个旧的filemaker数据库传输到MySQL，一些重复的字段给我带来了一些问题。我读到过ODBC标准支持这些字段，只有当它们的类型是"Text“并且每次重复都与某个分隔符()连接在一起时。然而，我就是不能重现这个。我得到的只是第一次重复。如果我将数据库导出为.csv格式，字段是正确连接的，所以我不会完全卡住，但如果可能的话，我希望能够通过ODBC连接获得相同的结果。谢谢!

问Filemaker重复字段和ODBC
EN

回答 4

Stack Overflow用户

Stack Overflow用户

Stack Overflow用户

社区

活动

圈层

关于

腾讯云开发者

热门产品

热门推荐

更多推荐

问Filemaker重复字段和ODBCEN

回答 4

Stack Overflow用户

Stack Overflow用户

Stack Overflow用户

社区

活动

圈层

关于

腾讯云开发者

热门产品

热门推荐

更多推荐

问Filemaker重复字段和ODBC
EN