Solved

how to store path in databse file

Posted on 2013-05-20
2
378 Views
Last Modified: 2013-05-21
Hi All:
I'm trying to insert or update the logo file path in a database field. the syntax as following
update geninfo SET logo = "C:\logo.bmp";
its running Ok, but the value of this field='C:logo.bmp'.
where is the backslash??????
0
Comment
Question by:khaled salem
2 Comments
 
LVL 12

Accepted Solution

by:
jmcmunn earned 500 total points
ID: 39183073
Often, '\' is an escape character.  Have you tried doubling it up?

e.g. - C:\\logo.bmp
0
 
LVL 26

Expert Comment

by:Sinisa Vuk
ID: 39183448
...from code:
...
sSQL := 'update geninfo SET logo ='+QuotedStr(sImgPath);
qry.SQL.Text := sSQL;
...

Open in new window

0

Featured Post

Is Your Active Directory as Secure as You Think?

More than 75% of all records are compromised because of the loss or theft of a privileged credential. Experts have been exploring Active Directory infrastructure to identify key threats and establish best practices for keeping data safe. Attend this month’s webinar to learn more.

Question has a verified solution.

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

Suggested Solutions

Title # Comments Views Activity
automatically logging in via bde delphi 3 68
Delphi Dbf export problem to a Visual Foxpro application 6 161
Delphi : could not find program, '...exe' 2 147
Delphi 2 47
A lot of questions regard threads in Delphi.   One of the more specific questions is how to show progress of the thread.   Updating a progressbar from inside a thread is a mistake. A solution to this would be to send a synchronized message to the…
Introduction Raise your hands if you were as upset with FireMonkey as I was when I discovered that there was no TListview.  I use TListView in almost all of my applications I've written, and I was not going to compromise by resorting to TStringGrid…
When you create an app prototype with Adobe XD, you can insert system screens -- sharing or Control Center, for example -- with just a few clicks. This video shows you how. You can take the full course on Experts Exchange at http://bit.ly/XDcourse.
A simple description of email encryption using a secure portal service. This is one of the choices offered by The Email Laundry for email encryption. The other choices are pdf encryption which creates an encrypted pdf of your email and any attachmen…

911 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

Need Help in Real-Time?

Connect with top rated Experts

20 Experts available now in Live!

Get 1:1 Help Now