如何在 Informix SQL 中创建屏幕表单?
我是 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 技术交流群。

绑定邮箱获取回复消息
由于您还没有绑定你的真实邮箱,如果其他用户或者作者回复了您的评论,将不能在第一时间通知您!
发布评论
评论(1)
DB-Access 程序不是 ISQL。事实上,DB-Access 与 ISQL 相比的主要区别特征恰恰在于 DB-Access 不支持报表或表单。
要创建表单,您需要 Informix SQL 的开发版本,并且您可以运行
isql
程序(选择 Forms 选项,然后选择“Generate”,然后按照提示操作),或者运行sformbld
程序,带有创建默认表单的选项:无论哪种方式,您通常最终都会编辑(通常是广泛的)表单源文件(
.per
扩展名,用于执行(又名sperform
) 将运行的程序 它)。使用您选择的纯文本编辑器(vim
、emacs
、pico
等 - 任何适用于 C 代码的内容也适用于 ISQL。同一可执行文件的不同名称。但是,可执行文件的行为会有所不同,具体取决于调用它的名称。当作为
sformbld
调用时,它会编译表单;使用-d
选项,它会生成一个表单,然后对其进行编译。当作为sperform
调用时,它会运行一个表单。当作为 saceprep 调用时,它会编译 ACE 报告;当作为sacego
调用时,它会运行一个报告。 (“s
”前缀表示 ACE 和 Perform(以及 FormBuild)的 SQL 版本;1985 年首次发布时,还有一个名为 Informix 3.30 的非 SQL 产品,其中包含这些程序 当作为isql
调用时,该程序将充当交互式菜单 IDE,用于创建和运行表单和报告 - 除非使用选项来调用以使其运行表单或编译报告或其他内容。(实际上,在 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 thesformbld
program with options to create a default form:Either way, you normally end up editing, often extensively, the form source file (
.per
extension, for the Perform (akasperform
) 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.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 assperform
, it runs a form. When invoked assaceprep
, it compiles an ACE report; when invoked assacego
, 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.(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.)