natalie

Resultou;) Obrigada

Ola;) alguém sabe alguma maneira d s verificar se os dados da hora estao certos e s n estiverem mandar 1a mensagem d erro. Por exemplo, eu tnh if not strToTime(campo.Text) = 'formato_hora' then //formato_hora é o q n sei showmessage('erro'); brigada;)

oi, Há alguma forma de obrigar que o formato num TEdit seja o da hora? Ou seja 00:00? Obrigada;)

Tens que fazer showmessage da sting... Eu fiz evaluate e é exactamente a partir do caracter 4095 q começa o lixo... Deve ser mesmo ixo q ta mal...

estive a peskiar na net e talvez p problema tenha quando a string aux_str chega ao caracter 4096. Axo q n há nada a fazer:( Axo que é mesmo 1 erro do sistema

Eu utilizo um 'and' porque a aux_str é para dps fazer um filter... A variavel aux_str é local. Poxo-t mandar o procedimento q tou a fazer porque o projecto é muito grande ;) Aki vai : procedure TTabelas.Pesquisa(Tabela: TTable); var aux_str : string; primeiro, primeiro_qr, i, ncampos: Integer; begin primeiro := 0; ncampos := Tabela.FieldCount; i := 0; aux_str := ''; repeat if (not Tabela.Fields.IsNull) and (Tabela.Fields.FieldName <> 'CRIADO_POR') and (Tabela.Fields.FieldName <> 'CRIADO_EM') and (Tabela.Fields.FieldName <> 'ACTUALIZADO_POR') and (Tabela.Fields.FieldName <> 'ACTUALIZADO_EM') then begin if primeiro = 0 then begin if Tabela.Fields.DataType in [ftSmallint,ftInteger,ftWord] then aux_str := Tabela.Fields.FieldName + ' = ' + FloatToStr(Tabela.Fields.AsInteger) + ' ' else if Tabela.Fields.DataType in [ftFloat] then aux_str := Tabela.Fields.FieldName + ' = ' + FloatToStr(Tabela.Fields.AsFloat) + ' ' else if Tabela.Fields.DataType in [ftString, ftMemo] then if Tabela.Fields.AsString <> '' then begin QR_Geral.Close; QR_Geral.Sql.Clear; QR_Geral.Sql.Add('Select Distinct '+Tabela.Fields.FieldName+' From '+ Tabela.TableName+' Where Upper('+ Tabela.Fields.FieldName+') Like '+#39+'%'+UpperCase(Tabela.Fields.AsString)+'%'+#39+' '); QR_Geral.Open; primeiro_qr := 0; QR_Geral.First; while QR_Geral.EOF = False do begin if primeiro_qr = 0 then begin aux_str := Tabela.Fields.FieldName + ' = ''' + QR_Geral.Fields[0].Text + '''' ; primeiro_qr := 1; end else begin aux_str := aux_str + ' or ' + Tabela.Fields.FieldName + ' = ''' + QR_Geral.Fields[0].Text + '''' ; end; QR_Geral.Next; end; end else if Tabela.Fields.DataType in [ftDate,ftTime,ftDateTime] then //aux_str := Tabela.Fields.FieldName + ' = to_date(''' + DateToStr(Tabela.Fields.AsDateTime) + ''',''yyyy-mm-dd'')' + ' '; aux_str := Tabela.Fields.FieldName + ' = ' + DateToStr(Tabela.Fields.AsDateTime) + ' '; primeiro := 1; end else if Tabela.Fields.DataType in [ftSmallint,ftInteger,ftWord] then aux_str := aux_str + ' and ' + Tabela.Fields.FieldName + ' = ' + FloatToStr(Tabela.Fields.AsInteger) + ' ' else if Tabela.Fields.DataType in [ftFloat] then aux_str := aux_str + ' and ' + Tabela.Fields.FieldName + ' = ' + FloatToStr(Tabela.Fields.AsFloat) + ' ' else if Tabela.Fields.DataType in [ftString, ftMemo] then if Tabela.Fields.AsString <> '' then begin QR_Geral.Close; QR_Geral.Sql.Clear; QR_Geral.Sql.Add('Select Distinct '+Tabela.Fields.FieldName+' From '+ Tabela.TableName+' Where Upper('+ Tabela.Fields.FieldName+') Like '+#39+'%'+UpperCase(Tabela.Fields.AsString)+'%'+#39+' '); QR_Geral.Open; primeiro_qr := 0; QR_Geral.First; while QR_Geral.EOF = False do begin if primeiro_qr = 0 then begin aux_str := aux_str + ' and ' + Tabela.Fields.FieldName + ' = ''' + QR_Geral.Fields[0].Text + '''' ; primeiro_qr := 1; end else begin aux_str := aux_str + ' or ' + Tabela.Fields.FieldName + ' = ''' + QR_Geral.Fields[0].Text + '''' ; end; QR_Geral.Next; end; end else if Tabela.Fields.DataType in [ftDate,ftTime,ftDateTime] then aux_str := aux_str + ' and ' + Tabela.Fields.FieldName + ' = ' + DateToStr(Tabela.Fields.AsDateTime) + ' '; end; i := i + 1; Until (i = ncampos - 1); if aux_str = '' then begin ShowMessage('Parametros não definidos.'); Tabela.Cancel; end else begin showmessage(aux_str); Tabela.Cancel; Tabela.Filter := aux_str; Tabela.Filtered := True; end; end;

Os campos da minha tabelas são todos strings... Eu já pus o first e não resolve nada...A String esta a retornar o mesmo que eu mencionei na primeira msg

Eu já estive a testar e o q a query retorna ta certo..o q eu axo é q a string a partir d certa altura 'paxa-s' e comeca a escrever lixo... Experimentei o query.first e ta resolve nada...A aux_str retorna lixo a mesma:(

i:=0; aux_str := ''; repeat if (not Tabela.Fields.IsNull) while QR_Geral.EOF <> TRUE do begin aux_str := aux_str + ' and ' +Tabela.Fields.FieldName + ' = ''' + QR_Geral.FieldbyName(Tabela.Fields.FieldName).AsString + '''' ; QR_Geral.Next; end; i:=i+1; Until (i = ncampos - 1); Assim é ta certo:)

i:=0; aux_str := ''; if (not Tabela.Fields.IsNull) while QR_Geral.EOF <> TRUE do begin aux_str := aux_str + ' and ' +Tabela.Fields.FieldName + ' = ''' + QR_Geral.FieldbyName(Tabela.Fields.FieldName).AsString + '''' ; QR_Geral.Next; end; i:=i+1; Tou incrementado o i para ir a todos os campos da tabela

Não faço append, eu concateno... Aki vai a maneira como faço a a concatenação: aux_str := ''; . . . . while QR_Geral.EOF <> TRUE do begin aux_str := aux_str + ' and ' +Tabela.Fields.FieldName + ' = ''' + QR_Geral.FieldbyName(Tabela.Fields.FieldName).AsString + '''' ; QR_Geral.Next; end; Se me conseguirem ajudar;)

Ola:) Eu tnh uma string que vou fazendo append ao longo de um ciclo. No fim a string tem 'lixo' a partir d certa altura. A string fica 'TIT_PED = 'A descrição dos exames é cortada no envio para o PACS, se recebida do Alert.' or TIT_PED = 'A funcionalidade "Filtrar" no ecrã Requisições - Exames Requisitados, deveria fu' or TIT_PED = 'Acrescentar Tipo de Modalidade no ecrã Exames Agendados.' or TIT_PED = 'Acrescentar o nº de episódio do Sonho na lista de requisições/exames pendentes p' or TIT_PED = 'Alguns exames aparecem executados, mas com estado não executado.' or TIT_PED = 'Alguns exames não aparecem para relatar.' or TIT_PED = 'Alt. mapas do grupo Exames SiiMA para reflectir o pedido 514.' or TIT_PED = 'Alterar 10 mapas permitindo escolher Apenas Exames ou Todos' or TIT_PED = 'Alterar a listagem Exames Executados por Modalidade' or TIT_PED = 'Alterar execução - exames a facturar - selec. por defeito consoante as novas flg' or TIT_PED = 'Alterar mapas estatísticos do grupo ¿Exames SONHO¿ para reflectir o pedido 512.' or TIT_PED = 'Alterar o grupo de Exames Siima afectando a quantidade pelo factor de cada exame' or TIT_PED = 'Anulação de exames no SONHO quando são anulados no SIIMA.' or TIT_PED = 'Ao acrescentar exames num pedido da urgência ele não permite executar tudo junto' or TIT_PED = 'Ao marcar vários exames juntos só guarda o id_rel_por no primeiro.' or TIT_PED = 'Aparecer a quantidade no ecrã de execução de exames.' or TIT_PED = 'Apenas activar os exames com flg=FLG_CONT se Contraste = SIM e Via Endovenosa' or TIT_PED = 'Apresentação da data do acto na lista de exames por marcar.' or TIT_PED = 'Arquivar exames antigos' or TIT_PED = 'As estatisticas de ponderação de exames facturados dão valores diferentes.' or TIT_PED = 'As estatísticas de 'exames facturados por área técnica e tipo de exame' estão a ' or TIT_PED = 'As vezes perdem-se exames importados do SONHO' or TIT_PED = 'As vezes, ao clickar nos exames a facturar da MN dá erro' or TIT_PED = 'Aumentar a largura da coluna da descrição dos exames a facturar.'#$A'Rever a ordenaç' or TIT_PED = 'Botão de exames executados, nos ecrãs de execução' or TIT_PED = 'Botão que acede às Preparações / Exames no form Manutenção - Exames' or TIT_PED = 'Cancelar exames - pergunta se quer cancelar requisição ' or TIT_PED = 'Carregar as ponderações e emitir listagem de 2002 com os exames realizados e res' or TIT_PED = 'Colocar o campo periodo visivel no ecrã dos exames' or TIT_PED = 'Contagem de exames por modalidade e origem.' or TIT_PED = 'Criar 2 mapas no grupo Exames Sonho idênticos aos de ponderação, mas com preços.' or TIT_PED = 'Criar manutenção de portarias e respectivos exames com ponderação.' or TIT_PED = 'Criação de job para geração de marcação de exames importados do SONHO.' or TIT_PED = 'Definir que exames devem ser importados pelo SiiMA.' or TIT_PED = 'Desdobramento de exames no SiiMA vindos do Hosix.' or TIT_PED = 'Dá erro quando se alteram os exames de uma requisição.' or TIT_PED = 'EXames Executados ' or TIT_PED = 'Ecrã e Relatório Exames Executados - acrescentar data de execução do exame.' or TIT_PED = 'Erro a ascrecentar exames numa requisição.' or TIT_PED = 'Erro na alteração de exames.' or TIT_PED = 'Erros na execução de exames detectados após arranque - II.' or TIT_PED = 'Erros na execução de exames detectados após arranque.' or TIT_PED = 'Erros na execução de exames detectados no arranque.' or TIT_PED = 'Estatistica indicando o nº de utentes que realizaram exames durante um periodo d' or TIT_PED = 'Estatistica que para um periodo indique que exames foram pedidos, mas não marcad' or TIT_PED = 'Estão a ser enviados para a facturação exames de MN com data 2/1/2000' or TIT_PED = 'Exames Agendados - Alterar o texto do ecrã' or TIT_PED = 'Exames Agendados - Botão preview devia ser o botão da folha de marcação.' or TIT_PED = 'Exames Executados - Acrescentar complicações' or TIT_PED = 'Exames Executados - Acrescentar o intervalo horário.' or TIT_PED = 'Exames Executados: quando estamos a gravar alterações num exame previamente exec' or TIT_PED = 'Exames Siima por Área Técnica e Modalidade e Á. Téc. e T.Exame. - Diário' or TIT_PED = 'Exames a facturar - Colocar a quantidade = quantidade requisitada.' '#0#0#0#0#0#0#0#0#0#0#0#0'Ä'#$15'U'#0'À»Þ'#2#0#0#0#0#0#0#0#0#0#0#0#0#0#0#0#0#0#0#0#0#0#0#0#0't'#$1D'U'#0#$1C'¼Þ'#2#0#0#0#0#0#0#0#0#0#0#0#0#0#0#0#0#0#0#0#0#0#0#0#0'Ð'#$1A'U'#0'<½Þ'#2'¸„}'#3#0#0#0#0#0#0#0#0#0#0#0#0#0#0#0#0#0#0#0#0'¼'#$19'U'#0'€¼Þ'#2#0#0#0#0#0#0#0#0#0#0#0#0#0#0#0#0#0#0#0#0#0#0#0#0'œ'#$1D'U'#0'à¼Þ'#2#0#0#0#0#0#0#0#0#0#0#0#0#0#0#0#0#0#0#0#0#0#0#0#0'\'#$19'U'#0'œ½Þ'#2'ø…}'#3#0#0#0#0#0#0#0#0#0#0#0#0#0#0#0#0#0#0#0#0'x'#$17'U'#0'ȾÞ'#2'x‰}'#3#0#0#0#0#0#0#0#0#0#0#0#0#0#0#0#0#0#0#0#0'€'#$15'U'#0'd¾Þ'#2'˜m}'#3#0#0#0#0#0#0#0#0#0#0#0#0#0#0#0#0#0#0#0#0'l'#$16'U'#0#0'¾Þ'#2#0#0#0#0#0#0#0#0#0#0#0#0#0#0#0#0#0#0#0#0#0#0#0#0'Ø'#$18'U'#0',¿Þ'#2'˜q}'#3#0#0#0#0#0#0#0#0#0#0#0#0#0#0#0#0#0#0#0#0#0#$17'U'#0'ì_f'#0'Xo}'#3#0#0#0#0#0#0#0#0#0#0#0#0#0#0#0#0#0#0#0#0'œ'#$19'U'#0'ä^f'#0'øq}'#3#0#0#0#0#0#0#0#0#0#0#0#0#0#0#0#0#0#0#0#0#0#$1C'U'#0'D]f'#0#0#0#0#0#0#0#0#0#0#0#0#0#0#0#0#0#0#0#0#0#0#0#0#0'H'#$16'U'#0'Äcf'#0#0#0#0#0#0#0#0#0#0#0#0#0#0#0#0#0#0#0#0#0#0#0#0#0'Œ'#$16'U'#0'@†*'#3#0#0#0#0#0#0#0#0#0#0#0#0#0#0#0#0#0#0#0#0#0#0#0#0'Ü'#$1B'U'#0'Ȉ*'#3'øn}'#3#0#0#0#0#0#0#0#0#0#0#0#0#0#0#0#0#0#0#0#0'ä'#$15'U'#0#$10'Â'#2'xl}'#3#0#0#0#0#0#0#0#0#0#0#0#0#0#0#0#0#0#0#0#0'Ô'#$1C'U'#0'P‰*'#3'8€}'#3#0#0#0#0#0#0#0#0#0#0#0#0#0#0#0#0#0#0#0#0'T'#$1B'U'#0'˜cf'#0#0#0#0#0#0#0#0#0#0#0#0#0#0#0#0#0#0#0#0#0#0#0#0#0'<'#$19'U'#0'$ÓÞ'#2#0#0#0#0#0#0#0#0#0#0#0#0#0#0#0#0#0#0#0#0#0#0#0#0'('#$1D'U'#0'ˆÓÞ'#2'¸u}'#3#0#0#0#0#0#0#0#0#0#0#0#0#0#0#0#0#0#0#0#0'œ'#$1C'U'#0'ìÓÞ'#2#0#0#0#0#0#0#0#0#0#0#0#0#0#0#0#0#0#0#0#0#0#0#0#0'T'#$16'U'#0'XÔÞ'#2#0#0#0#0#0#0#0#0#0#0#0#0#0#0#0#0#0#0#0#0#0#0#0#0'¸'#$1D'U'#0'¼ÔÞ'#2'Ø„}'#3#0#0#0#0#0#0#0#0#0#0#0#0#0#0#0#0#0#0#0#0'°'#$18'U'#0#$1C'ÕÞ'#2'øo}'#3#0#0#0#0#0#0#0#0#0#0#0#0#0#0#0#0#0#0#0#0#$10#$1A'U'#0'xÕÞ'#2'8w}'#3#0#0#0#0#0#0#0#0#0#0#0#0#0#0#0#0#0#0#0#0'P'#$18'U'#0'ÔÕÞ'#2'ør}'#3#0#0#0#0#0#0#0#0#0#0#0#0#0#0#0#0#0#0#0#0'Ì'#$1B'U'#0'l×Þ'#2'¸‚}'#3#0#0#0#0#0#0#0#0#0#0#0#0#0#0#0#0#0#0#0#0'Ø'#$19'U'#0'Ð×Þ'#2#0#0#0#0#0#0#0#0#0#0#0#0#0#0#0#0#0#0#0#0#0#0#0#0'°'#$1A'U'#0'4ØÞ'#2#0#0#0#0#0#0#0#0#0#0#0#0#0#0#0#0#0#0#0#0#0#0#0#0'Ø'#$1C'U'#0'˜ØÞ'#2'8ˆ}'#3#0#0#0#0#0#0#0#0#0#0#0#0#0#0#0#0#0#0#0#0'@'#$15'U'#0'øØÞ'#2#0#0#0#0#0#0#0#0#0#0#0#0#0#0#0#0#0#0#0#0#0#0#0#0'ˆ'#$1A'U'#0'`ÙÞ'#2#0#0#0#0#0#0#0#0#0#0#0#0#0#0#0#0#0#0#0#0#0#0#0#0'œ'#$15'U'#0'8ÖÞ'#2'˜t}'#3#0#0#0#0#0#0#0#0#0#0#0#0#0#0#0#0#0#0#0#0'´'#$16'U'#0'Ô ¼'#2#0#0#0#0#0#0#0#0#0#0#0#0#0#0#0#0#0#0#0#0#0#0#0#0' '#$16'U'#0'įÞ'#2#0#0#0#0#0#0#0#0#0#0#0#0#0#0#0#0#0#0#0#0#0#0#0#0'H'#$15'U'#0'h^f'#0'øp}'#3#0#0#0#0#0#0#0#0#0#0#0#0#0#0#0#0#0#0#0#0'ì'#$17'U'#0#8'^f'#0#$18'‚}'#3#0#0#0#0#0#0#0#0#0#0#0#0#0#0#0#0#0#0#0#0'ô'#$19'U'#0'lÇò'#2#0#0#0#0#0#0#0#0#0#0#0#0#0#0#0#0#0#0#0#0#0#0#0#0'@'#$1B'U'#0'XŸÞ'#2#0#0#0#0#0#0#0#0#0#0#0#0#0#0#0#0#0#0#0#0#0#0#0#0#4#$1E'U'#0'°´Þ'#2'¸}'#3#0#0#0#0#0#0#0#0#0#0#0#0#0#0#0#0#0#0#0#0#8#$16'U'#0'¸±Þ'#2'Ø‚}'#3#0#0#0#0#0#0#0#0#0#0#0#0#0#0#0#0#0#0#0#0#8#$1E'U'#0'8²Þ'#2#0#0#0#0#0#0#0#0#0#0#0#0#0#0#0#0#0#0#0#0#0#0#0#0'„'#$1D'U'#0'´³í'#2#0#0#0#0#0#0#0#0#0#0#0#0#0#0#0#0#0#0#0#0#0#0#0#0#$14#$19'U'#0'¼˜Þ'#2#0#0#0#0#0#0#0#0#0#0#0#0#0#0#0#0#0#0#0#0#0#0#0#0'ð'#$17'U'#0'°¤Þ'#2'˜ƒ}'#3#0#0#0#0#0#0#0#0#0#0#0#0#0#0#0#0#0#0#0#0'l'#$19'U'#0'0™Þ'#2'˜‚}'#3#0#0#0#0#0#0#0#0#0#0#0#0#0#0#0#0#0#0#0#0'¬'#$19'U'#0'$—Þ'#2#0#0#0#0#0#0#0#0#0#0#0#0#0#0#0#0#0#0#0#0#0#0#0#0'Ì'#$15'U'#0'äÜö'#2'øŠ}'#3#0#0#0#0#0#0#0#0#0#0#0#0#0#0#0#0#0#0#0#0'p'#$19'U'#0'œ'#$A'ß'#2'8ƒ}'#3#0#0#0#0#0#0#0#0#0#0#0#0#0#0#0#0#0#0#0#0'Ð'#$1B'U'#0' '#$C'ß'#2#0#0#0#0#0#0#0#0#0#0#0#0#0#0#0#0#0#0#0#0#0#0#0#0#$C#$16'U'#0'¨'#$B'ß'#2#0#0#0#0#0#0#0#0#0#0#0#0#0#0#0#0#0#0#0#0#0#0#0#0'8'#$18'U'#0#$1C#$B'ß'#2'xˆ}'#3#0#0#0#0#0#0#0#0#0#0#0#0#0#0#0#0#0#0#0#0'|'#$1B'U'#0'Œ¿Þ'#2'øw}'#3#0#0#0#0#0#0#0#0#0#0#0#0#0#0#0#0#0#0#0#0't'#$19'U'#0'À²Þ'#2'8r}'#3#0#0#0#0#0#0#0#0#0#0#0#0#0#0#0#0#0#0#0#0'x'#$15'U'#0' ëÞ'#2#0#0#0#0#0#0#0#0#0#0#0#0#0#0#0#0#0#0#0#0#0#0#0#0'p'#$17'U'#0'ì§Þ'#2'¸†}'#3#0#0#0#0#0#0#0#0#0#0#0#0#0#0#0#0#0#0#0#0'ô'#$17'U'#0'¤¥Þ'#2'X„}'#3#0#0#0#0#0#0#0#0#0#0#0#0#0#0#0#0#0#0#0#0'Œ'#$1C'U'#0'Œ¹Þ'#2#0#0#0#0#0#0#0#0#0#0#0#0#0#0#0#0#0#0#0#0#0#0#0#0'('#$19'U'#0'Ì´í'#2'˜Š}'#3#0#0#0#0#0#0#0#0#0#0#0#0#0#0#0#0#0#0#0#0'˜'#$1B'U'#0'8±Þ'#2'x„}'#3#0#0#0#0#0#0#0#0#0#0#0#0#0#0#0#0#0#0#0#0'ì'#$1D'U'#0'¬ ³'#1'¸‰}'#3#0#0#0#0#0#0#0#0#0#0#0#0#0#0#0#0#0#0#0#0'°'#$1B'U'#0'((¹'#2'˜†}'#3#0#0#0#0#0#0#0#0#0#0#0#0#0#0#0#0#0#0#0#0'ø'#$17'U'#0'ô'¹'#2#0#0#0#0#0#0#0#0#0#0#0#0#0#0#0#0#0#0#0#0#0#0#0#0'œ'#$1B'U'#0'0»Þ'#2'؈}'#3#0#0#0#0#0#0#0#0#0#0#0#0#0#0#0#0#0#0#0#0'´'#$1A'U'#0'Ä®Þ'#2#0#0#0#0#0#0#0#0#0#0#0#0#0#0#0#0#0#0#0#0#0#0#0#0'Ô'#$1A'U'#0'„Ýö'#2#0#0#0#0#0#0#0#0#0#0#0#0#0#0#0#0#0#0#0#0#0#0#0#0'¼'#$1D'U'#0'PÝö'#2#0#0#0#0#0#0#0#0#0#0#0#0#0#0#0#0#0#0#0#0#0#0#0#0#4#$19'U'#0#$1C'Ýö'#2#0#0#0#0#0#0#0#0#0#0#0#0#0#0#0#0#0#0#0#0#0#0#0#0'P'#$17'U'#0'ÐòÞ'#2#0#0#0#0#0#0#0#0#0#0#0#0#0#0#0#0#0#0#0#0#0#0#0#0'´'#$1C'U'#0'°°Þ'#2'˜…}'#3#0#0#0#0#0#0#0#0#0#0#0#0#0#0#0#0#0#0#0#0#$1C#$18'U'#0#$10'Æò'#2#0#0#0#0#0#0#0#0#0#0#0#0#0#0#0#0#0#0#0#0#0#0#0#0'à'#$1D'U'#0'䟼'#2'˜v}'#3#0#0#0#0#0#0#0#0#0#0#0#0#0#0#0#0#0#0#0#0'¸'#$1C'U'#0' µÞ'#2'¸t}'#3#0#0#0#0#0#0#0#0#0#0#0#0#0#0#0#0#0#0#0#0'À'#$16'U'#0'X¸Þ'#2#$18'‰}'#3#0#0#0#0#0#0#0#0#0#0#0#0#0#0#0#0#0#0#0#0'Ü'#$17'U'#0'<Çò'#2'x‡}'#3#0#0#0#0#0#0#0#0#0#0#0#0#0#0#0#0#0#0#0#0'`'#$19'U'#0'DÆò'#2#0#0#0#0#0#0#0#0#0#0#0#0#0#0#0#0#0#0#0#0#0#0#0#0'ü'#$1A'U'#0'€ ³'#1#0#0#0#0#0#0#0#0#0#0#0#0#0#0#0#0#0#0#0#0#0#0#0#0#0#$1E'U'#0'X.¹'#2#0#0#0#0#0#0#0#0#0#0#0#0#0#0#0#0#0#0#0#0#0#0#0#0'¨'#$1C'U'#0'|ïÞ'#2#0#0#0#0#0#0#0#0#0#0#0#0#0#0#0#0#0#0#0#0#0#0#0#0'„'#$18'U'#0'<®Þ'#2#0#0#0#0#0#0#0#0#0#0#0#0#0#0#0#0#0#0#0#0#0#0#0#0'´'#$1B'U'#0'´­Þ'#2'˜r}'#3#0#0#0#0#0#0#0#0#0#0#0#0#0#0#0#0#0#0#0#0't'#$17'U'#0'äªÞ'#2#0#0#0#0#0#0#0#0#0#0#0#0#0#0#0#0#0#0#0#0#0#0#0#0''#$17'U'#0'<­Þ'#2#0#0#0#0#0#0#0#0#0#0#0#0#0#0#0#0#0#0#0#0#0#0#0#0' '#$1B'U'#0'T¬Þ'#2#0#0#0#0#0#0#0#0#0#0#0#0#0#0#0#0#0#0#0#0#0#0#0#0'¼'#$18'U'#0'<´Þ'#2'˜‹}'#3#0#0#0#0#0#0#0#0#0#0#0#0#0#0#0#0#0#0#0#0#$18#$1B'U'#0'p©Þ'#2#0#0#0#0#0#0#0#0#0#0#0#0#0#0#0#0#0#0#0#0#0#0#0#0#$18#$1E'U'#0'Ä'¹'#2#0#0#0#0#0#0#0#0#0#0#0#0#0#0#0#0#0#0#0#0#0#0#0#0'à'#$17'U'#0',¥Þ'#2'xn}'#3#0#0#0#0#0#0#0#0#0#0#0#0#0#0#0#0#0#0#0#0'h'#$16'U'#0'ô©Þ'#2#0#0#0#0#0#0#0#0#0#0#0#0#0#0#0#0#0#0#0#0#0#0#0#0'd'#$1D'U'#0'˜–Þ'#2'8Š}'#3#0#0#0#0#0#0#0#0#0#0#0#0#0#0#0#0#0#0#0#0'H'#$1C'U'#0'Øaf'#0#0#0#0#0#0#0#0#0#0#0#0#0#0#0#0#0#0#0#0#0#0#0#0#0'˜'#$1A'U'#0'TžÞ'#2'˜o}'#3#0#0#0#0#0#0#0#0#0#0#0#0#0#0#0#0#0#0#0#0'Œ'#$19'U'#0'ÔžÞ'#2#0#0#0#0#0#0#0#0#0#0#0#0#0#0#0#0#0#0#0#0#0#0#0#0'Ü'#$1C'U'#0'L˜Þ'#2'ø‰}'#3#0#0#0#0#0#0#0#0#0#0#0#0#0#0#0#0#0#0#0#0#$14#$1D'U'#0'4¤Þ'#2'Øu}'#3#0#0#0#0#0#0#0#0#0#0#0#0#0#0#0#0#0#0#0#0'<'#$18'U'#0'Ôlß'#2'¸ˆ}'#3#0#0#0#0#0#0#0#0#0#0#0#0#0#0#0#0#0#0#0#0'¼'#$15'U'#0'¸bf'#0#0#0#0#0#0#0#0#0#0#0#0#0#0#0#0#0#0#0#0#0#0#0#0#0'@'#$18'U'#0'€Ö»'#2'x‹}'#3#0#0#0#0#0#0#0#0#0#0#0#0#0#0#0#0#0#0#0#0' '#$1B'U'#0'¼£Þ'#2#0#0#0#0#0#0#0#0#0#0#0#0#0#0#0#0#0#0#0#0#0#0#0#0'¬'#$1C'U'#0'Ä¡Þ'#2#0#0#0#0#0#0#0#0#0#0#0#0#0#0#0#0#0#0#0#0#0#0#0#0'Ä'#$16'U'#0'D£Þ'#2#$18't}'#3#0#0#0#0#0#0#0#0#0#0#0#0#0#0#0#0#0#0#0#0'0'#$18'U'#0'ÈÙÞ'#2#0#0#0#0#0#0#0#0#0#0#0#0#0#0#0#0#0#0#0#0#0#0#0#0' '#$17'U'#0'(ÚÞ'#2'Ør}'#3#0#0#0#0#0#0#0#0#0#0#0#0#0#0#0#0#0#0#0#0'|'#$17'U'#0'€ÚÞ'#2'Xr}'#3#0#0#0#0#0#0#0#0#0#0#0#0#0#0#0#0#0#0#0#0'ˆ'#$1D'U'#0'ØÚÞ'#2#0#0#0#0#0#0#0#0#0#0#0#0#0#0#0#0#0#0#0#0#0#0#0#0'ð'#$1D'U'#0'8ÛÞ'#2#0#0#0#0#0#0#0#0#0#0#0#0#0#0#0#0#0#0#0#0#0#0#0#0'X'#$1C'U'#0'˜ÛÞ'#2#0#0#0#0#0#0#0#0#0#0#0#0#0#0#0#0#0#0#0#0#0#0#0#0'à'#$1C'U'#0'øÛÞ'#2'Xp}'#3#0#0#0#0#0#0#0#0#0#0#0#0#0#0#0#0#0#0#0#0'h'#$17'U'#0'XÜÞ'#2#0#0#0#0#0#0#0#0#0#0#0#0#0#0#0#0#0#0#0#0#0#0#0#0'h'#$1D'U'#0'°ÜÞ'#2'XŠ}'#3#0#0#0#0#0#0#0#0#0#0#0#0#0#0#0#0#0#0#0#0'l'#$1D'U'#0#$10'ÝÞ'#2#$18'v}'#3#0#0#0#0#0#0#0#0#0#0#0#0#0#0#0#0#0#0#0#0#0#$18'U'#0'pÝÞ'#2'Øq}'#3#0#0#0#0#0#0#0#0#0#0#0#0#0#0#0#0#0#0#0#0','#$19'U'#0'ÈÝÞ'#2'øl}'#3#0#0#0#0#0#0#0#0#0#0#0#0#0#0#0#0#0#0#0#0#0#$16'U'#0'(ÞÞ'#2#0#0#0#0#0#0#0#0#0#0#0#0#0#0#0#0#0#0#0#0#0#0#0#0'P'#$1C'U'#0'ˆÞÞ'#2#0#0#0#0#0#0#0#0#0#0#0#0#0#0#0#0#0#0#0#0#0#0#0#0'Ð'#$15'U'#0'àÞÞ'#2'øs}'#3#0#0#0#0#0#0#0#0#0#0#0#0#0#0#0#0#0#0#0#0'd'#$15'U'#0'8ßÞ'#2#0#0#0#0#0#0#0#0#0#0#0#0#0#0#0#0#0#0#0#0#0#0#0#0'P'#$16'U'#0'˜ßÞ'#2#0#0#0#0#0#0#0#0#0#0#0#0#0#0#0#0#0#0#0#0#0#0#0#0'ô'#$16'U'#0'øßÞ'#2#0#0#0#0#0#0#0#0#0#0#0#0#0#0#0#0#0#0#0#0#0#0#0#0'D'#$18'U'#0'hªÞ'#2#0#0#0#0#0#0#0#0#0#0#0#0#0#0#0#0#0#0#0#0#0#0#0#0'À'#$18'U'#0#8#$D'ß'#2'˜w}'#3#0#0#0#0#0#0#0#0#0#0#0#0#0#0#0#0#0#0#0#0'<'#$1E'U'#0'¼,¹'#2'8n}'#3#0#0#0#0#0#0#0#0#0#0#0#0#0#0#0#0#0#0#0#0'd'#$17'U'#0',œÞ'#2#0#0#0#0#0#0#0#0#0#0#0#0#0#0#0#0#0#0#0#0#0#0#0#0'ô'#$18'U'#0' ›Þ'#2#$18'm}'#3#0#0#0#0#0#0#0#0#0#0#0#0#0#0#0#0#0#0#0#0'h'#$1C'U'#0'T•Þ'#2#0#0#0#0#0#0#0#0#0#0#0#0#0#0#0#0#0#0#0#0#0#0#0#0'4'#$1C'U'#0'à”Þ'#2#0#0#0#0#0#0#0#0#0#0#0#0#0#0#0#0#0#0#0#0#0#0#0#0'Ø'#$17'U'#0'xñ»'#2#0#0#0#0#0#0#0#0#0#0#0#0#0#0#0#0#0#0#0#0#0#0#0#0'h'#$1B'U'#0#$18'¦Þ'#2#$18'—}'#3#0#0#0#0#0#0#0#0#0#0#0#0#0#0#0#0#0#0#0#0't'#$15'U'#0'xš'#$19#3'Xƒ}'#3#0#0#0#0#0#0#0#0#0#0#0#0#0#0#0#0#0#0#0#0'4'#$1B'U'#0#0'š'#$19#3'x“}'#3#0#0#0#0#0#0#0#0#0#0#0#0#0#0#0#0#0#0#0#0'„'#$16'U'#0'|™'#$19#3'Xš}'#3#0#0#0#0#0#0#0#0#0#0#0#0#0#0#0#0#0#0#0#0'Ø'#$1B'U'#0#0'íÞ'#2'X~}'#3#0#0#0#0#0#0#0#0#0#0#0#0#0#0#0#0#0#0#0#0'Ü'#$16'U'#0'ȬÞ'#2#0#0#0#0#0#0#0#0#0#0#0#0#0#0#0#0#0#0#0#0#0#0#0#0#8#$19'U'#0'X'#$1A':'#3#0#0#0#0#0#0#0#0#0#0#0#0#0#0#0#0#0#0#0#0#0#0#0#0'<'#$1A'U'#0','#$1A':'#3#0#0#0#0#0#0#0#0#0#0#0#0#0#0#0#0#0#0#0#0#0#0#0#0'|'#$1C'U'#0'Ì'#$1B':'#3'Øš}'#3#0#0#0#0#0#0#0#0#0#0#0#0#0#0#0#0#0#0#0#0'”'#$1B'U'#0#$10'!:'#3'øƒ}'#3#0#0#0#0#0#0#0#0#0#0#0#0#0#0#0#0#0#0#0#0'Ø'#$1A'U'#0'ø¶Þ'#2'ø•}'#3#0#0#0#0#0#0#0#0#0#0#0#0#0#0#0#0#0#0#0#0'('#$1C'U'#0't·Þ'#2#0#0#0#0#0#0#0#0#0#0#0#0#0#0#0#0#0#0#0#0#0#0#0#0'¨'#$16'U'#0'ð·Þ'#2'˜›}'#3#0#0#0#0#0#0#0#0#0#0#0#0#0#0#0#0#0#0#0#0'8'#$17'U'#0'tîÞ'#2'Øo}'#3#0#0#0#0#0#0#0#0#0#0#0#0#0#0#0#0#0#0#0#0'È'#$19'U'#0'ˆ¶Þ'#2'xr}'#3#0#0#0#0#0#0#0#0#0#0#0#0#0#0#0#0#0#0#0#0' '#$1D'U'#0#8'¶Þ'#2#0#0#0#0#0#0#0#0#0#0#0#0#0#0#0#0#0#0#0#0#0#0#0#0'À'#$1B'U'#0'DH8'#3'8s}'#3#0#0#0#0#0#0#0#0#0#0#0#0#0#0#0#0#0#0#0#0'´'#$19'U'#0'$G8'#3'ø’}'#3#0#0#0#0#0#0#0#0#0#0#0#0#0#0#0#0#0#0#0#0'è'#$16'U'#0'dF8'#3'8“}'#3#0#0#0#0#0#0#0#0#0#0#0#0#0#0#0#0#0#0#0#0'|'#$18'U'#0'¤E8'#3'˜‘}'#3#0#0#0#0#0#0#0#0#0#0#0#0#0#0#0#0#0#0#0#0'0'#$1D'U'#0'àK8'#3'x˜}'#3#0#0#0#0#0#0#0#0#0#0#0#0#0#0#0#0#0#0#0#0'$'#$1A'U'#0#$C'à('#3'8p}'#3#0#0#0#0#0#0#0#0#0#0#0#0#0#0#0#0#0#0#0#0'x'#$1D'U'#0#$18'Ü('#3#0#0#0#0#0#0#0#0#0#0#0#0#0#0#0#0#0#0#0#0#0#0#0#0'0'#$1C'U'#0' e8'#3'8Œ}'#3#0#0#0#0#0#0#0#0#0#0#0#0#0#0#0#0#0#0#0#0'°'#$1D'U'#0'ÀJ8'#3#$18'”}'#3#0#0#0#0#0#0#0#0#0#0#0#0#0#0#0#0#0#0#0#0'Ø'#$1D'U'#0'dQ8'#3'X™}'#3#0#0#0#0#0#0#0#0#0#0#0#0#0#0#0#0#0#0#0#0'0'#$16'U'#0'(Ý('#3#0#0#0#0#0#0#0#0#0#0#0#0#0#0#0#0#0#0#0#0#0#0#0#0't'#$16'U'#0'œÛ('#3#0#0#0#0#0#0#0#0#0#0#0#0#0#0#0#0#0#0#0#0#0#0#0#0'ˆ'#$19'U'#0'P_8'#3#$18'ˆ}'#3#0#0#0#0#0#0#0#0#0#0#0#0#0#0#0#0#0#0#0#0'Ì'#$18'U'#0'(a8'#3#0#0#0#0#0#0#0#0#0#0#0#0#0#0#0#0#0#0#0#0#0#0#0#0'È'#$1A'U'#0#0'Æ('#3#$18's}'#3#0#0#0#0#0#0#0#0#0#0#0#0#0#0#0#0#0#0#0#0'ˆ'#$15'U'#0'pÇ('#3#$18'x}'#3#0#0#0#0#0#0#0#0#0#0#0#0#0#0#0#0#0#0#0#0'`'#$1A'U'#0'4O8'#3#0#0#0#0#0#0#0#0#0#0#0#0#0#0#0#0#0#0#0#0#0#0#0#0'Œ'#$17'U'#0'lÅ('#3'؆}'#3#0#0#0#0#0#0#0#0#0#0#0#0#0#0#0#0#0#0#0#0'D'#$1C'U'#0'pL8'#3'؇}'#3#0#0#0#0#0#0#0#0#0#0#0#0#0#0#0#0#0#0#0#0#$C#$18'U'#0'4`8'#3'¸•}'#3#0#0#0#0#0#0#0#0#0#0#0#0#0#0#0#0#0#0#0#0'D'#$16'U'#0'PÔ('#3#$18'~}'#3#0#0#0#0#0#0#0#0#0#0#0#0#0#0#0#0#0#0#0#0'L'#$18'U'#0'ÔØ('#3'¸}'#3#0#0#0#0#0#0#0#0#0#0#0#0#0#0#0#0#0#0#0#0'd'#$19'U'#0'ÔÔ('#3'Ø“}'#3#0#0#0#0#0#0#0#0#0#0#0#0#0#0#0#0#0#0#0#0'0'#$1E'U'#0'ÀÓ('#3'¸‘}'#3#0#0#0#0#0#0#0#0#0#0#0#0#0#0#0#0#0#0#0#0' '#$16'U'#0'ÈÕ('#3#0#0#0#0#0#0#0#0#0#0#0#0#0#0#0#0#0#0#0#0#0#0#0#0'€'#$18'U'#0'PÙ('#3'x†}'#3#0#0#0#0#0#0#0#0#0#0#0#0#0#0#0#0#0#0#0#0'4'#$1E'U'#0'PØ('#3'øš}'#3#0#0#0#0#0#0#0#0#0#0#0#0#0#0#0#0#0#0#0#0'|'#$15'U'#0'¼Ï('#3#0#0#0#0#0#0#0#0#0#0#0#0#0#0#0#0#0#0#0#0#0#0#0#0'\'#$15'U'#0'àÙ('#3#0#0#0#0#0#0#0#0#0#0#0#0#0#0#0#0#0#0#0#0#0#0#0#0'ø'#$15'U'#0'(×('#3#$18'˜}'#3#0#0#0#0#0#0#0#0#0#0#0#0#0#0#0#0#0#0#0#0'T'#$19'U'#0'Ä×('#3'8—}'#3#0#0#0#0#0#0#0#0#0#0#0#0#0#0#0#0#0#0#0#0'L'#$19'U'#0'@Ó('#3#0#0#0#0#0#0#0#0#0#0#0#0#0#0#0#0#0#0#0#0#0#0#0#0'À'#$17'U'#0'@Ò('#3'¸w}'#3#0#0#0#0#0#0#0#0#0#0#0#0#0#0#0#0#0#0#0#0'p'#$15'U'#0'°Ö('#3#0#0#0#0#0#0#0#0#0#0#0#0#0#0#0#0#0#0#0#0#0#0#0#0'T'#$1D'U'#0'¸Ò('#3#0#0#0#0#0#0#0#0#0#0#0#0#0#0#0#0#0#0#0#0#0#0#0#0'D'#$19'U'#0'Dß('#3'ø”}'#3#0#0#0#0#0#0#0#0#0#0#0#0#0#0#0#0#0#0#0#0'¸'#$19'U'#0'ÈÑ('#3'Ø|}'#3#0#0#0#0#0#0#0#0#0#0#0#0#0#0#0#0#0#0#0#0'ø'#$1A'U'#0'LÖ('#3#$18'†}'#3#0#0#0#0#0#0#0#0#0#0#0#0#0#0#0#0#0#0#0#0'ì'#$16'U'#0'Œbf'#0'¸›}'#3#0#0#0#0#0#0#0#0#0#0#0# alguém m pode dizer s isto é normal ou s tem soluçao ?:(

Pois..já tinha pensado nixo, em utilizar 1a query.. É mesmo ixo q vou fazer.. muito obrigada a todos;)

Ola, Tentei ixo ,mas não da:( Poe exemplo, tenho o registo nome_pess = 'Rita Silva' Se eu fizer o tabel1.locate('nome_Pess','rita',[loCaseInsensitive, loPartialKey]); Aparece o registo, mas se for: tabel1.locate('nome_Pess','Silva',[loCaseInsensitive, loPartialKey]); não aparece o registo... já tentei usar o filter com Tabel1.filter := nome_pess LIKE 'silva' mas da-m o erro: Capability not suported Não sei como resolver ixto:( brigada pela ajuda;)

Pois..exe é q é o problema...ixo no delphi n da... so da mesmo Filter := 'nome_pessoa = 'nome*''

O meu problema é q quero filtrar todos os registos que contenham a string que seleccionada. O meu problema é que por exemplo: há um registo com o nome nome_pessoa que tem : Rita Silva e se eu fizer Tabela.Filter := 'nome_pesoa = 'rita*'; Aparece o registo mas se eu fizer Tabela.Filter := 'nome_pesoa = 'Silva*'; o registo não aperece. já teneti utilizar o like mas da o erro q mencionei:( Obrigada pela ajuda;)

Tenho o seguinte problema tabela.filter := Nome_Campo Like '%resul%' O problema é que agora retorna um erro : Capability not suported. alguém pode-m ajudar? obrigada

oi, Será que alguém sabe como é q partir de uma string e utilizando o filter consigo retornar um registo que tenha essa string? brigada;) Estive a ver na net e vi que poxo utilizar tabela.filter := Nome_Campo Like '%resul%' O problema é que agora retorna um erro : Capability not suported. alguém pode-m ajudar?