Improve company productivity with a Business Account.Sign Up

x
?
Solved

(Delphi5 + MySQL) with MyOLEDB

Posted on 2001-07-26
8
Medium Priority
?
244 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
7 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
Free Tool: ZipGrep

ZipGrep is a utility that can list and search zip (.war, .ear, .jar, etc) archives for text patterns, without the need to extract the archive's contents.

One of a set of tools we're offering as a way to say thank you for being a part of the community.

 
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

Free Tool: Subnet Calculator

The subnet calculator helps you design networks by taking an IP address and network mask and returning information such as network, broadcast address, and host range.

One of a set of tools we're offering as a way of saying thank you for being a part of the community.

Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

In this tutorial I will show you how to use the Windows Speech API in Delphi. I will only cover basic functions such as text to speech and controlling the speed of the speech. SAPI Installation First you need to install the SAPI type library, th…
Creating an auto free TStringList The TStringList is a basic and frequently used object in Delphi. On many occasions, you may want to create a temporary list, process some items in the list and be done with the list. In such cases, you have to…
From store locators to asset tracking and route optimization, learn how leading companies are using Google Maps APIs throughout the customer journey to increase checkout conversions, boost user engagement, and optimize order fulfillment. Powered …
Watch the video to know the process of migration of Exchange or Office 365 mailboxes in absence of MS Outlook. It is an eminent tool which can easily migrate Public, Archive user mailboxes from one another Exchange server and Office 365. Kernel Migr…

579 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