PDA

View Full Version : nexusdb.public.support.sql

Pages : [1] 2 3 4 5 6 7 8 9
  1. Re: I'm the first.
  2. SQL to measure time spent on each web page ?
  3. SQL Baiscs ???
  4. Partial Name Search
  5. great free online sql reference/course
  6. Order By - Partial Name search
  7. Where do I look...
  8. NX1 - Select * from #Tables causes AV on server
  9. Capability not supported
  10. Create Table
  11. Help with select/count
  12. Temporary SQL tables
  13. Question on Extract/subquery
  14. NX1 - 'Select' Extract incorrect record when it work with Chinese
  15. Statement types
  16. Another locking isse
  17. This SQL should not execute
  18. Joining tables from different databases
  19. NexusDB DDL
  20. Union
  21. NexusDB Data Types
  22. Assigning NULL to a Prepared SQL DateTime Field
  23. Implicit transactions
  24. Time fields in SQL
  25. Alter Table
  26. System_row#
  27. Order by system_row#
  28. Metadata - DataDictionary
  29. AV when querying system tables
  30. Blob Graphic and SQL
  31. SQL Error "In" not supported
  32. DELETE FROM fails with 'cannot open table' error
  33. Two LEFT JOINS in one SELECT
  34. Script processing
  35. Scripts - RowsAffected
  36. Check if table exists
  37. Syntax Error
  38. SQL newbie question
  39. subqueries ...
  40. SQL statement times out
  41. NX1.01: AV on SELECT * FROM #INDICES
  42. SQL ... bug ??
  43. Extra ordinary long execution time
  44. isnull()
  45. Select into - live datasets
  46. NX1.01: Cast with Group By Error
  47. AVG of TIME field ?
  48. Demo: Master/Detail editing with in-memory datasets
  49. v1.01 - union [all]
  50. TRANSFORM & PIVOT
  51. Help constructing SQL statement
  52. SQL BUG ...
  53. Online SQL reference is not updated?
  54. Question
  55. Identity type
  56. Duplicate type question
  57. Query Error
  58. problem porting an outer join from Access --> Nexus
  59. operator 'NOT LIKE' doesn't work with a secondary index
  60. Unknown temporary table
  61. Select Into
  62. Update multiple columns
  63. Using 'Identity' in NexusDB?
  64. Reindex Table width SQL?
  65. Negative values in autoinc fields
  66. Retreiving 'identity' from code?
  67. Incorrect sort order
  68. Table Existance
  69. SQL and Indexes
  70. Bug selecting all fields with outer joins
  71. VERY simple quesion
  72. Wrong values inserted
  73. ff213 SQL not working in Nx1.01.
  74. Error SQL for Insert with Group with Non-aggregate column (constant)
  75. Transaction Processing
  76. Help on a "simple" Select statement, please
  77. ROUND function gives Non-Aggregate error ...
  78. SQL Speed ???
  79. Trying to find Dup's
  80. Using the 'IN' statement
  81. Now I need to get No Dups..
  82. Order By "Position" error
  83. V1.02 - nice update
  84. Creating tables with foreign keys
  85. Issue #499 still occur. :-(
  86. Error with more than 1 LEFT JOIN
  87. Sql query too slow ... sometime :(
  88. V1.02 - Drop table error
  89. V1.02 - Create index error
  90. Locale question/problem
  91. Order by Upper(fieldname)
  92. SQL Help I
  93. SQL Help II
  94. SUM() does not work with Word32-Fields ?!
  95. Server 1.02 and Description field
  96. No Subject
  97. SQL using two different tables in different databases - Pls Help
  98. Left Outer join with 3 table?
  99. case...when bug ?
  100. UNION bug ?
  101. Nexus SQL and single quote in a name.
  102. Dublicate field
  103. Syntax Error in date literal [no error code]
  104. copy fields between 2 tables
  105. Mod / Modulo function in SQL ?
  106. Little annoying bug
  107. INSERT problem prevents use in Datasnap app
  108. select into / create like
  109. How to access an aggregate field
  110. How to format data in columns
  111. table encryption
  112. SELECT TOP X bug ?
  113. Left join
  114. Running SQL Query Without a TnxQuery object?
  115. Speed problem with sql parameters
  116. foreign key
  117. GROUP BY/SQL Engine problem
  118. Is this possible ?
  119. Zero-length binary data is NULL?
  120. Selecting the Month of a datetime field
  121. How to create an sql that ...
  122. Passing variable to SQL statement
  123. Problem with Update on Boolean field
  124. Assertion failed in nxsqlproxies.pas (null values)
  125. Nested aggregates are not allowed
  126. Indexes to nxQuery
  127. A better way to do this query?
  128. What am I doing wrong?
  129. SQL engine
  130. SQL-Satement with two aliases?
  131. SQL parser oddity ???
  132. Best choice for speed?
  133. Misleading SQL error message
  134. Convert date to appropriate quarter
  135. Problem with floats
  136. DATETIME Apply Range
  137. Setting default values
  138. TnxQuery not seeing previously Applied Range on TnxTable
  139. TO Per -- Editable query for selected fileds?
  140. Bulk insert
  141. Change to SQL?
  142. Help with SQL
  143. Need help with this sql
  144. NexusDB SQL implementation (numeric format) of SUM ?
  145. SQL Bug - Only one UNION statement allowed in select statement
  146. SQL bug? IGNORE CASE is ignored?
  147. Runtime SQL Query raises an Overflow error
  148. SQL speed compared to Access trouble
  149. Is it possible using SQL?
  150. SQL/Index Help Please
  151. Running a Query and EM SQL results not the same
  152. Filling a field with help of a SELECT clause
  153. SQL Help
  154. Urgent SQL Bug
  155. Problem ordering by Date
  156. Grabbing only first line in a text memo via sql ?
  157. Finding strange characters.
  158. manual typo
  159. Insert Into problem
  160. Currency fields problem
  161. SQL Query Question
  162. Problem with syntax
  163. Help with complexe query need
  164. Assigning NULL to dates with Params
  165. Updating In-Memory Tables
  166. int32 fields / exception getdatasize int32 unsupported type in query
  167. int32 fields etc.... / I found what it is
  168. DDL Create Table
  169. Updating string fields with wider values
  170. Simple SQL?
  171. Need help
  172. Need help improving query
  173. sql question
  174. Between Query
  175. Right Join with a not null
  176. Deleting a table
  177. sql don't work
  178. WHERE clause with Null Date
  179. Updating bytearray fields in SQL
  180. UNIQUE and NULL
  181. supported sql features
  182. Encrypted tables with CREATE TABLE?
  183. Need Help MAX()
  184. Some SQL questions
  185. Optimizing SQL Statements
  186. Urgent answer needed
  187. CAST on a Timefield returns date and time
  188. SQL Statement Kills Server
  189. SQL timeout
  190. extremely slow sql
  191. SQL Issue
  192. Join problem
  193. Live Results using Query
  194. "Limit" select statement
  195. Date from DateTime field
  196. My continuing education
  197. Changing/Updating 2 fields
  198. support for exponential format with INSERT/UPDATE
  199. Temporary Variable
  200. Changing Table,Field Names or types with SQL
  201. Problem with full outer join
  202. Re: Very Slow Query
  203. Re: Very Slow Query
  204. Allowed field names
  205. Code broke in 1.04
  206. Assertion Failure
  207. Update Sql statement
  208. Multi-Statement SQL
  209. More SQL Multi statements
  210. Limits on joining tables
  211. Slow SQL
  212. Question
  213. Capability not supported [$3001/12289]
  214. An SqL Memory tabled question
  215. Non Union Question
  216. OT- Distinct Usage
  217. This doesn't do what I expected
  218. Re: Fixing time fields
  219. Re: Support for heterogeneous joins or workaround
  220. Re: Support for heterogeneous joins or workaround
  221. Multiple SELECT statements as Tables - BUG?
  222. Double Table Join with COUNT causes Multiplied results
  223. Bug if used in OnDestroy of a Datamodule
  224. LEFT JOIN Not Working Properly with WHERE Clause
  225. query events
  226. Weird error when autoinc field has value of -1
  227. How to speed this up...
  228. Joining two tables contents
  229. Weird SQL
  230. This should not trigger an error
  231. Re: Multiple changes, one transaction, with SQL
  232. SQL of table definition
  233. SQL fails with embedded server, works with seperate
  234. SQL sometimes fails with a timeout
  235. Re: Multiple changes, one transaction, with SQL
  236. Memory table lifetime
  237. My Join problem
  238. DDL: expanding a field
  239. Time in SQL
  240. False "non aggregate column must appear in group by"
  241. Problems with SQL
  242. non agregate field required - why?
  243. why sum(coalesce(qty, 0)) returns null and not 0 with no records?
  244. Observation about possible optimization
  245. Problem with qualified asterisk
  246. Converting from DBISAM
  247. slow query with datefield param
  248. An SQL error involving BLOBs
  249. Query Timeout at 1200000ms (20 min)
  250. INSERTing MEMO data