Delphi SQL Parameter Problems |
![]() ![]() |
Delphi SQL Parameter Problems |
Jul 11 2008, 06:11 AM
Post
#1
|
|
|
New Member ![]() Posts: 7 OS: Windows Vista Business SP 1 |
CODE procedure TMain.Button_LvlUpClick(Sender: TObject);
var Calc1 :Integer; Calc2 :Integer; begin FirstRun := False; Calc1 := 0; Calc2 := 0; OrderID:= SelectedID; EUorUS:= Grid.Fields[1].AsString; ServerName := Grid.Fields[2].AsString; CharName:= Grid.Fields[3].AsString; CharClass:= Grid.Fields[4].AsString; StartLevel:= IntToStr(Grid.Fields[5].AsInteger); EndLevel := IntToStr(Grid.Fields[6].AsInteger); CurrentLevel := (Grid.Fields[7].AsInteger); Progress:= IntToStr(Grid.Fields[8].AsInteger); Handler:= Grid.Fields[9].AsString; CurrentLevel:= CurrentLevel + 1; Calc1:= StrToInt(EndLevel) - StrToInt(StartLevel); Calc2:= (StrToInt(Progress) - (Calc1) - 1)*-1; Progress:= IntToStr(Calc2); ADOQuery1.Close; ADOQuery1.Parameters.Clear; ADOQuery1.Parameters[0].Value := Progress; ADOQuery1.Parameters[1].Value := CurrentLevel; ADOQuery1.Parameters[2].Value := OrderID; ADOQuery1.SQL[0] := 'INSERT INTO Orders (Progress, CurrentLevel) VALUES(:Progress, :CurrentLevel) WHERE OrderID = :OrderID'; ADOQuery1.ExecSQL; ADOQuery1.Close; ADOQuery1.SQL.Clear; ADOQuery1.SQL.Add('SELECT Orders.OrderID, Orders.[EU/US], Orders.ServerName, Orders.CharName, Orders.CharClass, Orders.StartLevel, Orders.EndLevel, Orders.CurrentLevel, Orders.Progress, Orders.Handler FROM Orders WHERE Orders.OrderID = :OrderID'); ADOQuery1.Open; end; |
|
|
Jul 13 2008, 10:36 AM
Post
#2
|
|
|
New Member ![]() Posts: 7 OS: Windows Vista Business SP 1 |
BUMP? ANYONE?
|
|
|
Jul 14 2008, 10:25 PM
Post
#3
|
|
![]() TA Moderator Posts: 1,281 From: SET HOMEPATH OS: Windows 95/98/2000/XP/Vista |
Hello Jack,
Could you tell us the exact error message you are receiving? Also, do you know which statement is causing the error? You can insert statements similar to the following to determine where it's coming from, if you don't have a debugger: CODE ShowMessage('Test 1'); Regards, Ax Edit: On closer inspection, it looks like you haven't set the OrderID parameter for the SELECT query. Try adding the following line of code: CODE ADOQuery1.Parameters[0].Value := OrderID;
|
|
|
![]() ![]() |
Similar Topics
| Topic Title | Replies / Views | Topic Information | |||||
|---|---|---|---|---|---|---|---|
![]() |
5 / 414 | 3rd January 2008 - 02:19 PM Linden started - last by Metallica |
|||||
![]() |
24 / 179 | 44 minutes ago Emma_uk started - last by Essexboy |
|||||
![]() |
4 / 44 | Today, 10:12 AM supernova87 started - last by Broni |
|||||
![]() |
1 / 17 | Today, 01:45 PM epaddison started - last by Essexboy |
|||||
|
Time is now: 9th January 2009 - 03:49 PM |
| Advertisements do not imply our endorsement of that product or service. The forum is run by volunteers who donate their time and expertise. We make every attempt to ensure that the help and advice posted is accurate and will not cause harm to your computer. However, we do not guarantee that they are accurate and they are to be used at your own risk. |