Solved

Visual Studio Visual Basic-- SQl  Update Statment

Posted on 2007-03-22
2
184 Views
Last Modified: 2013-11-26
I'm getting a syntax error near TransferGuestLedgertxt

.CommandText = "Update Settlement Set PreviouAdvDepositstxtTextBox= '" & PreviouAdvDepositstxtTextBox.Text & "' TransferGuestLedgertxt = '" & TransferGuestLedgertxt.Text & "', Where Sitetxt = 2 and PrimaryKey = (Select Max(PrimaryKey) from Settlement where SiteTxt=2)"

Thanks
0
Comment
Question by:fsuedu
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
2 Comments
 
LVL 6

Expert Comment

by:kerryw60
ID: 18774136
May need to specify your textbox is a string by

TransferGuestLedgertxt.Text.ToString()
0
 
LVL 9

Accepted Solution

by:
dbeneit earned 500 total points
ID: 18776414
.CommandText = "Update Settlement Set PreviouAdvDepositstxtTextBox= '" & PreviouAdvDepositstxtTextBox.Text & "',
................................................................-
 TransferGuestLedgertxt = '" & TransferGuestLedgertxt.Text & "'
........................................................................................................-
Where Sitetxt = 2 and PrimaryKey = (Select Max(PrimaryKey) from Settlement where SiteTxt=2)"

the ',' character
0

Featured Post

Salesforce Made Easy to Use

On-screen guidance at the moment of need enables you & your employees to focus on the core, you can now boost your adoption rates swiftly and simply with one easy tool.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

It was really hard time for me to get the understanding of Delegates in C#. I went through many websites and articles but I found them very clumsy. After going through those sites, I noted down the points in a easy way so here I am sharing that unde…
This article shows how to deploy dynamic backgrounds to computers depending on the aspect ratio of display
NetCrunch network monitor is a highly extensive platform for network monitoring and alert generation. In this video you'll see a live demo of NetCrunch with most notable features explained in a walk-through manner. You'll also get to know the philos…
This is my first video review of Microsoft Bookings, I will be doing a part two with a bit more information, but wanted to get this out to you folks.

617 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question