Home > Conversion Error > Conversion Error From String Blob Firebird

Conversion Error From String Blob Firebird

Contents

Select tbl1.Reference tbl1.FIRSTNAME, tbl1.Image2, (Select Sum(FieldA) from Table2 TBL2 where tbl2.Reference = tbl1.Reference) as TotalFieldA from Table1 tbl1 This eliminates the link between tbl1 & tbl2 and also there is no My params are receiving the values asDateTimes (i even tried asDate). Find all posts by davidj #5 04-13-2007, 06:30 AM daltamira Senior Member Join Date: Aug 2006 Location: Argentina Posts: 959 RE: Conversion error from string From the help Find all posts by davidj #8 04-13-2007, 06:48 AM daltamira Senior Member Join Date: Aug 2006 Location: Argentina Posts: 959 RE: Conversion error from string if you just http://ogdomains.com/conversion-error/conversion-error-from-string-0-firebird.php

Acho que um varchar(1000) já resolveria, ao menos que o usuário venha a escrever muuuuita coisa no campo. I am concerned with the time portion of the date. I'm quite surprised that Firebird actually accepts the SQL. Voltar ao Topo helinho_10AprendizRegistrado: Quarta-Feira, 29 de Dezembro de 2010Mensagens: 149Localização: Goiânia Enviada: Ter Ago 21, 2012 3:54 pm Assunto: Batera eu já avia colocar varchar(2000), vc me recomenda colocar 1000 internet

Conversion Error From String Firebird

Try this: SELECT ... i added the second example in my post to show that if I change my params to AsString, i get the same error. –Blow ThemUp Oct 28 '12 at 23:27 Join the community of 500,000 technology professionals and ask your questions.

The error message is: .... 'conversion error from string "BLOB" .... Get 1:1 Help Now Advertise Here Enjoyed your answer? So I get the resulting row of: Reference : Firstname : Image2 : TotalFieldA in one line. Given your comment (and the respons of ain) I assume you are only interested in the date part, and want to ignore the time.

FYI - using Delphi 7 and Firebird 1.5.2 Faq Reply With Quote March 22nd, 2010,12:35 AM #2 No Profile Picture clivew View Profile View Forum Posts Visit Homepage  Contributing Conversion Error From String Sql What you see in your DB Management Software ("10/25/2012 9:20:49 AM" in your case) is the string representation of the data field, usually formatted (again) according your user Locale share|improve this En este foro podrás encontrar y hacer preguntas básicas de Perl con respuestas aptas a tu nivel. https://www.experts-exchange.com/questions/22759747/Delphi-7-Firebird-query-error-conversion-from-string-BLOB.html Try JIRA - bug tracking software for your team.

PPCG Jeopardy: Cops more hot questions question feed lang-pascal about us tour help blog chat data legal privacy policy work here advertising info mobile contact us feedback Technology Life / Arts I use TListView in almost all of my applications I've written, and I was not going to compromise by resorting to TStringGrid… Delphi 5 Questions For Your Cloud “Pre-nup” Article by: when running this in EMS Manager Lite or inside a delphi/report builder application. UPDATE I initially did not spot the TRUNC in your query: it is the cause of the conversion error as this function only works on numbers, see the manual entry for

Conversion Error From String Sql

bom, voc j fez um backup e restore deste banco ??? http://www.sql.ru/forum/75575/conversion-error-from-string-blob Go to Solution 5 2 +1 4 Participants Limbeck(5 comments) LVL 19 Delphi6 Databases5 Marius0188(2 comments) TheRealLoki LVL 17 Delphi17 Databases1 schild1 LVL 1 Delphi1 9 Comments LVL 19 Overall: Conversion Error From String Firebird WHERE (Body containing 'keep') Containing is case insensitive and work with blob, so you get what you want. 0 Featured Post What Is Threat Intelligence? Firebird Sql Conversion Error From String conversion error from string "BLOB".

Join our community for more solutions or to ask questions. http://ogdomains.com/conversion-error/conversion-error-from-string-interbase.php Lo que debes elegir es cuál de todos esos formatos que te pone el manual debes escoger. share|improve this answer answered Oct 25 '12 at 15:44 Andrej Kirejeŭ 3,70511525 As I examplained to two others above, i do not use strings. reflector post in Italian CYMK to RGB conversion for repro Find the "Recursive Size" of a List How to respond to your boss's email about a coworker's accusation?

Voltar ao Topo maizenaColaboradorRegistrado: Terça-Feira, 20 de Março de 2012Mensagens: 1497Localização: Laguna - SC Enviada: Ter Ago 14, 2012 9:47 pm Assunto: Re: Conversion error from string "BLOB" helinho_10 escreveu: Ola Is the following sentence correct? 'The time when the church dates back to is the 13th.' * Mountainering with 6 y.o. i added the second example in my post to show that if I change my params to AsString, i get the same error –Blow ThemUp Oct 28 '12 at 23:26 weblink Using Firebird.

Thanks davidj View Public Profile Send a private message to davidj Visit davidj's homepage! If you desire so, the changes will be credited to your name. So if you feed a date/time conversion function with string that does not match your date part of the locale - you will get similar errors.

Saludos sarriaga Perlero Nuevo Mensajes: 69Registrado: 2013-10-21 08:42 @404 Arriba Re: conversion error from string en Firebird por sarriaga » 2014-02-27 15:44 @697 El problema de esta consulta es que

It may be there are some locale dependent conversion supported, but in general: use an actual date/timestamp type instead of a string. Select tbl1.FIRSTNAME, tbl1.Image2, Sum(FieldA) as TotalFieldA from Table1 tbl1 inner join Table2 tbl2 on tbl1.REG = tbl2.REF Group By tbl1.FirstName, tbl1.IMAGE2 If the references to the IMAGE2 field is removed in The Standard Select * from Table1 shows the image field no problem. Register Lost Password?

JF^D Perl Programming explorer Administrador Mensajes: 13777Registrado: 2005-07-24 18:12 @800Ubicación: Madrid, España Arriba Re: conversion error from string en Firebird por sarriaga » 2014-02-26 16:25 @725 muchas gracias, quedó perfecto Are electric bike speed limitations set in stone? But you have to check this for FB. check over here So if you execute your program on a computer with different than US Locale (like Mine) - it's likely to fail if using "10/25/2012".

JF^D Perl Programming explorer Administrador Mensajes: 13777Registrado: 2005-07-24 18:12 @800Ubicación: Madrid, España Arriba Re: conversion error from string en Firebird por sarriaga » 2014-02-21 08:48 @408 Exactamente, por lo que Login. Query1.ExecSQL - BLOBFIELD - BLOB ? 19 04, 06:42[542435] | Re: conversion error from string "blob" davidj View Public Profile Send a private message to davidj Visit davidj's homepage!

I'm quite surprised that Firebird actually accepts the SQL.