如何在 Informix SQL 中创建屏幕表单?

发布于 2024-12-06 23:24:57 字数 385 浏览 4 评论 0原文

我是 Informix-SQL 的新手。我正在尝试在 Informix 中创建表单。我提到了 一些在线资源

这就是我目前访问数据库的方式dbaccess database_name。我看不到用于创建表单的“表单”菜单。我是一个绝对的初学者。如果有人可以引导我走向正确的方向(我应该运行的正确命令和我可以参考的文档),我将不胜感激。提前致谢。

I am new to Informix-SQL. I am trying to create form in Informix. I referred to some resources online

This is how I am accessing my database at the moment dbaccess database_name. I can't see the 'form' menu for me to create the form. I am an absolute beginner. I would appreciate it if someone could guide me to the right direction (correct commands that I should run and documentations that I can refer to). Thanks in advance.

如果你对这篇内容有疑问,欢迎到本站社区发帖提问 参与讨论,获取更多帮助,或者扫码二维码加入 Web 技术交流群。

扫码二维码加入Web技术交流群

发布评论

需要 登录 才能够评论, 你可以免费 注册 一个本站的账号。

评论(1

韵柒 2024-12-13 23:24:57

DB-Access 程序不是 ISQL。事实上,DB-Access 与 ISQL 相比的主要区别特征恰恰在于 DB-Access 不支持报表或表单。

要创建表单,您需要 Informix SQL 的开发版本,并且您可以运行 isql 程序(选择 Forms 选项,然后选择“Generate”,然后按照提示操作),或者运行 sformbld 程序,带有创建默认表单的选项:

sformbld -d formname database table1 ...

无论哪种方式,您通常最终都会编辑(通常是广泛的)表单源文件(.per 扩展名,用于执行(又名 sperform) 将运行的程序 它)。使用您选择的纯文本编辑器(vimemacspico 等 - 任何适用于 C 代码的内容也适用于 ISQL。


isqlsformbld 之间有什么区别?

$ ls -il isql sformbld sperform saceprep sacego
212302 -rwxr-xr-x 5 informix informix 844005 2010-09-17 11:24 isql
212302 -rwxr-xr-x 5 informix informix 844005 2010-09-17 11:24 sacego
212302 -rwxr-xr-x 5 informix informix 844005 2010-09-17 11:24 saceprep
212302 -rwxr-xr-x 5 informix informix 844005 2010-09-17 11:24 sformbld
212302 -rwxr-xr-x 5 informix informix 844005 2010-09-17 11:24 sperform
$

同一可执行文件的不同名称。但是,可执行文件的行为会有所不同,具体取决于调用它的名称。当作为 sformbld 调用时,它会编译表单;使用 -d 选项,它会生成一个表单,然后对其进行编译。当作为 sperform 调用时,它会运行一个表单。当作为 saceprep 调用时,它会编译 ACE 报告;当作为 sacego 调用时,它会运行一个报告。 (“s”前缀表示 ACE 和 Perform(以及 FormBuild)的 SQL 版本;1985 年首次发布时,还有一个名为 Informix 3.30 的非 SQL 产品,其中包含这些程序 当作为

isql 调用时,该程序将充当交互式菜单 IDE,用于创建和运行表单和报告 - 除非使用选项来调用以使其运行表单或编译报告或其他内容。

isql -fc form    # Compile form
isql -fr form    # Run form
isql -rc report  # Compile report
isql -rr report  # Run report

isql dbase [-|script]   # Runs SQL script, rather like DB-Access does

(实际上,在 90 年代初的一个晚上,或者可能是 80 年代末,DB-Access 是通过从 ISQL 中剥离不需要的代码而创建的。因此,DB-Access 的行为就像 ISQL 一样,而不是相反。)

The DB-Access program is not ISQL. Indeed, the main distinguishing feature of DB-Access compared with ISQL is precisely that DB-Access does not support reports or forms.

To create forms, you need the development version of Informix SQL, and you either run the isql program (choose the Forms option, and then Generate, and follow the prompts), or you run the sformbld program with options to create a default form:

sformbld -d formname database table1 ...

Either way, you normally end up editing, often extensively, the form source file (.per extension, for the Perform (aka sperform) program which will run it). Use the plain text editor of your choice (vim, emacs, pico, etc - anything that's OK for C code will work for ISQL too.


What is the difference between isql and sformbld?

$ ls -il isql sformbld sperform saceprep sacego
212302 -rwxr-xr-x 5 informix informix 844005 2010-09-17 11:24 isql
212302 -rwxr-xr-x 5 informix informix 844005 2010-09-17 11:24 sacego
212302 -rwxr-xr-x 5 informix informix 844005 2010-09-17 11:24 saceprep
212302 -rwxr-xr-x 5 informix informix 844005 2010-09-17 11:24 sformbld
212302 -rwxr-xr-x 5 informix informix 844005 2010-09-17 11:24 sperform
$

Different names for the same executable. However, the executable behaves differently depending on the name it is invoked by. When invoked as sformbld, it compiles forms; with the -d option, it generates a form and then compiles it. When invoked as sperform, it runs a form. When invoked as saceprep, it compiles an ACE report; when invoked as sacego, it runs a report. (The 's' prefix indicates the SQL version of ACE and Perform (and FormBuild); when it was first released in 1985, there was also a non-SQL product called Informix 3.30 with these programs as part of the suite.)

When invoked as isql, the program behaves as an interactive menu IDE for creating and running forms and reports - unless invoked with options to make it run a form or compile a report or whatever.

isql -fc form    # Compile form
isql -fr form    # Run form
isql -rc report  # Compile report
isql -rr report  # Run report

isql dbase [-|script]   # Runs SQL script, rather like DB-Access does

(Actually, once upon an evening back in the very early 90s - or perhaps very late 80s - DB-Access was created by stripping unneeded code from ISQL. So, DB-Access behaves like ISQL does, rather than vice versa.)

~没有更多了~
我们使用 Cookies 和其他技术来定制您的体验包括您的登录状态等。通过阅读我们的 隐私政策 了解更多相关信息。 单击 接受 或继续使用网站,即表示您同意使用 Cookies 和您的相关数据。
原文