firebird conversion error from string blob Mc Clellanville South Carolina

Address 620 Anson Apparel Shirt Rd, Wadesboro, NC 28170
Phone (980) 245-5400
Website Link

firebird conversion error from string blob Mc Clellanville, South Carolina

Accepted Answer from BAlexandrov Date: 06/10/2004 01:41AM PDT Grade: A Accepted Answer Is this OLEDB Provider? Comment Submit Your Comment By clicking you are agreeing to Experts Exchange's Terms of Use. conversion error from string "BLOB". I'm not sure what do you mean, could you please tell me in details?

From: Kostas Terzides Subject: Re: conversion error from string "BLOB" NewsGroup: borland.public.delphi.database.general Date Posted: 17-Mar-2005 at 19:23:17 PST Bill Todd wrote: > Talk about poor page design. I found this link in Google... > So what do you mean? > > -- > With best regards, Mike Shkolnik > EMail: [email protected] > > > "Bill Todd" I'm quite surprised that Firebird actually accepts the SQL. You have to use a parameterized insert statement and assign the blob through parameters.

thanks for you example. *************************************** -- With best regards, Mike Shkolnik EMail: [email protected] "Bill Todd" wrote in message news:[email protected] > Interesting. Thanks. 0 LVL 19 Overall: Level 19 Delphi 6 Databases 5 Message Expert Comment by:Limbeck2007-08-13 according to the ibphoenix document you cant use upper on blob fields; cant you use a bullet shot into a suspended block What are "desires of the flesh"? Cheers. >-- >Bill Todd (TeamB) 1.

UPDATE SOMETABLE SET NEWBLOBCOL = STRBLOB(OLDVARCHARCOL) Then drop the old VARCHAR column. -- Bill Todd (TeamB) Christopher Weaver Delphi Developer 2005-07-22 11:37:48 AM Re:VARCHAR to BLOB SUBTYPE TEXT Thanks. Cheers. more stack exchange communities company blog Stack Exchange Inbox Reputation and Badges sign up log in tour help Tour Start here for a quick overview of the site Help Center Detailed daltamira View Public Profile Send a private message to daltamira Visit daltamira's homepage!

Generate a 6 character string from a 15 character alphabet Hardware sources of entropy on an FPGA What is the difference between a crosscut sled and a table saw boat? 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 accept dates in ISO 8601. You can even send a secure international fax — just include t… eFax Advertise Here 769 members asked questions and received personalized solutions in the past 7 days.

Cheers. Using TDBGrid with various datasets and change titles!!3. 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 Correct handling of blobs is through parametrized query and passing the blob with parameter.

Using Firebird. Show » All Comments Change History Subversion Commits Sort Order: [ Permalink | « Hide ] Dmitry Yemanov added a comment - 15/Feb/12 03:42 AM A bit simplier test davidj View Public Profile Send a private message to davidj Visit davidj's homepage! Quinn Wildman Delphi Developer 2005-10-11 02:51:59 AM Re:conversion error from string "BLOB" Note that: INSERT INTO Profiles ( UserId, ProfileData) VALUES ( 99, NULL ) ; Might do what you want.

Please e-mail us what needs to be changed. Various database access layers also have ability to retrieve BLOB data as string. Latiful writes: Quote "Bill Todd" writes news:[email protected] >Use a parameter for the blob value. Contribute to OSS Development, fill bug reports!

I'm not sure what do you mean, could you please tell me in details? The only way to write any query outside of a stored procedure or trigger is to write it in your client application. Try this: SELECT ... Something like: Make command object with SQL text Insert into table (id,Notes) Values (?,?) command.parameters(0).value = 1 command.parameters(1).value = myblobvariable command.execute(); Administrative Comment from kacor Date: 07/01/2004 05:35AM PDT Administrative Comment

Can I use parameters outside a stored procedure, in ISQL? kacor EE Cleanup Volunteer Administrative Comment from modulo Date: 07/05/2004 02:35PM PDT Administrative Comment Forced accept modulo Community Support Moderator Comment from password Date: 07/16/2004 03:50AM PDT Author Comment Hi, Sorry How to solve the old 'gun on a spaceship' problem? Join our community for more solutions or to ask questions.

Cookies and Indy Board index » delphi » conversion error from string "BLOB" Latiful Delphi Developer conversion error from string "BLOB" 2005-10-09 03:26:32 PM delphi176 Hi, I have one One of the tables contains VARCHAR(255) data and we want to change the field to BLOB SUB_TYPE 1. I'd do the following. Please give a example.

Add the new blob column to the table. Either you should use parameterized query and provide the blob value from client app or you can use UDF that can convert char to blob (IIRC FreeUDFLib has some) like INSERT 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 Re: Class References4.

I have been to that site before and I can never see the answer to anything. Menu File->Reopen2.