3
I heard that the FD has to program for two different database managers using the same FDQuery
, that is, could put the two SQL s of each bank in the same FDQuery
... or something like that...
Hold on there’s some tutorial for this?
3
I heard that the FD has to program for two different database managers using the same FDQuery
, that is, could put the two SQL s of each bank in the same FDQuery
... or something like that...
Hold on there’s some tutorial for this?
4
Hello, yes possible. The component to be used is FDLocalSQL
, where you would basically do the SELECT
of a FDQuery
.
In practice, it works like this:
FDLocalSQL
;LocalSQL
of each dataset in the component FDLocalSQl
;FDConnection
with Driver SQLite
;FDQuery
on the form;FDLocalSQL
and the new Query in FDConnection
of item 4.0;FDQuery
, insert SQL referencing each Query as
being a table.
Ex.: SELECT NOME FROM FDQUERY1 JOIN FDQUERY2 ON (FDQUERY1.CAMPO = FDQUERY2.CAMPO)
;Browser other questions tagged delphi firedac
You are not signed in. Login or sign up in order to post.