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. Token: 1, Line Number: 1 Delphi V7 - object pascal, standard Tquery object name query1. ...
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 Journal.[Where] as "Location" - with the same result. Journal.db is a file created by a...
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 virtual 'tables' that I can supply to DBGrid's or DBChart's that look like they each conta...
Hi, 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. ...
Hi, 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 required data. I have created the following query: But I keep getting the IP property...
Hi, 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); //Separate unit, owner set to App Q.Connection:=dtMod.ADOCon; Q.DisableControls;...