Daniel Taylor

Articles by Daniel

1. DB Function Descriptions P

   302 views Updated May 21st, 2026

2. ClearSavePoint

   121 views Updated May 12th, 2026

3. ISAM settings elements

   398 views Updated February 12th, 2026

4. ChangeBatch

   122 views Updated May 12th, 2026

5. DB Function Descriptions B

   234 views Updated May 20th, 2026

6. CloseRFile

   114 views Updated May 12th, 2026

7. CreateIFile

   124 views Updated May 12th, 2026

8. ctGetOpenFiles

   112 views Updated May 12th, 2026

9. ctGetAccountExpirationTime

   113 views Updated May 12th, 2026

10. ctGetConnectionInfo

    132 views Updated May 12th, 2026

11. CreateISAMXtd

    122 views Updated May 12th, 2026

12. C API Functions W

    40 views Updated June 18th, 2026

13. DB Function Descriptions S

    434 views Updated May 21st, 2026

14. C API Functions P

    41 views Updated June 17th, 2026

15. ctCallback

    116 views Updated May 12th, 2026

16. AvailableFileNbr

    116 views Updated May 11th, 2026

17. Users, schemas, and roles

    189 views Updated May 15th, 2026

18. clearTranError

    119 views Updated May 12th, 2026

19. ctFILBLK

    118 views Updated May 12th, 2026

20. DB Function Descriptions L

    280 views Updated May 21st, 2026

21. ctGetFileUsers

    114 views Updated May 12th, 2026

22. ctGetNextSequenceValue

    108 views Updated May 12th, 2026

23. cndxeval

    111 views Updated May 12th, 2026

24. DB SQL Features

    This chapter explains the important features provided by FairCom DB SQL.

    331 views Updated May 18th, 2026

25. C API Functions N

    52 views Updated June 17th, 2026

26. DB Function Descriptions D

    318 views Updated May 20th, 2026

27. ctfcpAllocateHandle

    123 views Updated May 12th, 2026

28. cndxfree

    126 views Updated May 12th, 2026

29. C API Functions M

    47 views Updated June 24th, 2026

30. ctfcpRemoveFileCopyOperation

    118 views Updated May 12th, 2026

31. DB SQL utilities list

    258 views Updated May 18th, 2026

32. ctCloseSequence

    111 views Updated May 12th, 2026

33. File Security and Encryption

    104 views Updated May 29th, 2026

34. CreateIndexMember

    127 views Updated May 12th, 2026

35. Commit

    124 views Updated May 12th, 2026

36. DB Function Descriptions V

    213 views Updated May 21st, 2026

37. ctExecJsonAction

    105 views Updated May 12th, 2026

38. AddCtResource

    112 views Updated May 11th, 2026

39. addIDfield

    121 views Updated May 11th, 2026

40. addChangeIDfield

    124 views Updated May 12th, 2026

41. AllocateSet

    114 views Updated May 11th, 2026

42. C API Functions E

    43 views Updated June 18th, 2026

43. CreateIFileXtd8

    125 views Updated May 12th, 2026

44. ctCreateSequence

    115 views Updated May 12th, 2026

45. ctfiltercb_rowl

    125 views Updated May 12th, 2026

46. ctAlterSchema

    105 views Updated May 12th, 2026

47. CompactIFileXtd8

    131 views Updated May 12th, 2026

48. forwardToExternalBrokers

    274 views Updated April 23rd, 2026

49. C API Functions B

    68 views Updated June 16th, 2026

50. ctfiltercbAddFilter

    129 views Updated May 12th, 2026

51. ctGetNullKeyValue

    112 views Updated May 12th, 2026

52. CreateIndexFile

    121 views Updated May 12th, 2026

53. AbortXtd

    112 views Updated May 11th, 2026

54. FairCom Edge APIs

    FairCom Edge's API documentation for software developers, equipment manufacturers, and automation engineers

    256 views Updated June 10th, 2026

55. ctFILELIST

    114 views Updated May 12th, 2026

56. ctFILMTX

    123 views Updated May 12th, 2026

57. ctGetNullBit

    115 views Updated May 12th, 2026

58. ctfcpSetCallback

    118 views Updated May 12th, 2026

59. DB Function Descriptions R

    321 views Updated May 21st, 2026

60. C API Functions G

    51 views Updated June 25th, 2026

61. C API Functions R

    42 views Updated June 17th, 2026

62. DB Function Descriptions W

    241 views Updated May 21st, 2026

63. ctfcpSetErrorBuffer

    115 views Updated May 12th, 2026

64. ctGetFileLocks

    105 views Updated May 12th, 2026

65. ctAddSerialNumberField

    114 views Updated May 12th, 2026

66. cndxrun

    111 views Updated May 12th, 2026

67. CompactIFile

    111 views Updated May 12th, 2026

68. AllocateRange

    116 views Updated May 11th, 2026

69. CloseCtFileByName

    130 views Updated May 12th, 2026

70. CompactIFileXtd

    114 views Updated May 12th, 2026

71. ctGETHGH

    120 views Updated May 12th, 2026

72. CloseISAM

    116 views Updated May 12th, 2026

73. ctfcpGetErrorBuffer

    120 views Updated May 12th, 2026

74. ctGetFailOverState

    111 views Updated May 12th, 2026

75. C API Functions T

    46 views Updated June 24th, 2026

76. CloseConnection

    130 views Updated May 12th, 2026

77. ctfcpAddFileCopyOperation

    117 views Updated May 12th, 2026

78. C API Functions L

    43 views Updated June 18th, 2026

79. ctfcpSetCopyFilePassword

    116 views Updated May 12th, 2026

80. CreateIndexFileXtd8

    116 views Updated May 12th, 2026

81. ctfcpCopyFile

    115 views Updated May 12th, 2026

82. ctCopyFile

    119 views Updated May 12th, 2026

83. C API Functions H

    41 views Updated June 18th, 2026

84. ctfcpSetCopyFilenames

    116 views Updated May 12th, 2026

85. MQ releases

    Explore FairCom MQ releases, featuring enhancements and new capabilities.

    214 views Updated June 2nd, 2026

86. BuildKey

    123 views Updated May 12th, 2026

87. AddAutoSysTimeFields

    121 views Updated May 11th, 2026

88. CleanIndexXtd

    119 views Updated May 12th, 2026

89. CreateISAM

    121 views Updated May 12th, 2026

90. cndxparse

    114 views Updated May 12th, 2026

91. AddVRecord

    126 views Updated May 11th, 2026

92. ctfcpSetCopyOptions

    114 views Updated May 12th, 2026

93. Begin

    131 views Updated May 12th, 2026

94. ctDeferredIndexControl

    115 views Updated May 12th, 2026

95. CreateDataFileXtd8

    113 views Updated May 12th, 2026

96. CreateIndexFileXtd

    113 views Updated May 12th, 2026

97. C API Functions F

    43 views Updated June 18th, 2026

98. CreateIFileXtd

    120 views Updated May 12th, 2026

99. BlockingISAMRead

    129 views Updated May 12th, 2026

100. AddRecord

     128 views Updated May 11th, 2026

101. DB Function Descriptions K

     219 views Updated May 20th, 2026

102. DB Function Descriptions U

     258 views Updated May 21st, 2026

103. ctDeleteSequence

     118 views Updated May 12th, 2026

104. DB Function Descriptions I

     237 views Updated May 20th, 2026

105. ctfcpSetServerParameters

     113 views Updated May 12th, 2026

106. DB Function Descriptions Q

     135 views Updated May 21st, 2026

107. ISAM server setup

     337 views Updated March 26th, 2026

108. CloseIFile

     123 views Updated May 12th, 2026

109. ctFILBLKX

     119 views Updated May 12th, 2026

110. DB Function Descriptions T

     254 views Updated May 21st, 2026

111. RTG configuration file overview

     369 views Updated March 2nd, 2026

112. CreateDataFileXtd

     119 views Updated May 12th, 2026

113. ctGetIsamFileNbr

     109 views Updated May 12th, 2026

114. ctfiltercbRemoveFilter

     114 views Updated May 12th, 2026

115. DB Function Descriptions A

     286 views Updated May 20th, 2026

116. CloseCtFile

     125 views Updated May 12th, 2026

117. C API Functions A

     53 views Updated June 16th, 2026

118. C API Functions I

     47 views Updated June 18th, 2026

119. ctfcpFreeHandle

     117 views Updated May 12th, 2026

120. DB Function Descriptions E

     226 views Updated May 20th, 2026

121. cpybuf

     118 views Updated May 12th, 2026

122. AllocateBatch

     117 views Updated May 11th, 2026

123. C API Functions S

     93 views Updated June 24th, 2026

124. C API Functions U

     42 views Updated June 18th, 2026

125. C API Functions D

     75 views Updated June 18th, 2026

126. AddKey

     119 views Updated May 11th, 2026

127. Abort

     110 views Updated May 11th, 2026

128. ChangeSet

     113 views Updated May 12th, 2026

129. DB releases and breaking changes

     Explore FairCom DB releases, featuring enhancements and new capabilities.

     400 views Updated June 4th, 2026

130. ISQL Statement Descriptions

     246 views Updated May 20th, 2026

131. ctGetCurrentSequenceValue

     123 views Updated May 12th, 2026

132. ctGetIsamErrorCode

     115 views Updated May 12th, 2026

133. Basic JDBC driver operations

     212 views Updated May 19th, 2026

134. CreateDataFile

     136 views Updated May 12th, 2026

135. C API Functions V

     48 views Updated June 18th, 2026

136. DB Function Descriptions G

     406 views Updated May 26th, 2026

137. C API Functions C

     49 views Updated June 18th, 2026

138. C API Functions O

     48 views Updated June 17th, 2026

139. ChangeISAMContext

     115 views Updated May 12th, 2026

140. C API Functions J

     51 views Updated June 18th, 2026

141. DB Function Descriptions F

     254 views Updated May 20th, 2026

142. Partitioned Files (ISAM for C)

     106 views Updated May 29th, 2026

143. CloseISAMContext

     128 views Updated May 12th, 2026

144. DB Function Descriptions O

     216 views Updated May 21st, 2026

145. DB Function Descriptions N

     269 views Updated May 21st, 2026

146. DB Function Descriptions C

     834 views Updated May 20th, 2026

147. ChangeHistory

     110 views Updated May 12th, 2026

148. Logical functions

     282 views Updated May 15th, 2026

149. Combining FairCom DB SQL with ISAM

     380 views Updated May 18th, 2026

150. DB SQL identifiers

     307 views Updated May 15th, 2026

151. RTG performance tuning

     360 views Updated March 2nd, 2026

152. FairCom Terms Glossary

     Definitions of technical terms used by FairCom products

     479 views Updated January 16th, 2026

153. RTG server setup

     431 views Updated April 8th, 2026

154. ODBC driver errors

     FairCom ODBC Driver error codes are returned by FairCom's ODBC driver

     220 views Updated February 9th, 2026

155. ISAM configuration

     368 views Updated April 6th, 2026

156. ISAM XDD schema structure

     479 views Updated March 27th, 2026

157. JDBC glossary

     198 views Updated May 14th, 2026

158. RTG structure elements

     367 views Updated March 2nd, 2026

159. ISAM driver installation

     319 views Updated February 11th, 2026

160. Field conversion example

     201 views Updated May 14th, 2026

161. Encryption

     182 views Updated May 18th, 2026

162. ISAM quick start

     335 views Updated March 26th, 2026

163. Direct Link FairCom DB SQL ODBC Driver

     274 views Updated May 14th, 2026

164. ISAM cttrnmod (change transaction mode utility)

     324 views Updated January 30th, 2026

165. Which functions are safe?

     168 views Updated May 14th, 2026

166. Configuring FairCom DB SQL Data Sources

     431 views Updated May 14th, 2026

167. Introductory tutorial

     339 views Updated May 14th, 2026

168. RTG tutorials

     323 views Updated March 24th, 2026

169. Conversion functions

     276 views Updated May 15th, 2026

170. FairCom ISAM overview

     FairCom ISAM documentation home

     238 views Updated March 26th, 2026

171. FairCom DB SQL built-in stored procedures

     323 views Updated May 18th, 2026

172. DB SQL options

     FairCom DB SQL supports a variety of options that allows you to address your needs.

     344 views Updated June 10th, 2026

173. More info

     193 views Updated May 14th, 2026

174. DB SQL functions overview

     189 views Updated May 14th, 2026

175. normalLowerLimit

     268 views Updated April 23rd, 2026

176. Aggregate functions

     185 views Updated May 15th, 2026

177. RTG SQL access

     588 views Updated May 12th, 2026

178. Clustering concepts

     375 views Updated January 16th, 2026

179. RTG XDD schema structure

     479 views Updated March 24th, 2026

180. ODBC quick tour

     213 views Updated May 14th, 2026

181. RTG runtime drivers

     401 views Updated February 27th, 2026

182. Troubleshooting

     This section provides some useful troubleshooting tips.

     232 views Updated March 2nd, 2026

183. deadbandLowerLimit

     279 views Updated April 23rd, 2026

184. ISAM ctmigra (conversion utility)

     201 views Updated March 27th, 2026

185. RTG utilities overview

     214 views Updated February 27th, 2026

186. ISAM structure elements

     379 views Updated June 30th, 2026

187. Migrating to FairCom DB SQL

     222 views Updated May 18th, 2026

188. ODBC Conformance Notes

     This chapter details the ODBC functionality that FairCom DB SQL supports through the ODBC Driver.

     213 views Updated May 14th, 2026

189. RTG settings elements

     438 views Updated March 2nd, 2026

190. FairCom DB SQL configuration keywords

     379 views Updated June 10th, 2026

191. newTagName

     266 views Updated April 23rd, 2026

192. ctutil

     421 views Updated April 6th, 2026

193. Importing tables into FairCom DB SQL

     202 views Updated May 18th, 2026

194. Data replication errors

     FairCom Data Replication error codes are returned by the Data Replication APIs and Replication Manager application

     212 views Updated February 9th, 2026

195. String functions

     222 views Updated May 15th, 2026

196. DB SQL built-in stored procedures

     303 views Updated May 14th, 2026

197. ISAM setup

     338 views Updated January 29th, 2026

198. Configurable Log Output

     200 views Updated February 11th, 2026

199. atEnd

     282 views Updated April 23rd, 2026

200. Modbus: convert collected integers to floating point numbers

     184 views Updated April 15th, 2026

201. ISAM ctutil

     374 views Updated April 6th, 2026

202. DB SQL joins

     281 views Updated May 14th, 2026

203. length

     267 views Updated April 23rd, 2026

204. Configure modbus to output data to a device

     164 views Updated January 9th, 2026

205. ISAM ctfileid (update file IDs)

     334 views Updated March 27th, 2026

206. Search Conditions

     252 views Updated May 15th, 2026

207. Math functions

     199 views Updated May 14th, 2026

208. ISAM logging, error codes, and troubleshooting

     345 views Updated March 27th, 2026

209. RTG data conversion

     524 views Updated March 2nd, 2026

210. RTG/ISAM errors

     Errors specific to RTG and ISAM

     358 views Updated January 16th, 2026

211. Other RTG utilities

     400 views Updated February 27th, 2026

212. Relationships tutorial

     How to build table/file relationships using the FairCom DB SQL ODBC Interface

     188 views Updated May 14th, 2026

213. RTG directories

     361 views Updated January 28th, 2026

214. ISAM SQL access

     397 views Updated March 26th, 2026

215. DB SQL query expressions

     311 views Updated May 15th, 2026

216. ISAM releases and breaking changes

     330 views Updated June 4th, 2026

217. DB SQL expressions

     299 views Updated May 15th, 2026

218. Replication, Clusters, High Availability, and Disaster Recovery

     349 views Updated February 27th, 2026

219. RTG setup and installation overview

     218 views Updated January 28th, 2026

220. Partitioned files with RTG

     352 views Updated February 27th, 2026

221. DB SQL types SDK sverview

     182 views Updated May 14th, 2026

222. Transaction processing tutorial

     190 views Updated May 14th, 2026

223. Record/row locking tutorial

     203 views Updated May 14th, 2026

224. ISAM data conversion

     372 views Updated March 26th, 2026

225. Ranking functions

     278 views Updated July 1st, 2026

226. DB SQL statements

     This chapter provides detailed reference material on each SQL statement.

     448 views Updated June 17th, 2026

227. Replicating RTG file operations

     230 views Updated February 10th, 2026

228. ThingWorx Troubleshooting

     Troubleshoot ThingWorx errors

     332 views Updated January 14th, 2026

229. DBQL with Callbacks

     268 views Updated May 18th, 2026

230. Application data setup

     254 views Updated May 18th, 2026

231. UTF-8 data stored in RTG

     194 views Updated February 10th, 2026

232. jsonActionApiDefaults

     259 views Updated April 23rd, 2026

233. RTG driver errors

     369 views Updated March 2nd, 2026

234. FairCom DB SQL Reserved Words

     189 views Updated May 14th, 2026

235. JDBC relationships tutorial

     187 views Updated May 14th, 2026

236. includeInputConnectorProperties

     269 views Updated April 23rd, 2026

237. DBL Java configuration

     FairCom DB SQL Java Configuration for Stored Procedures, Triggers and User Defined Functions

     279 views Updated May 14th, 2026

238. mqttPayloadType

     277 views Updated April 23rd, 2026

239. Listing connections with a particular file open

     182 views Updated March 2nd, 2026

240. DB SQL reserved words and error messages

     181 views Updated May 15th, 2026

241. ISAM substitution specifiers

     312 views Updated January 29th, 2026

242. List of variant types

     200 views Updated January 7th, 2026

243. DB SQL data types

     297 views Updated May 15th, 2026

244. RTG transaction support

     348 views Updated March 2nd, 2026

245. Install Standalone SQL

     198 views Updated May 18th, 2026

246. More information

     186 views Updated May 18th, 2026

247. ctsqlimp - DB SQL Import Utility

     325 views Updated May 18th, 2026

248. Upgrade files to RTG 5 attribute resource format (Unified Data Types)

     453 views Updated March 24th, 2026

249. ISAM utilities overview

     206 views Updated February 12th, 2026

250. JDBC record/row locking tutorial

     176 views Updated May 14th, 2026

251. FairCom RTG Overview

     FairCom RTG documentation home

     216 views Updated February 27th, 2026

252. JDBC Conformance

     Support for standard JDBC data types, return values, andf error messages provided by the FairCom DB SQL JDBC Driver.

     186 views Updated May 19th, 2026

253. Date-Time format strings

     280 views Updated May 14th, 2026

254. RTG releases and breaking changes

     287 views Updated June 4th, 2026

255. includeThingProperties

     262 views Updated April 23rd, 2026

256. JDBC transaction processing tutorial

     190 views Updated May 14th, 2026

257. xddgen

     361 views Updated February 27th, 2026

258. More ISAM utilities

     342 views Updated March 27th, 2026

259. Date and Time functions

     212 views Updated May 15th, 2026

260. Copying server-controlled files

     360 views Updated March 2nd, 2026

261. ISAM configuration file elements overview

     327 views Updated March 27th, 2026

262. RTG configuration

     402 views Updated April 6th, 2026

263. DB SQL system catalog tables

     195 views Updated May 14th, 2026

264. Install DB SQL

     254 views Updated May 18th, 2026

265. autoValue

     381 views Updated April 23rd, 2026

266. Advanced ISAM techniques

     350 views Updated January 30th, 2026

267. Secure topics and integration tables

     Secure your topics and integration tables by managing roles

     417 views Updated June 8th, 2026

268. SQL language elements overview

     288 views Updated May 14th, 2026

269. Btrieve compatibility

     383 views Updated February 4th, 2026

270. RTG hot alter table

     333 views Updated February 27th, 2026

271. System and metadata functions

     291 views Updated May 14th, 2026

272. RTG quick start

     381 views Updated February 27th, 2026

273. SQL access to your standalone database (Overview)

     183 views Updated May 18th, 2026

274. RTG substitution specifiers

     358 views Updated February 10th, 2026

275. deadbandUpperLimit

     280 views Updated April 23rd, 2026

276. File maintenance with RTG

     210 views Updated February 27th, 2026

277. A-B Ethernet/IP connector errors

     Allen-Bradley Ethernet/IP IoT connector error codes

     204 views Updated January 16th, 2026

278. includeTopicProperties

     260 views Updated April 23rd, 2026

279. fixedLengthCharFormat

     329 views Updated April 23rd, 2026

280. binaryFormat

     305 views Updated April 23rd, 2026

281. includeOutputConnectorProperties

     268 views Updated April 23rd, 2026