Re: Updating records with SQL - saving issues

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

Well, in this case I'm updating 2 values: one coming from other inactive
"login" form with name of the person and the second is the system date from
the Date function. Not sure if I understand how I can let form handle the
updates. Thanks.

"Stuart McCall" wrote:

"valkor" <valkor@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:3338A82A-2EE6-4756-8F7B-60DB47AF760C@xxxxxxxxxxxxxxxx
Hi, I would really appreciate if someone could help me. I have a form with
current record displayed. I'm trying to update several fields on this
record
with SQL update statement by "runSQL" command. I'm getting message "Write
error" and options: "save changes", "drop changes", or "cancel". Than,
everything is changing to some weird characters. I realize I have some
kind
of conflict. This doesn't happen when fields I update locate in different
table. I really don't want to use seperate table just for a few fields. Is
there anyway I could avoid this issue? Thanks.

Why don't you let the form handle the updates? Just assign the values to the
form's controls, then issue the command:

Dirty = False

This will save the form's record.

Is that not what you want to achieve?



.

Relevant Pages

  • Re: Login session hasnt been abandoned after TIMEOUT time
    ... The login command is used at the beginning of each terminal ... session to identify oneself to the system. ... trying to kick off idle users. ...
    (comp.unix.solaris)
  • Re: Failsafe mode
    ... > and paste or failing that copy the message down character for ... >> If I exit out and log back in as my alternate user ... user command line prompt in the upper left corner and a black blank screen. ... If I ctl alt F1 I get the system login prompt. ...
    (alt.os.linux.suse)
  • Re: security
    ... a login and config apache to read the dir in his home dir. ... command or sequence of commands. ... To unsubscribe or change subscription options: ...
    (Fedora)
  • [HPADM] SUMMARY "Users not active"
    ... Sysadm guy setup to remove old login file and keep only the current dated ... you'll have to modify the script to use alternate wtmp files. ... Now if you run the logins command you can get more info... ...
    (HP-UX-Admin)
  • Re: Changed server NIC and IP address; cant connect to sql server
    ... Sqlcmd: Error: Microsoft SQL Native Client: Unable to complete login ... process due to delay in opening server connection. ... That is the command prompt, at which you can enter SQL commands. ...
    (microsoft.public.sqlserver.setup)