sql in delphi

Article View: comp.lang.pascal.delphi.misc

Article #62

Back to comp.lang.pascal.delphi.misc Previous Next

#62

From: Van Tyghem Sean
Date: Tue, 16 Jan 2001 22:47

30 lines
2242 bytes

Hello,

I'm working with d5 and paradox db
I have a table with several fields, one of them is a memo field.
The application first searches via a TQuery in a table for the correct record,
displays the memo in a DBmemo, and if I click the update checkbox, I copy it in
a normal memo. There I can modify the text and click a button to actually do the

update of the memo 

This is my sql-statement			
    UPDATE  "Table"	    Table is the name of the table, no alias (directory)
    set Memo = :VarMemo     Memo is field memo in table
    where Int = :VarInt	    Int is an integer field

    
This code is in the onclick event of the button
    QRY_Update.paramByName('VarMemo').AsMemo:= MEM_Memo.Text;         
    QRY_Update.paramByName('VarInt').ASinteger:= Number;
    QRY_Update.ExecSQL;

Now here is my problem
    If I look wats in the table after I did the update, everything is ok, but 
    after I close the application, no update has been done.

Can anyone show me what I'm doing wrong

Thanx in advance

sean

Technical Details

Message-ID: <3a64cc10.6250067@news.uunet.be>

Path:

arc1-ca.pugleaf.net!supernews.google.com!sn-xit-03!supernews.com!cyclone-sf.pbi.net!63.208.208.143!feed2.onemain.com!feed1.onemain.com!newsfeed.icl.net!newspeer.clara.net!newspeer2.clara.net!news.clara.net!newsfeed01.sul.t-online.de!t-online.de!news.csl-gmbh.net!newsfeed2.news.nl.uu.net!sun4nl!not-for-mail

Show Full Headers

Complete Article Headers

X-Google-Language: ENGLISH,ASCII-7-bit
X-Google-Thread: ff75c,12a4d2806f41ac6e,start
X-Google-Attributes: gidff75c,public
X-Google-Thread: ffff5,12a4d2806f41ac6e,start
X-Google-Attributes: gidffff5,public
X-Google-Thread: 10baee,12a4d2806f41ac6e,start
X-Google-Attributes: gid10baee,public
X-Google-Thread: 115d96,12a4d2806f41ac6e,start
X-Google-Attributes: gid115d96,public
X-Google-ArrivalTime: 2001-01-16 14:44:04 PST
Path: arc1-ca.pugleaf.net!supernews.google.com!sn-xit-03!supernews.com!cyclone-sf.pbi.net!63.208.208.143!feed2.onemain.com!feed1.onemain.com!newsfeed.icl.net!newspeer.clara.net!newspeer2.clara.net!news.clara.net!newsfeed01.sul.t-online.de!t-online.de!news.csl-gmbh.net!newsfeed2.news.nl.uu.net!sun4nl!not-for-mail
From: Van.tyghem.sean@uunet.be (Van Tyghem Sean)
Newsgroups: comp.lang.pascal.delphi.misc,borland.public.delphi.database,borland.public.delphi.database.desktop,comp.lang.pascal.delphi.databases
Subject: sql in delphi
Date: Tue, 16 Jan 2001 22:47:34 GMT
Message-ID: <3a64cc10.6250067@news.uunet.be>
X-Newsreader: Forte Free Agent 1.21/32.243
Lines: 30
NNTP-Posting-Host: uu212-190-11-177.unknown.uunet.be
X-Trace: 979684977 news.be.uu.net 4492 212.190.11.177