Stack Overflow
Stack Overflow

Questions tagged [tquery]

For issues relating to the tQuery JavaScript library.

tQuery (three.js + jQuery) is a thin JavaScript library on top of three.js. It is an extension system to help people to share their code and build on top of each other at writing plugins.

30 questions
13
votes
5 answers

Delphi TQuery save to csv file

I want to export content of a TQuery to a CSV file without using a 3d part component(Delphi 7). From my knowledge this can not be accomplished with Delphi standard components. My solution was to save the content in a StringList with a CSV format,…
RBA
  • 12,337
  • 16
  • 79
  • 126
7
votes
4 answers

Delphi: Paradox DB Field Name Issue (Spaces in field name)

I have a paradox table from a legacy system I need to run a single query on. The field names have spaces in them - i.e. "Street 1". When I try and formulate a query in delphi for only the "Street 1" field, I get an error - Invalid use of keyword.…
SatJoe
5
votes
1 answer

Is Query.Close necessary after Query.ExecSQL?

In Delphi, whenever I use a TQuery to perform a SELECT on a database, I follow the Query.Open with a try..finally, with Query.Close in the finally section. This makes sense to me, as the Query would still be storing data (using memory) unnecessarily…
Andrew W
  • 67
  • 1
  • 4
5
votes
1 answer

How to use HTML5 Web Audio API to record my voice

I'm looking for a way to record my voice and - according to the recorded voice - move an animation towards left or right. I heard HTML5 has an Audio API through which you can record your voice, but I have no idea how to do that. I will be thankful…
Saurabh
  • 955
  • 6
  • 14
  • 22
4
votes
8 answers

delphi "Invalid use of keyword" in TQuery

I'm trying to populate a TDBGrid with the results of the following TQuery against the file Journal.db: select * from Journal where Journal.where = "RainPump" I've tried both Journal."Where" and Journal.[Where] to no avail. I've also tried: select…
Baldric
  • 303
  • 1
  • 4
  • 10
3
votes
5 answers

Query optimization in Delphi 4

In Delphi 4, we have one SELECT query which is fetching 3 Text type fields along with other required fields at a time using a TQuery component. There are more than 1,000 records (which might increase in future). This query consumes lots of memory.…
Dev
  • 629
  • 2
  • 9
  • 23
3
votes
1 answer

How can I query a value in SQL Server TEXT column that contains XML (not xml column type)

I have table DOCUMENTS with: DOCUMENTS ____________________ DOCUMENTID int USERID int CONTENT text I have following XML stored in TEXT column with name CONTENT in a SQL Server database
RCancer
  • 33
  • 1
  • 4
3
votes
3 answers

How to ignore some parameters in TQuery

If i have a SQL statement like below SELECT * FROM myTable WHERE CID = :vCID AND DataType = :vDataType And usually i use TQuery to get some data like below aQuery.ParamByName('vCID').Value := '0025'; aQuery.ParamByName('vDataType').AsInteger :=…
Leo.W
  • 299
  • 1
  • 7
  • 21
3
votes
1 answer

Getting EDBEngineError - Operation Not Applicable in Delphi XE2 on ExecSQL Statement

I am using TQuery to insert record into table. Below is the code for that. with qryABC do begin Close; SQL.Clear; SQL.Text := 'INSERT INTO tableXYZ (ID) values (:ID)'; ParamByName('ID').Value := AnyID; ExecSQL; …
user1556433
2
votes
3 answers

WebGL Change Shape Animation

I'm creating a 3D globe with a map on it which is supposed to unravel and fill the screen after a few seconds. I've managed to create the globe using three.js and webGL, but I'm having trouble finding any information on being able to animate a shape…
ise
  • 228
  • 2
  • 8
2
votes
1 answer

tQuery event handler on cube

I just started trying webgl with tQuery and well.. the simpliest code is: var world = tQuery.createWorld().boilerplate().start(); var object = tQuery.createCube().addTo(world); now I want to emit some data to node if there's been clicked on that…
user1672022
  • 21
  • 1
1
vote
2 answers

Delphi - Using different TTable and TQuery as one object

Delphi 2010, Win7 - 64 I am writing an app which involves connecting to different databases. I use two different vendors for database access. I use AnyDAC, by DA-Soft, which allows me to connect to "industrial" databases, Oracle, SQL Server, etc,…
user1009073
  • 3,160
  • 7
  • 40
  • 82
1
vote
2 answers

How To Increment Numbers in Calculated field of TQuery?

I Have TQuery With Calculated Field N. How To Increment Numbers in the example (N starts with 5): I tried this but Nothing: procedure TForm1.Query1CalcFields(DataSet: TDataSet); var i:integer; begin i := strtoint(edit2.Text); Query1['N'] :=…
Asad Alamdar
  • 158
  • 8
1
vote
6 answers

Delphi: TAdoQuery Memory Leak?

I'm developing as small diabetes program using Delphi 5 and ADO. I do a little query like this: function GetLowestGlucoseLevel(StartDate:string;EndDate:string): Integer; var Q:TADOQuery; begin try Q:=TADOQuery.Create(Application);…
AFF
  • 61
  • 2
  • 4
1
vote
2 answers

TEdit and TQuery

I have class: TcvDbedit = class(TCustomMaskEdit) ... private ... fQuery: TQuery; ... protected ... public constructor Create(AOwner: TComponent); override; destructor Destroy; override; ... published ... property DataQuery: TQuery…
user1969258
  • 99
  • 2
  • 7
1
2