Go Premium for a chance to win a PS4. Enter to Win

x
?
Solved

(Delphi5 + MySQL) with MyOLEDB

Posted on 2001-07-26
8
Medium Priority
?
241 Views
Last Modified: 2010-04-06
When i use MyOLEDB connect to MySQL via ADOConnect,
Some problem i found:

   ADOQuery.SQL.Clear;
   ADOQuery.SQL.Add('INSERT INTO .. VALUE(.., :NAME, ..)');
   ADOQuery.Parameters.ParamValues['NAME']:=''''+s+'''';
   ADOQuery.ExecSQL;
 
'NAME' is a String Field, Param must fix "'" when it's
Type is NOT integer. But how can i operate with BLOB Field


Has any better and easy way to access MySQL via ADO
(but ODBC, BDE)?

   
0
Comment
Question by:OopsWare
  • 3
  • 3
8 Comments
 
LVL 27

Expert Comment

by:kretzschmar
ID: 6321047
>'NAME' is a String Field, Param must fix "'" when it's
>Type is NOT integer

you can use
quotedstr(s)
instead

blobs should go similar,
but as i don't use ado, i cannot show how

meikl ;-)
0
 
LVL 22

Accepted Solution

by:
Mohammed Nasman earned 200 total points
ID: 6321118
Hello

  for insert blow field into the database i use this code

Query1.Params[0].LoadFromFile('c:\pic.jpg',ftBlob);

this is to insert image into oracle database

Mohammed
0
 
LVL 27

Expert Comment

by:kretzschmar
ID: 6321151
:-))
whats a blow field, mohammed ?
0
Independent Software Vendors: We Want Your Opinion

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

 
LVL 27

Expert Comment

by:kretzschmar
ID: 6321164
just kidding, mohammed :-))
0
 
LVL 22

Expert Comment

by:Mohammed Nasman
ID: 6321189
lol, i mean blob field meikl ;O)
0
 
LVL 22

Expert Comment

by:Mohammed Nasman
ID: 6321207
I know meikl :o)
0
 
LVL 26

Expert Comment

by:Russell Libby
ID: 8733805
No comment has been added lately, so it's time to clean up this TA.
I will leave a recommendation in the Cleanup topic area that this question is:

Accept mnasman's comment as answer

Please leave any comments here within the next seven days.
 
PLEASE DO NOT ACCEPT THIS COMMENT AS AN ANSWER!
 
Thank you,
Russell

EE Cleanup Volunteer
0

Featured Post

How to Use the Help Bell

Need to boost the visibility of your question for solutions? Use the Experts Exchange Help Bell to confirm priority levels and contact subject-matter experts for question attention.  Check out this how-to article for more information.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

This article explains how to create forms/units independent of other forms/units object names in a delphi project. Have you ever created a form for user input in a Delphi project and then had the need to have that same form in a other Delphi proj…
Hello everybody This Article will show you how to validate number with TEdit control, What's the TEdit control? TEdit is a standard Windows edit control on a form, it allows to user to write, read and copy/paste single line of text. Usua…
How to fix incompatible JVM issue while installing Eclipse While installing Eclipse in windows, got one error like above and unable to proceed with the installation. This video describes how to successfully install Eclipse. How to solve incompa…
Screencast - Getting to Know the Pipeline
Suggested Courses

972 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question