there is a problem when we use a subquery like below:
product -> id_prod, code, description
supplier -> id_prod, id_supplier
SELECT p.description,
(SELECT s.id_supplier
FROM supplier as s
WHERE s.id_supplier = p.id_supplier)
FROM product as p
it works from workbench but don't from xailer ...
In order for this site to work correctly we need to store a small file (called a cookie) on your computer. Most every site in the world does this, however since the 25th of May 2011, by law we have to get your permission first. Please abandon the forum if you disagree.
Para que este foro funcione correctamente es necesario guardar un pequeño fichero (llamado cookie) en su ordenador. La mayoría de los sitios de Internet lo hacen, no obstante desde el 25 de Marzo de 2011 y por ley, necesitamos de su permiso con antelación. Abandone este foro si no está conforme.
Para que este foro funcione correctamente es necesario guardar un pequeño fichero (llamado cookie) en su ordenador. La mayoría de los sitios de Internet lo hacen, no obstante desde el 25 de Marzo de 2011 y por ley, necesitamos de su permiso con antelación. Abandone este foro si no está conforme.
Se encontraron 177 coincidencias
- Lun Sep 10, 2012 9:47 pm
- Foro: Xailer Pro English
- Tema: mysql subquery problem
- Respuestas: 1
- Vistas: 1284
- Dom Sep 02, 2012 11:17 pm
- Foro: Xailer Pro English
- Tema: problem with TFolder
- Respuestas: 3
- Vistas: 2191
problem with TFolder
lMultiLine does not work, can it be fixed?
- Dom Sep 02, 2012 3:24 pm
- Foro: Xailer Pro English
- Tema: problem with TShiftPanel
- Respuestas: 1
- Vistas: 1157
problem with TShiftPanel
Shortcuts of controls inside of a closed TShiftPanel still can be accessed
- Mar Ago 28, 2012 11:37 pm
- Foro: Xailer Pro English
- Tema: delphi dll call
- Respuestas: 7
- Vistas: 3814
delphi dll call
NO HELP!?
- Lun Ago 27, 2012 10:32 pm
- Foro: Xailer Pro English
- Tema: delphi dll call
- Respuestas: 7
- Vistas: 3814
delphi dll call
please, help!
here is a fragment of the delphi code:
Function Inicia_SPED(Dir_Saida, Dir_Entrada: String): integer; stdcall; export;
var
i: integer;
begin
result := -1; //Retorna Erro por default
the paramters Dir_Saida and Dir_Entrada "comes" with crazy values! For example it shoud be "E ...
here is a fragment of the delphi code:
Function Inicia_SPED(Dir_Saida, Dir_Entrada: String): integer; stdcall; export;
var
i: integer;
begin
result := -1; //Retorna Erro por default
the paramters Dir_Saida and Dir_Entrada "comes" with crazy values! For example it shoud be "E ...
- Sab Ago 25, 2012 1:43 am
- Foro: Xailer Pro English
- Tema: delphi dll call
- Respuestas: 7
- Vistas: 3814
delphi dll call
Mario,
Grato pela resposta.
Pelo que ja pesquisei deve ter algo a ver com o tipo de dado recebido pela funcao. Ela foi feita em Delphi 6 e o fornecedor nao dã suporte para (x)Harbour, infelizmente. Algumas chamadas funcionam sem problemas, mas esta, que inicia as funcoes para gerar o arquivo do ...
Grato pela resposta.
Pelo que ja pesquisei deve ter algo a ver com o tipo de dado recebido pela funcao. Ela foi feita em Delphi 6 e o fornecedor nao dã suporte para (x)Harbour, infelizmente. Algumas chamadas funcionam sem problemas, mas esta, que inicia as funcoes para gerar o arquivo do ...
- Vie Ago 24, 2012 9:08 pm
- Foro: Xailer Pro English
- Tema: delphi dll call
- Respuestas: 7
- Vistas: 3814
delphi dll call
thank you so much, Jose.
Following is what I know about one function. There are more than 100 like this. Some of then works perfectly, some not.
Name: Inicia_SPED
Parent: SPEDFiscal32dll
Visibility: PUBLIC
Description: Inicia_SPED - Esta deve ser sempre a 1ª Função a ser chamada antes de ...
Following is what I know about one function. There are more than 100 like this. Some of then works perfectly, some not.
Name: Inicia_SPED
Parent: SPEDFiscal32dll
Visibility: PUBLIC
Description: Inicia_SPED - Esta deve ser sempre a 1ª Função a ser chamada antes de ...
- Vie Ago 24, 2012 3:14 pm
- Foro: Xailer Pro English
- Tema: delphi dll call
- Respuestas: 7
- Vistas: 3814
delphi dll call
Hi,
I'm using a delphi dll. I can load and call some functions, but when I need to pass a parameter it appear to be wrong. For exemple:
cPath := "C:Temp"
aList := DllCall("filesutil.dll", NIL, "getfiles", cPath)
It should returns an array with file names, but I get a message
like this:
"cPath ...
I'm using a delphi dll. I can load and call some functions, but when I need to pass a parameter it appear to be wrong. For exemple:
cPath := "C:Temp"
aList := DllCall("filesutil.dll", NIL, "getfiles", cPath)
It should returns an array with file names, but I get a message
like this:
"cPath ...
- Dom Ago 05, 2012 3:18 am
- Foro: Xailer Spanish
- Tema: Dúvida sobre migração
- Respuestas: 11
- Vistas: 6916
Dúvida sobre migração
Passei por este drama a alguns anos atraz. Resumindo: é muito difícil, senão impossível, passar para o ambiente grfico de verdade e aproveitar o que foi feito em modo console´(em termos de interface). Cheguei a comprar o RDDSQL, o FiveWin e outras ferramentas como o visual-xharbour, mas nada se ...
- Mar Jul 24, 2012 4:31 pm
- Foro: Xailer Pro English
- Tema: To JLalin
- Respuestas: 0
- Vistas: 6909
To JLalin
Dear Sir,
Can you update this component to version 2.6 of Xailer?
It have a little problem: when we add a control with nAlign <> 0 the title is covered.
Tanks,
Can you update this component to version 2.6 of Xailer?
It have a little problem: when we add a control with nAlign <> 0 the title is covered.
Tanks,
- Sab Jun 23, 2012 1:38 pm
- Foro: Xailer Spanish
- Tema: Consultas
- Respuestas: 5
- Vistas: 4884
Consultas
There is no product like Xailer. You will love it.
- Dom May 27, 2012 3:31 am
- Foro: Xailer Pro English
- Tema: column value when using nedittype
- Respuestas: 1
- Vistas: 1259
column value when using nedittype
hi,
how do I get the value, not the key?
It's so confuse, it should work but it don't...
Attached files Test6.zip (6.1 KB)Â
how do I get the value, not the key?
It's so confuse, it should work but it don't...
Attached files Test6.zip (6.1 KB)Â
- Jue May 24, 2012 3:44 pm
- Foro: Xailer Pro English
- Tema: roundgroupbox to 2.6
- Respuestas: 1
- Vistas: 1296
roundgroupbox to 2.6
Hi,
It's not working on 2.6.
tks
It's not working on 2.6.
tks
- Jue May 24, 2012 2:17 pm
- Foro: Xailer Pro English
- Tema: Capturing a return Value from Stored procedures
- Respuestas: 2
- Vistas: 1892
Capturing a return Value from Stored procedures
bom trabalho, Pedro.
Voce tem alguma ideia de como se pode executar dois comandos sem chamar Execute duas vezes? Eu uso o MySQL, uma beleza, mas as vezes preciso importar algum arquivo como notas fiscais e demora muito para adicionar registros porque cada nota chega a ter 200 itens e, cada item ...
Voce tem alguma ideia de como se pode executar dois comandos sem chamar Execute duas vezes? Eu uso o MySQL, uma beleza, mas as vezes preciso importar algum arquivo como notas fiscais e demora muito para adicionar registros porque cada nota chega a ter 200 itens e, cada item ...
- Sab May 19, 2012 4:37 pm
- Foro: Xailer Pro English
- Tema: tftp
- Respuestas: 5
- Vistas: 2225
tftp
tks,
I did it and it's working fine
btw, TLabelEx seems to be not working well. I did some tests and the program stops responding. Then I changeg to Tlabel and everything worked fine.
I did it and it's working fine
btw, TLabelEx seems to be not working well. I did some tests and the program stops responding. Then I changeg to Tlabel and everything worked fine.
- Vie May 18, 2012 11:38 pm
- Foro: Xailer Pro English
- Tema: tftp
- Respuestas: 5
- Vistas: 2225
tftp
tks for ur answer,
yes, but I want this information from a remote file, not local.
yes, but I want this information from a remote file, not local.
- Vie May 18, 2012 4:30 pm
- Foro: Xailer Pro English
- Tema: tftp
- Respuestas: 5
- Vistas: 2225
tftp
Hi,
Is there a way to get the exe file version?
I'm using the date/time to know if there is a new version, but it depend on the user's machine time.
tks
Is there a way to get the exe file version?
I'm using the date/time to know if there is a new version, but it depend on the user's machine time.
tks
- Jue May 17, 2012 5:28 pm
- Foro: Xailer Pro English
- Tema: mysql execute
- Respuestas: 1
- Vistas: 1077
mysql execute
Hi,
Is there a way to execute more than one command using execute?
for exemple:
// sql is a tmysqldatasource
sql:execute([SET @name="Roberto"])
sql:execute([SET @ide="XAILER"])
I would like to get the same result using only one command, like this:
sql:execute([SET @user="Roberto"; SET @ide ...
Is there a way to execute more than one command using execute?
for exemple:
// sql is a tmysqldatasource
sql:execute([SET @name="Roberto"])
sql:execute([SET @ide="XAILER"])
I would like to get the same result using only one command, like this:
sql:execute([SET @user="Roberto"; SET @ide ...
- Mié May 09, 2012 5:37 am
- Foro: Xailer Pro English
- Tema: MYSQL: stop a running query
- Respuestas: 1
- Vistas: 1150
MYSQL: stop a running query
Hi,
I have a form where I get an user input to search for in a table. Each time the user change the value I want to get the records that match the request. If I start a query and the user is still typing his text I want to stop the current query and update the searched value. Is there a way to do ...
I have a form where I get an user input to search for in a table. Each time the user change the value I want to get the records that match the request. If I start a query and the user is still typing his text I want to stop the current query and update the searched value. Is there a way to do ...
- Lun May 07, 2012 9:14 pm
- Foro: Xailer Pro English
- Tema: mysql type bigint does not work
- Respuestas: 1
- Vistas: 1128
mysql type bigint does not work
Hi,
BIGINT return wrong value from database
BIGINT return wrong value from database
- Lun Abr 09, 2012 11:07 pm
- Foro: Xailer Pro English
- Tema: como carregar uma dll feita em dephi? / how to load a Delphi DLL?
- Respuestas: 1
- Vistas: 1007
como carregar uma dll feita em dephi? / how to load a Delphi DLL?
Preciso carregar uma DLL feita em Dephi 2007, so que LoadLibrary("test.dll") retorna 0.
I need to use a delphi dll but loadlibrary("test.dll") returns 0
I need to use a delphi dll but loadlibrary("test.dll") returns 0
- Mié Abr 04, 2012 5:11 am
- Foro: Xailer Pro English
- Tema: TPrinter:Setup()
- Respuestas: 0
- Vistas: 7143
TPrinter:Setup()
Please, correct the documentation about this method. It returns .T. if Ok is pressed or .F. if Cancel is pressed and not Nil as the current documentation says.
There are a lot of things like that and they makes us spend our time waiting for things that does not happen. So we have to make the ...
There are a lot of things like that and they makes us spend our time waiting for things that does not happen. So we have to make the ...
- Jue Mar 29, 2012 4:09 am
- Foro: Xailer Pro English
- Tema: got/lost focus
- Respuestas: 1
- Vistas: 1099
got/lost focus
Hi,
Is there a way to use gotfocus and lostfocus with an TPanel, TBevel or other controls that don't receives de focus directly? (like tedit and so on)
I would like to do some work BEFORE/AFTER the control inside a TBevel got/lost the focus. Events OnEnter/OnExit does not work with then (I guess ...
Is there a way to use gotfocus and lostfocus with an TPanel, TBevel or other controls that don't receives de focus directly? (like tedit and so on)
I would like to do some work BEFORE/AFTER the control inside a TBevel got/lost the focus. Events OnEnter/OnExit does not work with then (I guess ...
- Mié Mar 28, 2012 8:24 pm
- Foro: Xailer Pro English
- Tema: codejock how to...
- Respuestas: 1
- Vistas: 1084
codejock how to...
Hi,
I'm testing codejock, but I don't know how to create a control inside another, like this:
with object oGroup := TGroupBox():create(oForm)
:caption := "main group"
end
with object oLabel := TLabel():create( ??? )
:caption := "this is a label"
end
??? means: what should I have to put here ...
I'm testing codejock, but I don't know how to create a control inside another, like this:
with object oGroup := TGroupBox():create(oForm)
:caption := "main group"
end
with object oLabel := TLabel():create( ??? )
:caption := "this is a label"
end
??? means: what should I have to put here ...
- Vie Mar 16, 2012 11:13 am
- Foro: Xailer Spanish
- Tema: Tipo de control
- Respuestas: 3
- Vistas: 2536
Tipo de control
try this:
SetKey(119, , { || myActiveControl(Self:oActiveControl) })
FUNCTION myActiveControl(oControl)
WITH OBJECT oControl
DO CASE
CASE :IsKindOf("TImage")
MsgInfo("es imagen, haz tal cosa")
CASE :IsKindOf("TButton")
MsgInfo("es un boton, haz tal otra")
OTHERWISE
MsgInfo("es otro ...
SetKey(119, , { || myActiveControl(Self:oActiveControl) })
FUNCTION myActiveControl(oControl)
WITH OBJECT oControl
DO CASE
CASE :IsKindOf("TImage")
MsgInfo("es imagen, haz tal cosa")
CASE :IsKindOf("TButton")
MsgInfo("es un boton, haz tal otra")
OTHERWISE
MsgInfo("es otro ...