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
1
vote
1 answer

Disabling the login prompt without using the TDatabase bypass

I am currently trying to connect to a database using an ODBC Alias to SQL Server. The problem I'm having is that when I use my TQuery object to get the information it always requests login details (nevermind whether I've specified them in the ODBC…
gn12345
  • 335
  • 1
  • 3
  • 11
1
vote
3 answers

How to extract a set of records with a specific field from a Delphi in-memory data table

I've an in-memory table that I've populated with data from a custom-format file. I'd like to use this as a repository for the data without duplicating it elsewhere. Each record has a special tag field which can be 1..30. I'd like to create up to 30…
Brian Frost
  • 13,334
  • 11
  • 80
  • 154
1
vote
1 answer

How to get Physijs and Threejs to work together with tQuery

Good evening, I recently switched from EaselJS to Threejs, it's amazing! I've tried to include a physic engine called Physijs and use it with tQuery with this tutorial but it's not working. Head:
Jeremy Dicaire
  • 4,615
  • 8
  • 38
  • 62
1
vote
1 answer

Retrieve datename from SQL on DELPHI

Im using Delphi XE2 and SQL Server 2005 Express. I have a table named maintenance with the columns: id Integer; Activity Varchar(x); = actividad Description Memo; = descripcion Day Integer;= dia_sem User Integer; = usuario id, activity,…
Edgar Holguin
  • 179
  • 1
  • 4
  • 11
0
votes
0 answers

Cannot get result from tQuery after success connected to SQL Server 2019 Express from my old Delphi 7 (using BDE and SQL Server as Driver Name)

I'm trying to access into a database in SQL Server 2019 Express from my old Delphi 7 project that still using BDE and SQL Server as Driver name (for migration only). With the db1 (tDatabase) setting like this: DATABASE NAME=master USER NAME=sa ODBC…
Jasen
  • 1
  • 2
0
votes
0 answers

Delphi TQuery result set - how to avoid the caveats of having RequestLive set to true

I use Delphi 10.2 with ComponentAce's Absolute Database framework. So my question here can pertain to TAbsQuery or, I presume, the conventional Delphi TQuery class. My database has a date field named lastViewed. I have the RequestLive set to true…
0
votes
0 answers

Delphi and Oracle - Cannot access field "TRANSACTIONS" in a filter

when trying to access the value of a field it does not allow me to obtain it, I am doing it in OnFiltered of the DataSet. procedure TFrm_Transactions.qry_personal_trxsFilterRecord(DataSet: TDataSet; var Accept: Boolean); var vprs, vtrxs:…
Amaudys
  • 1
  • 1
0
votes
1 answer

Help with Parameterized Query (using Delphi 7 and BDE)

Can someone help me and explain to my why this code crashes on the ExecSQL statement? function UpdateLastBankResponsesId(ADatabase: TDatabase; AValue: Integer): String; var AQuery2: TQuery; begin result:= ''; AQuery2:= TQuery.Create(nil);…
IElite
  • 1,818
  • 9
  • 39
  • 64
0
votes
1 answer

Render IP CAMERA stream with three.js

I'm trying to render video stream from an IP Camera to a three.js texture, but I cannot find how to. I am trying something like this: .... var video = document.createElement('video'); video.crossOrigin="anonymous"; video.width = 320; video.height …
0
votes
1 answer

Need to create tql queries

I need to create TQL queries to query out sets of data from the UCMDB. I am having 2 problems: 1) How can I find relationships which exists between CIs ( i do not have administrative privileges so need to do it in code somehow) I need this to get…
JJunior
  • 2,831
  • 16
  • 56
  • 66
0
votes
2 answers

prob. with tquery.requestlive

Do anyone know how to request a "live result set" in MySql when query has offset(eg: select * from table limit 10 offset 20;). it is throughing an error like 'invalid use of keyword' . Thanks, Vijay.
Vijay Bobba
  • 313
  • 4
  • 15
0
votes
1 answer

How to display tQuery.World in a canvas HTML5

i think it is as simple as it sounds, but i just can't find anything that can help me. var canvas = document.getElementById("canvas"); var world = tQuery.createWorld().boilerplate(); world.start(); what should i do, to display it in the…
Hehe Muha
  • 19
  • 6
-2
votes
1 answer

Delphi XE10, can't edit field values of an empty TQuery

I have a dataset, TQuery object with property Requestlive=TRUE, Tdatasource and a TDBgrid, connected. When the query returns empty i face this problem : Trying to add the first record, i can't edit the fields of it. After saving this (empty) first…
JimPapas
  • 715
  • 2
  • 12
  • 27
-2
votes
1 answer

unusual record count in TQuery.Record count

I have one Delphi application that connects to MS-SqlServer-2008R2 via BDE + ODBC. Developed using Delphi 7. Accessing data using TDatabase, TTable, TQuery components. The TDatabase is point to Alias name in BDE, and other components using the…
bejarun
  • 175
  • 3
  • 11
-2
votes
2 answers

Creating tables and displaying without RAD components

My job gave me a challenge to do the following... I am still a rookie and learning as fast as I can but I have this curve ball and can't quite get my mind to it. If it is not to much trouble... how can I create, modify and display Tables with the…
Peanut
  • 33
  • 2
  • 10
1
2