Re: Update on Your Request {40297}

Avatar
  • updated
  • Completed
Yes,
 
 
I am trying to set the IsVerified switch to ON 
for a set of members with
LocationID = '285'
RouteNo = '111000025' 
 
 
 
UPDATE Member
 SET Member.IsVerified = '1'
 
Select
  Member.LastName,
  Member.FirstName,
  Member.Barcode,
  Member.IsVerified
From
  Member Inner Join
  Bank On Member.BankID = Bank.BankID
Where
 Member.LocationID = '285' And
  Bank.RouteNo = '111000025' 
  
  

On Mon, 7 Dec 2015 21:59:47 -0500, ActiveDBSoft Support Team wrote:

Request Update View the complete request history

Hello, Kem.
You asked:

does this support the modifying of the SQL Text to Modify Data?

Yes, it does. Have you tried and failed to do this? Do you need any
assistance with editing SQL text or modifying data?

Sincerely
Sergey Smagin
Product Manager
Active Database Software
mailto: support@activedbsoft.com
web-site: http://www.activedbsoft.com/

--

Kem Sisson
President
Money Movers, Inc.
Sebastopol, CA 95473
support@moneymovers.com
http://www.moneymovers.com
(W) - (707)829-5577
(F) - (707)829-5522
(C) - (707)494-0993

CONFIDENTIALITY NOTE: This electronic transmission, including all
attachments, is directed in confidence solely to the person(s) to whom
it is
addressed, or an authorized recipient, and may not otherwise be
distributed, copied or disclosed. The contents of the transmission may
also be subject to
intellectual property rights and all such rights are expressly claimed
and are not waived. If you have received this transmission in error,
please notify the sender immediately by return electronic transmission
and then immediately delete this transmission, including all
attachments, without
copying, distributing or disclosing same.
Attachments:
2t3eaicqy3b7@hostingmail.earthlink.net.html
Avatar
Anonymous
Uh... I only speak english...
Attachments:
32izme83ct2t@hostingmail.earthlink.net.html
Avatar
Anonymous

You can change the language of support facility using the selector on top of the window.

Avatar
Anonymous

Oh, you talk about building data modification statements visually? This is not possible using FlySpeed SQL Query.