U++ forum: Welcome to the forum

Re: SQL, U++, and Escape Characters [message #3302 is a reply to message #3300]

Thu, 18 May 2006 20:05

Justin
Messages: 57
Registered: March 2006
Location: Orange County California

Member

Interesting, so my best bet is to just create some sort of validating function to automatically change the single quote to have an escape character in front of it?

Also, I have another question:

What is the syntax for the Update function for the SQL dialect. Here is what I use for Insert (Found it in the example),

sql*Insert(DB_NAME)(DB_CUSTNAME, ~supportmodify.edtName);

I am not sure how do to the same, but to update a particular record according to the primary key. I am assuming some sort of

sql*Update(DB_NAME)(DB_CUSTNAME, ~supportmodify.edtName)Where(DB_TICKET, ~supportmodify.lblTicket);

This example does not work however.

Justin

[Updated on: Thu, 18 May 2006 20:07]

Report message to a moderator