作为“前端”，Oracle Forms 与 Microsoft Access 相比如何？
我最近启动了一个项目，准备在 Access 2003 中构建基于 ADP 的应用程序。前端 GUI 将在 Access 中，而所有数据都驻留在 MS SQL Server 中。我说“曾经”，是因为当权者认为 Oracle Forms 可能是比 Access 和 SQL Server 更好的选择。我做这项工作的地方是一家 Oracle 商店，他们使用 Oracle 10g。他们还在内部大量使用 Oracle Forms。
至于我，我总是乐于学习任何新东西。我一直是一个相当“不拘一格”的开发人员（我使用 .NET WinForms、ASP.NET、Java、C#、Python 和 Access），因此我不介意转向 Oracle Forms，只要它可以做与MS Access（希望更多，因为 VBA 相当有限）。
所以我的问题是这样的。在开发 GUI 应用程序方面，Oracle Forms (10g) 与 MS Access 相比如何？ Access 使用 VBA 作为其语言，Oracle Forms 使用什么？我知道 Forms 应用程序是一个 Java 小程序。这是否意味着您可以使用 Java 编写 Oracle Forms？
I recently started a project where I was set to build an ADP based application in Access 2003. The font end GUI was going to be in Access while all the data resided in MS SQL Server. I say "was", because the powers that be have decided that Oracle Forms might be a better choice than Access and SQL Server. The place where I am doing this work is an Oracle shop where they use Oracle 10g. They also use Oracle Forms quite a bit internally.
As for me I am always up for learning anything new. I have always been a rather "eclectic" developer (I work with .NET WinForms, ASP.NET, Java, C#, Python, and Access) so I would not mind moving to Oracle Forms as long as it could do the same things as MS Access (hopefully even more as VBA is rather limited).
So my question is this. How does Oracle Forms (10g) compare to MS Access for developing a GUI application? Access uses VBA for it's language, what does Oracle Forms use? I know the Forms app is a Java applet. Does that means you can write Oracle Forms using Java?
如果你对这篇内容有疑问，欢迎到本站社区发帖提问 参与讨论，获取更多帮助，或者扫码二维码加入 Web 技术交流群。
绑定邮箱获取回复消息
由于您还没有绑定你的真实邮箱，如果其他用户或者作者回复了您的评论，将不能在第一时间通知您！
发布评论
评论（2）
在开发 GUI 应用程序方面，Oracle Forms (10g) 与 MS Access 相比如何？
如果您要访问 Oracle 数据库，我更喜欢 Forms。更好的是，我会选择 Apex。但这可能部分是因为我已经习惯了这些环境。我讨厌尝试在 Access 中构建最简单的 UI 之外的任何东西。
Access 使用 VBA 作为其语言，Oracle Forms 使用什么？
PL/SQL
我知道 Forms 应用程序是一个 Java 小程序。这是否意味着您可以使用 Java 编写 Oracle Forms？
如果您需要特定的自定义组件，您可以合并 Java bean，但通常情况下您不需要这样做。您通常会在表单中或在数据库中使用 SQL 或 PL/SQL 编写所有业务逻辑。
How does Oracle Forms (10g) compare to MS Access for developing a GUI application?
If you're accessing an Oracle database, I'd prefer Forms. Even better, I'd go for Apex. But that's probably partly because I'm used to these environments. I hated trying to build anything more than the simplest UIs in Access.
Access uses VBA for it's language, what does Oracle Forms use?
PL/SQL
I know the Forms app is a Java applet. Does that means you can write Oracle Forms using Java?
You can incorporate Java beans if you need specific custom components, but normally you don't need to. All your business logic you would normally code in SQL or PL/SQL, either in the form or on the database.
如果您要使用 Access ADP，为什么不使用带有 ODBC 的 Access MDB？在过去 5 年左右的时间里，这一直是 MS 推荐的设置，甚至对于使用 SQL Server 的应用程序（报告除外，ADP 在其中具有一些优势）也是如此。
ADP 似乎即将过时，在 Access 的最后两个版本 (A2007/A2010) 中没有任何更改/修复。在我看来，它们总是相当不成熟，但后来我将它们与一个成熟的平台（它们的兄弟 MDB）进行比较。
If you were going with an Access ADP, why not go with an Access MDB with ODBC? This has been MS's recommended setup even for apps using SQL Server (except for reporting, where ADPs have some advantages) for about the last 5 years or so.
ADPs are on the way out, it seems, not having had any changes/fixes in the last two versions of Access (A2007/A2010). They always seemed to me to be rather half-baked, but then I was comparing them to a mature platform, their sibling MDBs.