FiveTech Software tech support forums

... Descricao>SERVICO</Descricao><Tributavel>1</Tributavel><Quantidade>1.0000</Quantidade><ValorUnitario>50.0000000000</ValorUnitario><ValorLiquido>0.00</ValorLiquido></ItemServico></ListaItensServico></Servico><Prestador><CpfCnpj><Cnpj>82039025000163</Cnpj></CpfCnpj><InscricaoMunicipal>00216490</InscricaoMunicipal></Prestador><Tomador><IdentificacaoTomador><CpfCnpj><Cnpj>20783933000100</Cnpj></CpfCnpj></IdentificacaoTomador><RazaoSocial>MGA ...

... ; FROM "Bematech_FI_CierraComprobanteNoFiscalVinculado" LIB oDp:nBemaDLL //Vende ítem DLL32 FUNCTION BmVendItem( Codigo AS STRING,; Descricao AS STRING,; Aliquota AS STRING,; TpQte AS STRING,; Quantid AS STRING,; Decimal AS 7 ,; ValUnit AS STRING,; TpDesc AS STRING,; ValDesc AS STRING ...

... again, it already brings me the previous search, how can I reset the search? Thanks in advance! Static Function ListaCon2() oPlano:SetOrder("DESCRICAO") oPlano:OrdScope(0,Nil) oPlano:OrdScope(1,Nil) oPlano:GoTop() DEFINE DIALOG oDlgConta RESOURCE "LISTACONTA2" Lista10 := TXBrowse():New( ...

... in use ================ 1: ARQRAM RddName: DBFCDX ============================== RecNo RecCount BOF EOF 6 5 .F. .T. Indexes in use TagName => DESCRICAO DESCRICAO Relations in use 2: CONFCTE RddName: DBFCDX ============================== RecNo RecCount BOF EOF 1 1 .F. .F. Indexes in use TagName ...

... Descricao":"CNPJ emissor nao autorizado para averbar...","ValorInformado":"009256139000175"}]}} ...

... ocorrencia dia ocorrência, ocorrencia.observacao," + ; " ocorrência.situacao, aluno.nome_aluno," + ; " tabocorrencia.descricao FROM `ocorrencia` JOIN aluno ON" + ; " aluno.matricula = ocorrencia.matricula" + ; " LEFT JOIN tabocorrencia on tabocorrencia.codigo ...

... not work. Shouldn't he use all the fields in the rowset independent table? Example: Doesn't work oTabela: = oCon: RowSet ( "SELECT codigo, descricao FROM ocorrencia") DEFINE VMENUITEM the item OF omenu; IMAGE ""; CAPTION "incluir "; ACTION (oTabela: EditBaseRecord ...

... not work. Shouldn't he use all the fields in the rowset independent table? Example: Doesn't work oTabela: = oCon: RowSet ( " SELECT codigo, descricao FROM ocorrencia ") DEFINE VMENUITEM the item OF omenu; IMAGE ""; CAPTION "incluir "; ACTION (oTabela: EditBaseRecord ...

how to make REQUERY with pagination ors := ::oSetup:oServer:RowSet("Select * from produtos ? order by descricao",{"where inactive = 'N'"}, 50) // pagination with 50 **** ERRO DON´T WORK... *** ors:Requery("where name like '%PINAPPLE% '") // WITH ...

how to make REQUERY with pagination ors := ::oSetup:oServer:RowSet("Select * from produtos ? order by descricao",{"where inactive = 'N'"}, 50) // pagination with 50 **** ERRO DON´T WORK... *** ors:Requery("where name like '%PINAPPLE% '") // WITH ...

Provavelmente algum campo das tabelas relacionadas está com o mesmo nome.

Vamos supor que o problema seja o campo "descrição", você teria que fazer algo assim:

SELECT c.*, t.descricao as descricaotabtest FROM client as c LEFT JOIN test as t...

Não sei o que há de errado nesta instrução: REDEFINE LISTBOX oLbx1 ; FIELDS Ds_Mar(cBmp), ( cAlias )->CODIGO, ( cAlias )->DESCRICAO ; HEADERS "","Cód", "Descrição" SIZES 30,70,150 ; CURSOR oHand ; ID 108 ALIAS cAlias OF Odlg Esta instrução funciona bem ...

oServer:Query("SELECT T1.produto,T1.descricao,T2.ESTOQLO from dig_gr01.slbdprod as T1 INNER JOIN dig_lj01.slbdploj as t2 on t1.produto = t2.produto")

... := { || fabricante->codigo } oCol:cHeader := 'Código' oCol:nWidth := 110 oCol:= CbRWTELA:AddCol() oCol:bStrData := { || fabricante->Descricao } oCol:cHeader := 'Razão Social' oCol:nWidth := 435 for nFor := 1 to 2 CbRWTELA:aCols[ nFor ]:blDClickData := {|r,c,f,o| (odbf:Fabric:=fabricante->codigo,mDescFabric:=fabricante->descricao, ...

Hola

/************************************/
FUNCTION ALTERARQUERY(obrw,oServer,oServerQry )
/*
*/
cQuery := "SELECT codigo,descricao FROM produtos order by descricao" ///<-ALTERAR QUERY
oServerQry := oServer:Query( cQuery )
oBrw:SetDolphin(oServerQry, .f.)
obrw:refresh()
return(.t.)