Zeoslib Portal

SQLite3 --- Alternatively do you know is there an existing way to dump a DB to an SQL Query and then run that on the new DB?

I'm using Delphi EX2 and SQLite3 and I have two separate database files that I need to merge via an SQL statement like: INSERT INTO DatabaseOne.TableOne (FieldNameOne, FieldNameTwo, FieldNameThree) SELECT FieldNameOne, FieldNameTwo, FieldNameThree FROM DatabaseTwo.TableOne I have a feeling that a tz...

I am just getting started with ZeosLib and SQLite3 and I ran into some situations--like the lack of boolean support in SQLite3--that required some patching on my part that I think might be useful to other people. I added a property to the Ancestor of tzConnection: AutoRefreshTableAfterSQLExec which ...

Okay, I'll give that a shot! Thanks for the quick feedback. Also, slightly off topic, but where is the best documentation for the Zeoslib components? There are quite a number of components, like Sequencers, that I haven't run into before but I can't find a good explanation of what they are used for.

I have a SQLite3 Database and have set the tzConnection to auto-commit but when I run the following procedure it does nothing to the table, the record count remains unchanged. procedure EmptyTable(inTable:tzTable); begin MyQuery:=tzQuery.Create(nil) MyQuery.Connection := inTable.Connection; MyQuery....

I'm not following -- basically I want to do a query which returns the closest city to a given longitude and latitude. The Table of Cities contains, CityName, ClityLongitude and CityLatitude. The accurate calculation of distance is a mess of squares, sins, cos arctan2, sqrt and it seems like they sho...

Nope, back offline.

SELECT *, SIN(LONGITUDE-655)*COS(LATITTUDE-32) as Distance FROM CITIES ORDER BY Distance Obviously the math there I just made up :D but that's the idea of what I want to do. Or another example which does work as is, but would be much cleaner if I had access to SQUARE function for example SELECT *, (...

I found the function definitions in ZFunctionsMath and they SEEM to be created but whenever I try to use them in an SQL Statement it fails, badly. ASC() however seems to work.

I am using Delphi EX2 and SQLite3 in case that makes a difference.

Thanks in advance,

Ken