如何在fbexport命令行上引用列名 [英] How to quote column names on the commandline of fbexport

问题描述

正如标题所述，我该如何处理FBExport中看起来像关键字的列名?

As the title says, how am I going to deal with a column name in FBExport that look like a keyword?

这就是我的陈述:

-Q "SELECT a.ID, a.USERID, a.`WHEN`, a.INOUT FROM ATTENDANT a"

然后我收到此错误:

Engine Code    : 335544569
Engine Message :
Dynamic SQL Error
SQL error code = -104
Token unknown - line 1, column 26
WHEN

当我使用

"WHEN"


Error: Switches must begin with -

尝试何时"

-Q "SELECT a.ID, a.USERID, a.'WHEN', a.INOUT FROM ATTENDANT a;"
SQL Message : -104
Invalid token

Engine Code    : 335544569
Engine Message :
Dynamic SQL Error
SQL error code = -104
Token unknown - line 1, column 26
'WHEN'

Error: Switches must begin with -

正确的转义字符是什么?

What are the correct escape characters?

推荐答案

似乎其他人正在处理从Safescan TimeAttenedant

It looks like someone else is dealing with the external access to the Firebird database from Safescan TimeAttenedant

从Safescan命名列WHEN有点愚蠢，因为这是Firebird中的关键字.

It was a little bit stupid from Safescan to name a column WHEN because this is a keyword in Firebird.

在insert语句的上下文中，像这样的列列表没有成功:

In the context of an insert statement, I have no success with a column list like:

insert into attendant (ID, USERID, DEVICEID, WHEN, INOUT, VERIFYMODE, WORKCODE) values (1092, 1, 1, '28.08.2017 08:00', 0, 4, 3);

何时"，\何时"，\何时"，...没有成功

"WHEN", \"WHEN\", \'WHEN\', ... no success

解决方法-插入所有不包含列列表的数据，例如:

Remedy - Insert all data without column list, ex:

insert into attendant values (1034, 2, 1, '28.08.2017 08:00', 0, 4, null, null, null, null, null, 3);

查询要容易得多:select * from attendant;

这篇关于如何在fbexport命令行上引用列名的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！