Comments (3)
[deleted comment]
from txquery.
I take it back, test code seems to be working correct.
Tried this in the TTest_Join.Test_EmptyKeyJoin_InnerJoin()
...
with FQuery.SQL do begin
Clear;
Add('SELECT A.[Test-1], B.ItemCode');
Add( 'FROM D1 A INNER JOIN D2 B ON (A.[Test-1]=B.[Test-2])');
end;
Without the square brackets it gets a parse error, with them it seems to work
correctly...will need to test some more.
Original comment by [email protected]
on 14 Aug 2013 at 6:09
from txquery.
My fault the hyphen with square brackets works correctly. Issue was me missing
the first SELECT id.
Solved.
Original comment by [email protected]
on 14 Aug 2013 at 8:40
from txquery.
Related Issues (20)
- Updated and improved Sources Of TXQuery 2012-09-13, based on r28 [Posted HERE] HOT 1
- Updated and improved Sources Of TXQuery 2012-09-17, based on r28 [Posted HERE]
- Updated and improved Sources Of TXQuery 2012-09-24, based on r28 [Posted HERE] HOT 2
- Recno Out of Range HOT 2
- Updated and improved Sources Of TXQuery 2012-11-29, based on r28 [Posted HERE] (fixes Delphi 2007 and below) HOT 1
- LargeInt data type not supported in parameters
- Updated and improved Sources Of TXQuery 2012-11-29, based on r28 [Posted HERE] (fixes Delphi 2010) HOT 1
- Updated and improved Sources Of TXQuery 2013-04-13, based on rev. 2012-10-11 [Posted HERE] (fixes Delphi XE3 issues) HOT 5
- Updated and improved Sources Of TXQuery 2013-05-15, (based on rev. 2012-10-11 by cychau) [Posted HERE] (Added Full Unicode support) HOT 16
- Usage of NULL in where clause fails HOT 4
- Multi-relation fields of Master-detail not work HOT 6
- SUM,AVG,MAX not work HOT 3
- Null value in source field causes incorrect & unexpected results on rare occasions HOT 5
- Refresh does not work HOT 1
- DateFormat error on TxQuery 3.01 HOT 3
- Please Support ios/android
- GUID Field Bug HOT 1
- Delphi 7 HOT 1
- Time Fields
Recommend Projects
-
React
A declarative, efficient, and flexible JavaScript library for building user interfaces.
-
Vue.js
🖖 Vue.js is a progressive, incrementally-adoptable JavaScript framework for building UI on the web.
-
Typescript
TypeScript is a superset of JavaScript that compiles to clean JavaScript output.
-
TensorFlow
An Open Source Machine Learning Framework for Everyone
-
Django
The Web framework for perfectionists with deadlines.
-
Laravel
A PHP framework for web artisans
-
D3
Bring data to life with SVG, Canvas and HTML. 📊📈🎉
-
Recommend Topics
-
javascript
JavaScript (JS) is a lightweight interpreted programming language with first-class functions.
-
web
Some thing interesting about web. New door for the world.
-
server
A server is a program made to process requests and deliver data to clients.
-
Machine learning
Machine learning is a way of modeling and interpreting data that allows a piece of software to respond intelligently.
-
Visualization
Some thing interesting about visualization, use data art
-
Game
Some thing interesting about game, make everyone happy.
Recommend Org
-
Facebook
We are working to build community through open source technology. NB: members must have two-factor auth.
-
Microsoft
Open source projects and samples from Microsoft.
-
Google
Google ❤️ Open Source for everyone.
-
Alibaba
Alibaba Open Source for everyone
-
D3
Data-Driven Documents codes.
-
Tencent
China tencent open source team.
from txquery.