| View previous topic :: View next topic |
| Author |
Message |
Dennis Landi
Guest
|
 Posted: Thu Apr 22, 2004 7:35 pm Post subject: Updating Paradox MemoField |
 |
|
I have scoured google, but don't really see a satisfactory answer:
The following code produces a "type mismatch in expression"
<snip>
Q.Close;
Q.SQL.Clear();
Q.SQL.Add('UPDATE "Invoice_Process.db" ' +
'SET Invoice_Worksheet = :ParamBlob '+
'WHERE ("Bill #" = :BillNum)');
q.ParamByName('BillNum').AsInteger := BillNum;
q.ParamByName('ParamBlob').asMemo := MyStringlist.text;
Q.Prepare;
Q.ExecSQL;
</snip>
Can anone show me how to update a Paradox memo field from a tQuery?
My version of the BDE is 5.01.
-dennis
|
|
| Back to top |
|
 |
Dennis Landi
Guest
|
| Posted: Thu Apr 22, 2004 8:01 pm Post subject: Re: Updating Paradox MemoField |
|
|
"Sverre Hårstadstrand" <sverreeh1 (AT) autocalc (DOT) no> wrote
| Quote: | Dennis Landi wrote:
Can anone show me how to update a Paradox memo field from a tQuery?
It seems to be the # in the fieldname "Bill #" that is your problem.
The rest of your code works OK here...
SverreEH
|
hmmm. I will check that out.
|
|
| Back to top |
|
|
Dennis Landi
Guest
|
| Posted: Thu Apr 22, 2004 8:21 pm Post subject: Re: Updating Paradox MemoField |
|
|
Sverre, you were correct. It seems the BDE LocalSQL requires this sort of
syntax:
"Invoice_Process.db"."Bill #"
when dealing with fieldnames in quotations....
Thanks!
-d
"Dennis Landi" <none[at]none.com> wrote
| Quote: |
"Sverre Hårstadstrand" <sverreeh1 (AT) autocalc (DOT) no> wrote in message
news:4088227f$1 (AT) newsgroups (DOT) borland.com...
Dennis Landi wrote:
Can anone show me how to update a Paradox memo field from a tQuery?
It seems to be the # in the fieldname "Bill #" that is your problem.
The rest of your code works OK here...
SverreEH
hmmm. I will check that out.
|
|
|
| Back to top |
|
|
|
FAQ
Search
Memberlist
Usergroups
Register
Profile
Log in to check your private messages
Log in
